• Michael Valentine Jones (8/24/2012)


    You should run a copy_only backup to the nul device to see if the problem is reading the database data or writing the backup file to disk.

    backup database [MyDatabase] to disk = N'NUL' with copy_only, stats = 10

    This will tell you how long it takes to read the data from the disk and if that is the problem.

    If it is fast, then the problem is more than likely writing the backup to your backup file.

    Make sure that you use the COPY_ONLY option so that SQL Server does not see that as part of the backup chain.

    Now that is a really good suggestion!!

    I will do so. My test that I mention at the beginning has copy_only so I am good with that.

    Michael B
    Data Architect
    MCT, MCITP(SQL DBA 2005/2008),MCTS, MCP,MCDBA