Okay, strangely the log said the db was successfully backed up but the job still said failed.

Just for completion of this thread, I did the following:

sp_dropdevice 'InterRaiLTCMDSAssessment_Backup'

sp_addumpdevice 'disk', 'InterRaiLTCMDSAssessment_Backup', 'R:\MSSQL\BACKUP\InterRaiLTCMDSAssessment_Backup.BAK'

Adding...

Yes the folder existed, all other backups were going there.

Well the backup started working. Possibly because of adding the backup set, though after I did that I tried to manually...

BACKUP DATABASE [InterRaiLTCMDSAssessment] TO [InterRaiLTCMDSAssessment_Backup] WITH NOUNLOAD, STATS = 10, INIT , NOSKIP, NAME = 'InterRaiLTCMDSAssessment'

above is the command I am trying to run, this runs 1st time and every...

I would also like to know why it doesn't work for one database.

I have a job that backs up all the dbs to an existing folder.

I never created the dumpdevice...

Thanks for your suggestions. DTS was giving me failures on copying some of the objects.... This db has multiple file groups, anyway, never made it past the failure. (and it...

So, it's still not really clear to me... I want to attach to a db (very large, sql 2000) on another server and create an empty db on the new...

Some of us dba's are not 'boys' at all and we also like our toys! 😛 (This site doesn't even have any 'girl' icons!!!)

I am involved in motorbiking on weekends,...