I'm in the process of trying to restore a database to make sure
I know how to do it, and am running into all kinds of problems.
Most of them detailed in another post I made yesterday.
One thing in particular is driving me NUTS. I've started sqlservr.exe
in single user mode (-m), and even verified this by trying to connect
twice. The second connection always fails.
Then I issue a RESTORE DATABASE command (NORECOVERY), and that works OK.
Then I try to issue a RESTORE LOG command, and I get the following
Server: Msg 4316, Level 16, State 2, Line 1
Can only RESTORE LOG in the master database if SQL Server is in single
This makes no sense to me, for two reasons:
1. I'm running SQL Server in single user mode...
2. I'm not trying to RESTORE LOG in the master database, I'm trying
to do it for one of user databases.
When I run these commands in Query Analyzer, the 'master' database
is selected, but the commands specify the database name, so it shouldn't
matter, right? (i.e. RESTORE LOG archive ...).
On top of that, I don't have much choice of where I run these commands
from, because I can't switch to the 'archive' database while it is in
Boy these errors are frustrating... anyone know what the heck
I'm doing wrong?
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.