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 _______________________________________________ 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.
