May 10, 2002 at 2:43 pm
when I want to perform a new backup using a logical drive, SQL does not see the logical drives. The logical drives are in another machine.
May 10, 2002 at 2:55 pm
You would have to use unc path to specify the location. Example would be \\YourServer\e$\Databases\Bakup
That should work just fine.
Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
May 10, 2002 at 3:42 pm
Just keep in mind the security issues you need to cover. If the box is not on the same domain you may not be able to access the remote machine. Also if this is going to be done via a job in SQLAgent you will need to change Agent from using Local System Account to another account that can access the remote server.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 10, 2002 at 9:24 pm
I've had luck with mapping drives under the SQL User and them being there when the server starts. I think the UNC method is safer, however.
Steve Jones
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply