Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Backups and logshipping

Author  Topic 

Posting Yak Master

186 Posts

Posted - 2004-08-20 : 10:23:51
If a backup is part of the log shipping maintenace plan does it get automatically moved and applied?


1870 Posts

Posted - 2004-08-20 : 11:41:04
Depending on your setup, yes, that is the general idea.

Moo. :)
Go to Top of Page

Almighty SQL Goddess

38200 Posts

Posted - 2004-08-20 : 13:08:52
If you are referring to the full backup and log shipping with Enterprise Edition, then no it does not. Only tlogs get copied over and applied. You will want to create a job that moves the full backup over, but you will not need to apply it as you only need to continuously apply the chain of tlogs.

Go to Top of Page

- Advertisement -