Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-02 : 08:14:44
|
shay writes "Hello
I implimented alog shipment for sql7 server.
what I did is:
1.every night at 2 p.m the production server runs ajob that does the following:backup the database to abackup device
copy's the device to standby server
calls astored procedure on the standby server which restores the backup (on the standby server).
2.Every day the between 7.00 am to 21.00 pm the production server runs ajob to backup the Tansaction Log to adevice and then copy the device to astandby server.
all backups of logs are pointed to one device and suppose to contain all changes from 7.00 am.
The job runs every 15 minutes.
that is how I wrote it:
"BACKUP LOG %DatabaseName% to %BackupDeviceName% WITH INIT,NO TRUNCATE".
what I had in mind is that since I Backup all transaction log changes to one device I'll have to restore only one device on standby server.
but it doesn't work.
when I got to my standby server I tried to restore the log backup device (the database was already restored automatically from the last night backup) but the message I got is:
"THIS BACKUP SET CANNOT BE RESTORED BECAUSE THE DATABSE HAS NOT BEEN ROLLED FORWARD FAR ENOUGH.YOU MUST FIRST RESTORE ALL EARLY LOGS BEFORE RESTORING THIS LOG".
what I don't understand:
There is no earlier log backup.
I thought that what I did saves all log changes from last backup.
Where is my mistake???
I'll epriciate any enlightment.
Thanks
" |
|
|
|
|
|
log shipment