March 4, 2011 at 11:44 pm
[font="Arial"]
Hi Team,
I am unable to restore the database from bak file.
I have schedule the backup of the content db through a schedule tasks in Management Studio.
Now, when I try to restore the FULL BACKUP DB it keeps throwing me the following error message after reaching to 60% of restoration.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'xxxxxxxxx'. (Microsoft.SqlServer.Smo)
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: RESTORE detected an error on page (0:0) in database "XXX_Content" as read from the backup set. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4266.00&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------[/font]
March 28, 2011 at 5:17 pm
It really sounds like your backup file is corrupted and won't be able to be restored. Have you tried a restore verifyonly? Also, is a checkdb against the database ok?
March 28, 2011 at 5:46 pm
<EDIT SNIP TRIM WHACK HACK... I'm not sure it was 2k'able anyway...>
EDIT: Annnnddd, this thing's over a month old. Sorry for helping with the Necro here.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
March 29, 2011 at 12:06 am
Craig, check the version in the error, it's a 2005 server.
Backup damaged, get a new 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
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply