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
Related Q&A from Greg Robidoux
Find out how to restore data from a corrupt database.continue reading
Restore backups in SQL Server 2000 and SQL Server 2005 with this command.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.