Will this break log shipping? - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

High Availability (2005)

Will this break log shipping?

Author

Topic

patshaw
Posting Yak Master

177 Posts

Posted - 2008-10-03 : 13:58:15

If I issue a backup with truncate only followed by DBCC Shrinkfile on the transaction logs on the DR (secondary) server, will this break log shipping in any way?

Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-10-03 : 14:03:26

Yes. You will break the transaction log chain due to the truncate, which means log shipping will be broken. You would have to start over with log shipping as you'd need to start with a full backup.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

patshaw
Posting Yak Master

177 Posts

Posted - 2008-10-03 : 14:08:09

Thanks Tara.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources