Transferring Log backups to Mapped Network Drive

Question

Transferring Log backups to Mapped Network Drive

nikhil.verma

SSCrazy

Points: 2603
More actions
August 21, 2008 at 5:57 am

#70649

Is there any way out to transfer log backups to Mapped Network drive.
On one of my Prod servers on C drive my Log Backups are scheduled. I have created one Mapped network drive on this server. But in the job properties it is not accepting my network drive path( want to do all my backups on network drive instead of C:)
I am using ---Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
Can anyone please let me know how can i transfer my log backups to network.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

To backup to the network you should use UNC paths (\\server\share) not mapped drives. Drives aren't mapped unless you are logged in to the console so SQL Server never sees a mapped drive.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

nikhil.verma SSCrazy Points: 2603 More actions · Answer 2

Hi

Thanks for the reply!!!!!!!!

I have already used UNC path(\\server\share) in the job path but all in vain ..:(

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

Assuming that you are scheduling these backups does the SQL Agent Service account have rights to the share?

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

nikhil.verma SSCrazy Points: 2603 More actions · Answer 4

Thanks for help Jack!!!

I have checked agent service account is having full permissions.

nikhil.verma SSCrazy Points: 2603 More actions · Answer 5

Account on which my sql server agent is running is having full permissions on the shared network folder , but still not able to add the UNC path (\\server\share) in the job.

Jack Corbett SSC Guru Points: 184394 More actions · Answer 6

Can you post the backup command you are running? Obviously you can change names if necessary.

Also, what is the error you are getting?

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 7

note that this is a bad practice. Any network issue, which occur all the time with network copies, will cause the backup to fail.

If you have space issues, you'd be better off buying more space (this is important stuff), or backing one file, copying it to the network and deleting it. The copy process has much more tolerance for network issues than the backup process.

nikhil.verma SSCrazy Points: 2603 More actions · Answer 8

Steve i do agree.. Just on the temp basis we need to implement this solution but somehow i am not able to get it!!!!!!!!!

Tried exploring all the posibilities but couldnt get the proper soln...