Link to home
Create AccountLog in
Avatar of cmdown
cmdown

asked on

SQL Server - Backup to shared folder on network

Having suffered some major problems with our existing backup systems (see Q_26707308) I am attemtping to backup our SQL server to a shared folder on another computer but am getting errors saying that SQL server studio cannot backup to a raw device.
I have tried both using a direct unc target and also mapping a drive to the shared folder path outside of SQL server - all to no avail.  I can however backup small databses to the local SQL hard disc without issue.  Please can someone advise how I can backup all of our databses to a shared network folder on another computer.
Server is running sever 2003 & sql server 2005 std
Target share is on either server 2003 std or Win 7 pro
Many Thanks
Avatar of GerryMtz
GerryMtz

Try using UNC instead of mapped drives check this out:
http://www.mssqltips.com/tip.asp?tip=1126
In the Back Up Database Task set the connection to Target Server Connection, then in the Folder path use a UNC.


BUDT.jpg
ASKER CERTIFIED SOLUTION
Avatar of itcok
itcok

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of cmdown

ASKER

Hi itcok
Thanks for your reply.  Having looked at the maintenance tasks, I do not have "Target Server Connection" as an option.  Server is running SQL Server 2003 Std on Windows Server 2003 Std
Try this free tool:

www.sqlbackupandftp.com
Sorry cmdown... my mistake on the Connection bit. That is just for selecting the SQL server you want to backup. This happens when you try to do to many things at the same time. :(

The UNC path should work though.

Are you running the SQL Server service using the "Local System" account? If so, try giving your SQL Server's computer account full access (Security Tab) to the folder. When you go to do this you'll need to change the Object Types to also include Computers.

MySQLServer$ / Full Control
Avatar of cmdown

ASKER

Thanks Both. I'll have another look at this - hopefully in the next few days - although I've come back from holiday to find all my staff are on sick so things are a bit busy again !
Avatar of cmdown

ASKER

Hi itcok
Meant to say thanks for the pointer to SyncBack.  As a stop-gap I did what you suggested and SyncBack worked - RichCopy etc all failing as per my other question
Avatar of cmdown

ASKER

Hi itcok

I've not resolved this issue per see.  However, SyncBack has proved to be a suitable stopgap so I am going to award points for that pointer.  If I do find out the actual casue I'll post back to let you know.
Thanks