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 2000 Forums
 SQL Server Administration (2000)
 SQL Server Log Shipping

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-07-13 : 10:13:49
Dave J writes "Hi,

I've recently applied changes to a log shipping environment and lo' the changes broke the log shipping. I'm trying to trace why so I can be proactive the next time I get changes. Having to take log shipping down every time I apply changes is not really the way I want to go.

My question is : Is there a definitive list of activities, commands that can or may bring down log shipping and if so is this list available to use.

MTIA

Dave"

MuadDBA

628 Posts

Posted - 2004-07-13 : 11:41:07
Any operation that interferes with the continuity of your transaction log backups is going to do that. Any non-logged transaction will honk it up, which is why you can't have your select into/bulk copy option checked in sql 7.0

What did you do the first time?
Go to Top of Page
   

- Advertisement -