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 |
|
uberman
Posting Yak Master
159 Posts |
 Posted - 2008-07-15 : 10:49:55
|
| I have set up log shipping from a Primary to a Secondary Server using LiteSpeed. This is all well and working.I also want to have a full daily backup to transfer to a tertiary server that is physically distant (if we have to fall back to the tertiary server the very least of our problems is that the data is 24hrs out of date rather than 10mins, also we currently have only 2 LiteSpeed licences so configuring it as another secondary is not an option).From where do I take this full backup? If I take it from the Primary will it interfer with the log shipping? Can I take it from the Secondary even though it is in a permenantly restoring state? Or should I leave it a read-only state to take the full backup from?Any other suggestions?NOTE: This is SQL 2000 NOT 2005! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-15 : 12:52:42
|
| Only transaction log backups outside of the log shipping plan break log shipping if you don't manually apply them. So full backups are fine on the primary server.If your secondary database is in the standby state, then you can also take a full backup there.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
uberman
Posting Yak Master
159 Posts |
Posted - 2008-07-16 : 03:48:25
|
| Many hanks Tara. |
|
|
|
|
|
|
Log Shipping + extra full backup