Thanks Alan It is shared hosting so I don't have access to any folders outside my ftp.
I've tried the OSQL changing the path to \\WIN7\C having shared the drive but get unable to access backup device. Same error as SQL EM gives. I'll see if server.mappath gives any clues to the actual home folder of my site Regards Graham -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Alan Bourke Sent: 04 March 2011 09:01 To: GrahamB Subject: Re: [NF] Backup SQL 2008 from remote host On Fri, 04 Mar 2011 08:26 +0000, "Graham Brown" <[email protected]> wrote: > > With hosted SQL 2008 the c: drive is their c: drive not mine so it > fails. The KB says just to put \\mymachinename\c\database.bak but this > also fails I guess for the same reason. Back it up onto the local drive of the host then copy the .BAK file to your own share once it finishes ? Or try the OSQL prompt: osql -S remoteserver -Userid -Ppassword or osql -E remoteserver to use a trusted connection then: backup database mydb to DISK = '\\MyMachine\MyShare\mybackup.bak' with init go -- Alan Bourke alanpbourke (at) fastmail (dot) fm [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
