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