Very Computer

Hello,

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
error message:

Server: Msg 4316, Level 16, State 2, Line 1
Can only RESTORE LOG in the master database if SQL Server is in single
user mode.

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
NORECOVERY mode.

Boy these errors are frustrating... anyone know what the heck
I'm doing wrong?

Thanks,
Thomas

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.

But on the other hand you do not need to be in the single user mode to
restore the other databases, right?

--
Mladen Turk, GISDATA d.o.o
MCSE/GIS Specialist
Bastijanova 52a, 10000 Zagreb, Croatia

http://www.gisdata.com
http://www.gisdata.hr

Thomas - Singel user mode is for recovering the master db. If you want
to restore a user db set it to "DBA use only" and maybe to "singel
user".
You start the MSSQLServer as usual then apply the above. "DBA use only"
stops further logs in to the database but dosen't stop the current ones
loged in. "Singel user mode" requires that your the only one using the
database.
After that apply the full dump + the T-logs you want.

:-) Myggan

--

or just post it.

Sent via Deja.com http://www.deja.com/
Before you buy.

Quote:> > 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.

> But on the other hand you do not need to be in the single user mode to
> restore the other databases, right?

Ahhhhhh hmmmmm, I didn't realize that! I'll try it in
regular mode. But I still don't understand how those
error messages apply. It doesn't seem like it should
hurt to be in single user mode.

-thomas

Sent via Deja.com http://www.deja.com/
Before you buy.

Thanks for the advice, I'll give that a try!

Quote:> Thomas - Singel user mode is for recovering the master db. If you want
> to restore a user db set it to "DBA use only" and maybe to "singel
> user".
> You start the MSSQLServer as usual then apply the above. "DBA use
only"
> stops further logs in to the database but dosen't stop the current
ones
> loged in. "Singel user mode" requires that your the only one using the
> database.
> After that apply the full dump + the T-logs you want.

> :-) Myggan

Sent via Deja.com http://www.deja.com/
Before you buy.