How can we help you today? How can we help you today?

GUI backup faster than Script

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?
Bgfreeman
0

Comments

1 comment

Sort by
  • petey
    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.
    petey
    0

Add comment

Please sign in to leave a comment.