2

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.

  • Was it a full backup? – Marco Apr 30 '18 at 13:58
  • I use the time for a backup to be a rough estimate of restore time, but it's not guaranteed. For example, I'm usually backing up all my servers at around the same time, so my backups tend to be slower than restores. – Jonathan Fite Apr 30 '18 at 14:16
  • 1
    I wouldn't even take backup as a rough estimate for restore. So many things can impact this (striping, disk types, backup settings, backup type, instant file init on/off, number of tran log changes, etc.) – LowlyDBA Apr 30 '18 at 15:19
5

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.

3

This was a mere co-incidence. Both backup and restore are 2 different tasks which depend on various factors.

1

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.

  • Yes , I need to read more and more on this. Thanks much – DBOn May 8 '18 at 14:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.