sql server connect: Backup Sql database to mapped network drive on another server prob -- sql server connect

RE: Backup Sql database to mapped network drive on another server prob

BarbS
1/28/2005 1:31:05 PM

I understand that's one way to do it and I appreciate your answer. As I said
earlier, I was backing up to a network drive manually and through the
maintenance. I have been doing this for the last 6 months. Something got
change and I don't know where to start. Any suggestions as to what I can take
a look would be appreciated.

[quoted text, click to view]

Re: Backup Sql database to mapped network drive on another server prob

Andrew J. Kelly
1/28/2005 5:10:27 PM

It's not just one way to do it , it is the recommended way to do it. What
you see as a user means nothing unless that account is the same one that SQL
Server runs under. It is that account that does the backup regardless of
who initiates it or how they initiate the backup. Mapped drives can easily
get blown away or become unusable when changes are made on either end. So
if you want to continue using a mapped drive (which no one will recommend)
you need to log on to the server (database server) under the account that
sql server is running under and make sure the drive is mapped properly and
it still has the correct permissions to see and write to that share. If not
then the backup can not work properly.

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

Re: Backup Sql database to mapped network drive on another server prob

Dejan Sarka
1/28/2005 5:29:17 PM

[quoted text, click to view]

Backup to a network drive must be done with T-SQL Backup command (check it
in Books OnLine). Use UNC names, not mapped drives.

--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server connect group.