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
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
Find out how to restore data from a corrupt database.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.