hi all,
i have SQL 2000 server with SP3, yesterday my database was suddenly goes to suspect mode. then i found log in sql server log. and it shows following text:
I/O error (bad page ID) detected during read at offset 0x00000000030000 in file 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\MFS_Data.MDF'..
kindly, do needful for recover data from this file...
Tejas Kishanwala
You will need to restore your backups to recover the database.|||hi,
thanx for giving answer. but i have backup before 1 week. and my all important data is in the database. i have already resotred by backup. but is there any way to read this MDF file Manually and retrive data from it.?
Kindly, do needful for the same.
Tejas Kishanwala
|||http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=616836&SiteID=1
No comments:
Post a Comment