Home Forums SQL Server 2005 Administering Backup RE: Backup

  • August 26, 2010 at 3:13 am

    #1212150

    GilaMonster (8/26/2010)

    What's the wait type for the process while that backup is running?

    Edit: Is that extra quote in your statement a typo?

    Should be

    BACKUP DATABASE 'Databasename' TO DISK = 'E:\'filename.BAK'

    not

    BACKUP DATABASE 'Databasename' TO DISK = 'E:\'filename'.BAK'

    I will run the job again tomorrow morning and see what the wait type for the process is and also I will check to see if there are any other processes that is blocking the job.

    Thank you.