SQL backup files takes a long time to restore
Posted on 2003-11-03
I am making backups of my SQL database nightly. However, when I try to restore one of these files, it takes a long time to restore. The status bar does not move at all for a very long time .. and it looks like it got hung up...but then it does finally finish.
The backup file is approx. 1 GB. Are there certain settings to set in SQL that makes database better/ tweaks it so that it restores faster? I remember restores for files from a copy of this SQL database tooks much faster, and the backups took less space as well. I am guessing there are ceratain performance tweaks set in one and not in the other.
Are there any suggestions that would help performance and speed? Thanks.