GUI backup faster than Script

BgfreemanBgfreeman Posts: 21
edited January 20, 2011 9:30AM in SQL Backup Previous Versions
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?

Comments

  • peteypetey Posts: 2,358 New member
    One way to determine the cause of the speed difference would be to compare the SQL Backup log files for both the backup processes.

    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.
    Peter Yeoh
    SQL Backup Consultant Developer
    Associate, Yohz Software
    Beyond compression - SQL Backup goodies under the hood, updated for version 8
Sign In or Register to comment.