Question :
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.
Answer :
Reference:
- 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.
This was a mere co-incidence. Both backup and restore are 2 different tasks which depend on various factors.
10GB is fairly small. I’ve backed up and restored databases into the hundreds of gigabytes and I’ve seen big differences in backup speeds among different databases on the same server and between backing up a database and restoring it to another server.