In SQL 2005, what things should you not do with the database on which logging is enabled (and works under the full version)?
I understand that scheduling additional backups of the transaction log elsewhere will result in failure of the log delivery (since the full chain of logs no longer reaches the secondary server).
I also collect that the Truncate table is in order with log delivery (starting with Sql 2000).
Are there any other actions / commands that should be avoided?
edit: for example, a crash in database shrinking or log shrinking?
source
share