June 21, 2011 at 4:29 am
Hello experts,
I tried to attach a Dabase which is in my Portable HardDisk. But Im getting an error saying 'Attach Database Failed' and noticed the error code as 824. Im just a begginger in Databases. Please help me to solve the issue ASAP.
NOTE: PFA about the error
Thanks in advance,
Sathish.K
June 21, 2011 at 4:35 am
June 21, 2011 at 12:33 pm
Jayanth_Kurup (6/21/2011)
you need to copy the database files onto the disk of the machine hosting sql server. u cannot run sql database on protable media
Completely false. I often run database files on external hard drives or flash drives. It's network shares where you can't have database files (and even that's no longer true in R2).
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 21, 2011 at 12:35 pm
sathish2109 (6/21/2011)
I tried to attach a Dabase which is in my Portable HardDisk. But Im getting an error saying 'Attach Database Failed' and noticed the error code as 824. Im just a begginger in Databases. Please help me to solve the issue ASAP.
That's bad database corruption. The database will not attach cleanly, we might be able to get it attached, but it will almost certainly be suspect.
Do you have a backup? Quickest and likely best will be to restore from backup.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 27, 2011 at 7:39 am
Sorry for the late reply. I received the backup for the database fom my source peoples. Issue solved. Thanks all for your sugessions:-)
Regards,
Sathish.K
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply