Back up to Local Machine | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Back up to Local Machine


Isnt it possible to write query so that the back up file can be saved any system other than Server where it is installed?
Backup database DB to disk=’\sysFDB.bak’ I get error Server: Msg 3201, Level 16, State 1, Line 1
Cannot open backup device ‘\sysFDB.bak’. Device error or device off-line. See the SQL Server error log for more details.
Server: Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally. Due to this what I need to do is back up at server and then copy the file to local system.
Any tricky ways to do this to any system? Madhivanan Failing to plan is Planning to fail
None, that I’m aware of. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)

Any security reasons that MS doesnt support this? Madhivanan Failing to plan is Planning to fail
Ensure the specified share is created and SQLagent account has required privileges. Sometimes it is not advisable to issue the sharename in the backup statement, it is good to created a local backup and then copy to the share. 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.
Hi,<br /><br />read *B. Add a network disk backup device<br />* under sp_addumpdevice in BOl.<br /><br /><br />HTH.<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
Hi,<br />this works at my end <br /><br /><b>backup database testssp to disk=’\mis24d$a.bak'</b><br /><br />but as satya suggested its not recomended to use network share / network backup , it will overhead network traffic too. <br />see if proper permission is assigned to network share , what’s their in ERROR LOG of SQL ?<br /><br />post that msg too .<br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br />Regards<br /><br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
Yes it works on my machines too, as the SQLAgent account has privileges on the defined shares. 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.
Thanks Hemant. That did the trick I forget $ [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail
]]>