March 26, 2002 at 3:10 pm
I'm trying to back up a database to a server other than the local server in which the database resides. Both servers are on different domains but they are trusted. The server I want to back up to has been added to the SQL client network utility using the TCP/IP network library. When I try to execute a backup, only the local drives belonging to the server holding the database appear as a selection to save backup file. I also tried mapping a drive to the server where I want to store the back up, but SQL didn't see the mapped drive. Am I missing a setting somewhere or is this not possible?? (This is my first db upgraded from Access to SQL so patience is welcomed and appreciated!!)
Thanks!
March 26, 2002 at 3:31 pm
The backup runs under the context of the server account. So only drives that are mapped for that account, not your acccount, will appear.
You should be able to use a UNC path.
Steve Jones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply