October 15, 2008 at 10:13 am
Is it a disk backup or a tape that you are restoring from?
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
October 15, 2008 at 11:22 am
DId you try
RESTORE HEADERONLY FROM backupDevice
October 15, 2008 at 11:48 am
I think you need to use the 'WITH REPLACE' argument of RESTORE DATABASE. Here's a thread that discusses the same subject: http://www.sqlservercentral.com/Forums/Topic490956-357-1.aspx
Greg
October 15, 2008 at 12:59 pm
Thanks for your help, its a disk backup I am restoring from. I can confirm the ldf and mdf files are in the original locations as on the other server.
October 15, 2008 at 1:08 pm
Two things. One, have you looked up master database in BOL? It talks about restoring the master database. Two, when you started SQL Server to restore the master database, did you bring it up in single user mode?
😎
October 15, 2008 at 1:26 pm
Hi Lynn,
I am familiar with the procedure in 2000 and have read on 2005, SQL is running in single user mode unfortunately. Whats more confusing is I have been able to simulate a master database restore following this issue by backing up the master database on the server and then restoring in single user mode.
Any help would be appreciated ?
October 15, 2008 at 1:31 pm
What is the result of running the following from an earlier post?
RESTORE HEADERONLY FROM backupDevice -- replace backupDevice with the filename of the backup diskfile.
Viewing 7 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply