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
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