Prev: Min Value Function
Next: Alter table Add column to merge publication
From: iNewbie on 31 Mar 2010 09:29
Buenos dias! estoy intentando configurar un log shipping desde un sql 2005
(primario) a un sql 2008 (secundario). Se configura todo bien, los jobs se
crean perfectamente, los agentes usan una cuenta del

Hi! i'm trying to setup log shipping between a sql server 2005 (primary) and
a sql server 2008 (secondary). Everything is setup OK, jobs are created on
each server, the sql agent in both servers run with the same domain account
and have the necesary privileges on the folders they need. The Copy job on
the secondary server (the 2008) works ok and copies the files. The Restore
Job runs OK, BUT, it doesn't restore anything. Always says that there is
nothing to restore, like this:

2010-03-31 10:00:13.15 Searching through log backup files for first log
backup to restore. Secondary DB: 'TestLS'
2010-03-31 10:00:13.17 Skipped log backup file. Secondary DB: 'TestLS',
File: 'G:\LogShipping\TestLS\TestLS_20100331123013.trn'
2010-03-31 10:00:13.18 Skipped log backup file. Secondary DB: 'TestLS',
File: 'G:\LogShipping\TestLS\TestLS_20100331124513.trn'
2010-03-31 10:00:13.20 Could not find a log backup file that could be
applied to secondary database 'TestLS'.
2010-03-31 10:00:13.20 The restore operation was successful. Secondary
Database: 'TestLS', Number of log backup files restored: 0
2010-03-31 10:00:13.21 Deleting old log backup files. Primary Database:
'TestLS'
2010-03-31 10:00:13.21 The restore operation was successful. Secondary ID:
'1984216d-ccb4-4680-908e-a0683a2ee79a'
2010-03-31 10:00:13.22 ----- END OF TRANSACTION LOG RESTORE -----
Exit Status: 0 (Success)

do you have any idea what can be causing this? Also, i must say that this
database is a new one, there is NO backup running, i say this 'cos i read
somewhere that if you have another backup running it empties the log and so
the log shipping doesn't have anything to restore, but this is not the case.

any thoughts are welcome!

thanks! :D

 | 
Pages: 1
Prev: Min Value Function
Next: Alter table Add column to merge publication