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
 General SQL Server Forums
 New to SQL Server Programming
 logshipping

Author  Topic 

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2009-06-06 : 02:18:17
I hava 2 questions on logshipping

If we add a new datafile to primary server database, will logshipping break? what happens to logshipping

And what are ways to breaking logshipping ? other than disabling

mcrowley
Aged Yak Warrior

771 Posts

Posted - 2009-06-09 : 09:44:10
While I have never tried it, it should nto break anything, so long as the path to the new file exists on the machine you are sending transaction logs to.

Truncating the transaction log in any way on the primary server will break log shipping. Also lost logs. If you run out of space anywhere, be careful what you delete.
Go to Top of Page

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2009-06-09 : 14:07:43
thanks much
Go to Top of Page

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2009-06-11 : 13:05:32
Hi Mcrowley,

I found a article...Logshipping cannot handle database file operations, such as adding files etc.
http://sql-articles.com/index.php?page=articles/diffdbmrr.htm

Just wanted to share with you, Thanks!
Go to Top of Page
   

- Advertisement -