Can someone help me here, I'm geting this while trying to execute SLS.

Backing up t to DISK=\\db2d\c$\t_20031208_0734_LOG.BAK
BACKUP LOG successfully processed 0 pages in 0.058 seconds (0.000 MB/sec).
Execute [db2d].master.dbo.sp_ApplyStandByLog
N't',N'\\db2d\c$\t_20031208_0734_LOG.BAK',N'c:\t_u ndo.dat'
Executing RESTORE LOG t FROM DISK='\\db2d\c$\t_20031208_0734_LOG.BAK' WITH
STANDBY='c:\t_undo.dat
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.
Server: Msg 3101, Level 16, State 1, Line 1
Exclusive access could not be obtained because the database is in use.
Server: Msg 2754, Level 16, State 1, Line 1
Error severity levels greater than 18 can only be specified by members of
the sysadmin role, using the WITH LOG option.
Server: Msg 50000, Level 19, State 1, Procedure sp_ShipLog, Line 85
sp_ShipLog Error 2754 occurred on database t to server db2d using backup
file \\db2d\c$\t_20031208_0734_LOG.BAK


Thanks in advance

Not precisely a cluster problem, but at least a SQL one.

You need to have all the users out of the target database when you do a log
restore. A good way to do this is to take the database offline and back
online

ALTER DATABASE [db2d] SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE [db2d] SET ONLINE

Warning: This will terminate any queries running against the target
database. Use with caution.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com


"John Smith" <someone (AT) microsoft (DOT) com> wrote

I guess you not really familiar with SLS, and no I do not need to take
database offline, 'cause if I do I'd get an error saying that it can not do
my transaction due to database appears to be offline. This is definatly not
a solution.

Anyone else?



"Geoff N. Hiten" <SRDBA (AT) Careerbuilder (DOT) com> wrote

btw,

the other database (where I'm trying to restore to) is in read-only mode,
that allows me to made futhure restoration of database without bringing it
offline




"Geoff N. Hiten" <SRDBA (AT) Careerbuilder (DOT) com> wrote

The second line in my example brings the database back online. You are
correct in that you cannot restore to a database that is offline. The
purpose of taking the DB offline is to clear out the users which are
preventing you from restoring the transaction log. You then bring it
immediately back online and restore the log(s).

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com


"John Smith" <someone (AT) microsoft (DOT) com> wrote

I end up with exact same error..


"Geoff N. Hiten" <SRDBA (AT) Careerbuilder (DOT) com> wrote

Somebody has a query that is jumping back into your database as soon as it
comes back online. Use sp_who2 to determine who is in the database. Maybe
a scheduled job or other automatic process.

--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com


"John Smith" <someone (AT) microsoft (DOT) com> wrote