GUI backup faster than Script
Bgfreeman
Posts: 21
We are on 6.4.
If I backup a database using the GUI, it completes in around 4 minutes.
Backing up the same database using the script generated by the GUI takes around 35 minutes.
I can reproduce this and it's the same for any given database, time differing based on database size.
Doesn't matter if the script is run in SSMS on the SQL Server itself or a client PC.
Why should the script run so much slower?
If I backup a database using the GUI, it completes in around 4 minutes.
Backing up the same database using the script generated by the GUI takes around 35 minutes.
I can reproduce this and it's the same for any given database, time differing based on database size.
Doesn't matter if the script is run in SSMS on the SQL Server itself or a client PC.
Why should the script run so much slower?
Comments
The default folder where the logs are stored is C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance name> on Windows 2003 and older, and C:\ProgramData\Red Gate\SQL Backup\Log\<instance name> on Windows Vista and newer.
You should be able to tell if its the backup speed that differs, or one or more of the other pre or post backup processes that SQL Backup runs.
Thanks.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8