patternsqlMinor
Is Database Backup Time = Restore Time in SQL Server?
Viewed 0 times
sqltimedatabaseserverrestorebackup
Problem
I have a SQL Server Database with 10 GB size. When I performed a backup, it took almost 3-4 minutes. When I tried to restore, it took almost the same 3-4 minutes.
Does this mean backup and restore times of a SQL Server database are always equal, or can they differ?
Kindly suggest and point me the logic behind.
Does this mean backup and restore times of a SQL Server database are always equal, or can they differ?
Kindly suggest and point me the logic behind.
Solution
Reference:
Does this mean backup and restore times of a SQL Server database are
always equal, or can they differ?
They are not equal and yes they can (and most likely always) differ.
Kindly suggest and point me the logic behind.
If you read the article from SQLSKills Paul Randal gave high level steps performed during a backup and restore. Which should explain why timing for these two operations are not same.
- SQLskills SQL101: Why is restore slower than backup
- Backup Time vs Restore Time
- How long will this sql server restore take?
Does this mean backup and restore times of a SQL Server database are
always equal, or can they differ?
They are not equal and yes they can (and most likely always) differ.
Kindly suggest and point me the logic behind.
If you read the article from SQLSKills Paul Randal gave high level steps performed during a backup and restore. Which should explain why timing for these two operations are not same.
Context
StackExchange Database Administrators Q#205355, answer score: 5
Revisions (0)
No revisions yet.