SQL2k Backup error

  • Today I found my SQL2K had any error as below,

    1. Envrionment: SQL2K+Win2k3 sp2

    2. Event View:

    Event Type:Error

    Event Source:MSSQLSERVER

    Event Category:(2)

    Event ID:17055

    Date:08/12/17

    Time:01:20:00

    User:NT AUTHORITY\SYSTEM

    Computer:SERVERNAME

    Description:

    18204 :

    BackupDiskFile::CreateMedia: Backup device 'D:\Backup\DBD01' failed to create. Operating system error = 32(error not found).

    Event Type:Error

    Event Source:MSSQLSERVER

    Event Category:(6)

    Event ID:17055

    Date:08/12/17

    Time:01:20:00

    User:NT AUTHORITY\SYSTEM

    Computer:SERVERNAME

    Description:

    3041 :

    BACKUP failed to complete the command BACKUP DATABASE [DBD00] TO DISK = N'D:\Backup\DBD01' WITH INIT , NOUNLOAD , NAME = N'DBD00 backup2', NOSKIP , STATS = 10, NOFORMAT

    Can anyone give me any help? Tks!

  • It looks like the file is in use by another program. please see if the file is in use by some other program. Try running with different backup file name

  • Thanks Vee, today is success after reboot server,i'm watching next backup schedule!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply