• Hi Sameer,

    The size of the database is 112 GB. However there was no previous backup in the drive.(Infact all 353 GB space is free). If I run the backup from QA with the following command [ I have restarted the backup with FORMAT option and now it is in the processes of backing up(Without NOSKIP).]

    BACKUP DATABASE [xxx_OR] TO  DISK = N'K:\MSSQL\Bkup\xxx_OR\xxx_OR_200512010117.BAK' WITH  INIT ,  NOUNLOAD ,    STATS = 10,  FORMAT.

    The backup was successful now(used FORMAT instead of NOFORMAT). I wonder what could be the reason

    Thanks in advance

     


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me