Device error or device off-line..? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Device error or device off-line..?

Hi!frendz.<br />I have created a backup job..whose 1st step was to create a backupdevice on E: of my win 2003 machine and subsequent steps have backup database scripts..The job failed [<img src=’/community/emoticons/emotion-6.gif’ alt=’:(‘ />]when i checked the job report i gt the following notification..what is wrong..where im wrong<br />Cannot open backup device ‘backup_dev_1’. Device error or device off-line. See the SQL Server error log for more details. [SQLSTATE 42000] Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] .<br />pls guide
<img src=’/community/emoticons/emotion-6.gif’ alt=’:(‘ /> not satisfied.<br /><br />refer to books online in the section headed BACKUP DATABASE.<br /><br />Tom Pullen<br />DBA, Oxfam GB
Is your database on your win 2003 machine or somewhere else? Do you really have backup_dev_1? Maybe it is backupDev1 or you mistyped the folder name?
True and check the path for this backup device created and must be a valid path from the database server as that’s where the BACKUP command runs and not from your client machine. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
The first step of the job ran successfuly which was sp_addumpdevice ‘disk’,’backup_dev_1′,’E:ackupackup_dev_1.bak’ and the job history showed that backup device is created.Now the job failed in second step which was a BACKUP DATABASE scripts.
I also checked with EM :when i clicked on the backup device icon in the tree on the left pane backup device was there.
i dropped the backup device. I repeat the same procedure today but the output was same error.pls suggest
Is the E: drive local to the SQL Server machine? IIRC you can’t backup to a networked drive.
And also check the account used to start MSSQLAgent has required privileges to create the backup file. If you’re using local system account then it will not work, you must use a local account on server with required privileges. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Seems to be problem with path of the device.
sp_addumpdevice ‘disk’ ,’c:devfilefulbck.back’ wil create the device eventhough there is no such path. so pls veryfy ur path of the device created.
Rajiv
SQL-DBA
]]>