CDC Interoperability with Mirroring and Recovery

CDC Interoperability with Mirroring and Recovery The following email came in to a discussion group last week asking several questions about CDC including the interoperability of CDC and database mirroring. The email: Dear experts Here are some questions regarding CDC in SQL Server 2008: What will happen to CDC if we truncate or backup database log files? Will the operation wait for CDC log parser to complete all of the transactions? If disaster occurs, what will happen to CDC and
read more

How do I … Write a Backup Strategy?

How do I … Write a Backup Strategy? How do I Write a Backup Strategy? DBA’s harp about the need to have backups. The first thing many DBA’s do when they inherit a new SQL Server is to check to see that the databases have backups. I’m not backing off of that assertion now. I’m offering advice on how to determine the best backup strategy for your system. The best advice for how to develop the optimum backup strategy is to not try
read more

Top 6 Myths of Transaction Logs

Top 6 Myths of Transaction Logs I think there is a lot of misunderstanding concerning database transaction logs in SQL Server. I had intended to write this as the top 5 myths, but I wasn’t able to narrow the list down that far. Myth #6: I added additional log files to my database for better performance. The truth: SQL Server will only use a single log file at a time. You will not see any performance gain no matter how
read more