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.
Best Answer
Reference:
They are not equal and yes they can (and most likely always) differ.
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.