December 15, 2005 at 2:06 pm
Hi,
Due to a disk failure I am restoring everything. I reinstalled sqlserver, brought it up to SP 3a and one hotfix to get it to the configuration at failure, then restored master from a backup one day before the failure. SQLserver fails immediatedly with eventid 17055, error 9003. I thought maybe installing sp 4 would fix it but that hangs on validating login. Any hope? What now?
December 15, 2005 at 3:18 pm
Found this... never tried it myself but since you're running short of options...
http://geekswithblogs.net/travis/archive/2005/07/27/48400.aspx
BTW, you'll need to get SQL Server back to the build it was at when the restore was taken. That's based on:
You cannot restore system database backups to a different build of SQL Server (264474)
K. Brian Kelley
@kbriankelley
December 15, 2005 at 3:50 pm
Thanks, I tried starting sqlserver with sqlservr.exe -T3608 but it failed:
Recovering only master database
Starting up database 'master'.
Error: 9003, Severity: 20, State: 1.
Cannot recover the master database. Exiting.
I did load the sp3a and one hotfix to get the correct build, so it restored from backup. (Before that I tried to be clever and install sp4 but the build didn't match and restore refused to work.)
December 15, 2005 at 3:52 pm
Microsoft support then looks to be your best option.
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply