Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backup is failing

Status
Not open for further replies.

siena

Technical User
Jan 30, 2003
262
US
Dear all,
I hope I am in the right forum for this question.
I am trying to perform a backup of our database and logfiles.
I have tried a few times now but kept getting following error:

Write on C:\Backup\NF failed. status = 112
Backup Database is terminating Abnormally.


I created the backup file with the following:

/* Create some logical backup devices */

USE master
EXEC sp_addumpdevice 'disk', 'NF', 'C:\Backup\NF.bak'
EXEC sp_addumpdevice 'disk', 'NFlog', 'C:\Backup\NFlog.bak'

Here also is my backup script.

BACKUP LOG NorthFulton
WITH TRUNCATE_ONLY

BACKUP DATABASE NorthFulton TO NF
WITH NOINIT

My question is two-fold.
1, what could be causing the above error?

2, Can I back database to cd-rom disk?
Thanks in advance
 
error 112 ...
There is not enough free disk space on the server.

And yes ... you can back up to a CDRW

Thanks

J. Kusch
 
Thanks for your quick response J.
Can you please give me an example of how to back up to cdrom?

Do I just put a cdrom in the drive and start backuping up.
How can I modify to code I included in my first post to allow me to backup to cdrom?
Thanks again!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top