Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2009-01-23 : 04:35:18
|
| Hey when i schedile my backup job i keep getting this error message.No entry in sysdevices for backup device 'DB_RET09_Backup'. Update sysdevices and rerun statement. [SQLSTATE 42000] (Error 3206) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.I see that the sysdevices is in the master database but i can ammend this table. How do i go about updating the sysdevices table ? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-23 : 09:36:52
|
| It is old style to backup in devices.Can you directly backup to disk and copy to tape for future needs? |
 |
|
|
|
|
|
Backup Error