all groups > sql server replication > july 2004 >
You're in the

sql server replication

group:

log shipping



log shipping bmurtha
7/29/2004 5:40:17 PM
sql server replication: I have one maintenace plan that backs up the transaction
logs to a network drive:
\\ds1\e$\backup\db1\transact

My log shipping is not working the LSN are not lining up.
I'm guessing because it's pointed at a local drive:
E:\SQL\Logs

My question is this the cause of my problem do both
maintenance plans have to point at the same directory?

Regards,
log shipping anonymous NO[at]SPAM discussions.microsoft.com
7/29/2004 6:58:35 PM
When I try to apply the logs manually it says:

Server: Msg 3101, Level 16, State 1, Line 1
Exclusive access could not be obtained because the
database is in use.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE LOG is terminating abnormally.

Yet I did the restore with Standy=
Several of the logs were applied according to the log
shipping monitor. What could cause it to suddenly come out
of the proper mode?

Thanks,
Bryan
[quoted text, click to view]
Re: log shipping Paul Ibison
7/30/2004 9:05:28 AM
Bryan,
any connections to the database will prevent the required exclusive lock.
Have a look in the current activity window to see who it is and kill their
process. After that the restore should function correctly.
HTH,
Paul Ibison

AddThis Social Bookmark Button