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 |
|
raguyazhin
Posting Yak Master
105 Posts |
 Posted - 2011-06-25 : 07:01:41
|
| Hi how to configure log shipping with out affecting regular backup plan in sql server 2005 EE SP4--Ragu |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-06-25 : 09:32:56
|
| Log shipping won't impact full or differential backups. It would replace any existing log backup plan you have, more or less, as it handles those backups for you. As long as the log shipping jobs remain active you'll be covered.You could modify existing log backup jobs to check the log shipping tables: http://msdn.microsoft.com/en-us/library/ms175106.aspxAnd have it skip over any databases that are being log shipped. If the log shipping is deactivated, that job would detect it and back up the log accordingly. I've done this a few times and it works well. |
 |
|
|
|
|
|
Logshipping