sql server replication: Can the use of Shrinkfile break the Transaction Log chain? -- sql server replication

Can the use of Shrinkfile break the Transaction Log chain?

GRP
6/30/2005 5:57:02 AM

sql server replication: My Log Shipping process has been up and running fine for about 6 months now.
Then as part of the preparation for upgrading the front end application for
the log shipped database, my partner DBA thought he would help the backup
speed by running a SHRINKFILE over the database files.

It was on or about this time that log shipping stopped working and reported
errors just like the ones you get when the transaction log has been
truncated. Basically it thinks the T Log chain has been broken.

Can SHRINKFILE break the chain? I thought it only compacted the unused file

Re: Can the use of Shrinkfile break the Transaction Log chain?

GRP
6/30/2005 11:05:01 AM

Hilary, thanks for taking the time to test this out. The only other
explanation I can think of is that the other DBA truncated the log prior to
the shrinkfile.

[quoted text, click to view]

Re: Can the use of Shrinkfile break the Transaction Log chain?

Hilary Cotter
6/30/2005 1:50:06 PM

In my tests log shipping was not sensitive to shrinkfile statements. Perhaps
something else has gone wrong.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.