Backup faild..Amazing reason of space (Actually i have seen that there are lots of space on the disk.)

  • I got error like following :

    Failed:(-1073548784) Executing the query "BACKUP DATABASE [MLM2_combin_20080401_153906] TO DISK = N'F:\\DEV\\SQL Backup\\Full\\Week3\\MLM2_combin_20080401_153906\\MLM2_combin_20080401_153906_backup_200811160300.bak' WITH NOFORMAT, NOINIT, NAME = N'MLM2_combin_20080401_153906_backup_20081116030004', SKIP, REWIND, NOUNLOAD, STATS = 10

    " failed with the following error: "Write on "F:\\DEV\\SQL Backup\\Full\\Week3\\MLM2_combin_20080401_153906\\MLM2_combin_20080401_153906_backup_200811160300.bak" failed: 112(There is not enough space on the disk.)

    BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

    Actually i have seen that there are lots of space on the disk.

    Please give me solution...

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • If you ran that BACKUP command manually, does it still give you the error?

    Maybe someone cleaned out some space?

    And make sure it is writing to the correct location (namely, F drive on the SQL Server)

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005
  • it could be the backup is larger than the free space available!!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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