June 12, 2008 at 8:22 am
Appears to have been truncated by operating system. the expected size
is X but acctual size is y.
Could not open new database(Z:\MyData.mdf). create database is aborted(error:5125)
June 12, 2008 at 12:02 pm
Do you have a backup of this database? if yes then you can restore it:)
Razi, M.
http://questivity.com/it-training.html
June 13, 2008 at 3:34 am
Dear Raziuddin,
Thanks for reply, Acctually i don't have backup of this database. This problem occured may power failuer or virus in the system.
June 13, 2008 at 3:43 am
If you don't have any backup (why not?) then you are very likely out of luck.
You can try the following.
Create a new database with the same number of that the corrupt DB has. Shut SQL down
Replace the files of the newly created DB with the ones from the corrupted DB
Restart SQL
It's not guarenteed to work. I seem to recall reading somewhere that the size check is done every time the database is opened.
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply