It seems that with log shipping (set to one minute intervals) I could still have, say, three out of the five databases ship their 2:05 log before a failure, which would leave the other two databases sitting at 2:04. This would basically leave the system out of sync. Am I missing something in the setup?
Do you have comments on this Ask the Expert Q&A? Let us know.
Dig deeper on SQL Server Backup and Recovery
Find out how to restore data from a corrupt database.continue reading
Synchronize databases on separate servers without using SANs. Learn options for server failover in SQL Server including log shipping, database ...continue reading
Back up tables from a SQL Server database to a file with these commands.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.