Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

How to map network drive for SQL backups?

Created: 27 Aug 2012 • Updated: 27 Mar 2013 | 11 comments
inn_kam's picture
This issue has been solved. See solution.

Dear 

i am at production side for one customer.

they are already taking backups for SQL Server on tapes

now they want to take backups on disk

so without making media server they have mounted Network drive Y: on master server

now i want to make storage unit by sharing this network drive (containing space for taking SQL backups)

so how will i make storage unit for network drive without making media server?

Discussion Filed Under:

Comments 11 CommentsJump to latest comment

inn_kam's picture

Note : 

i am using Netbackup 7.5.0.3 

revaroo's picture

I would advise against using a network mapped drive as a storage unit.

Just use the server that hosts that drive as the media server for such backups.

inn_kam's picture

But Media server need another license and customer wants to work without purchasing another license

Marianne's picture

If you configure SQL host as media server, customer will in any case need license Enterprise Client license in order to configure as SAN Media server.

Better to zone/attach big storage directly to SQL host.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

revaroo's picture

If your customer wants a stable environment then homing the drive on the server (rather than using mapped network drives) is the way to go. If they want to use the 'cheap' option then expect degraded performance.

Marianne's picture

To configure DSU, you need to install media server software.
I agree with Revaroo - rather install media server software on the server with big storage.

Network drive (using UNC path) is supported, but not best practice. You will need to install media server software on SQL host which will add bptm process overheads on the client while data will still be sent over the network.
So, unless data can be backed up locally (disk or tape) there is no benifit in turning SQL server into a media server.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

Mark_Solutions's picture

You could use a UNC path for the DSU on the Master Server but it really isn't great.

It may be better set as a mount point and use it that way.

One solution may to have your SQL Maintenance plan (I am assuming that you are not using the SQL Agent) set tp write to this new disk location and then have it backed up via UNC path by the Master

Please clarify exactly what you want to do here and we will try and help you more

Authorised Symantec Consultant

Don't forget to "Mark as Solution" if someones advice has solved your issue - and please bring back the Thumbs Up!!.

inn_kam's picture

Dear Mark Solution

We want disk  backup of  SQL Server   at  AD Server.

so we Mount ADSERVER [folder name backup  as Y: (Network Drive) ]                                                            on master server  as network 

so i made a storage unit and give the path as \\adsvr\backup 

i also made  the policy test_SQL and manually run it , but it shows error Disk volume is down.

  Now Help me please:

Marianne's picture

Change NBU Client Service logon account on Master server to a domain account with write access to the UNC path.
Test write access by logging on as this user, then test by creating txt file in this path.

Hope this helps.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

Mark_Solutions's picture

The configuration indicates that you have mounted it as a network drive (Y drive) but also shared a folder on it (named backup) is that correct?

As Marianne says the NetBackup client service account will need to be running as an account that has that drive letter mapped (persistently) and also has full rights to the backup share located on that mapped drive.

You may still have issues as NetBackup will struggle to determine accurately the free disk speace etc. of that drive so if there is a way that you can set the disk as a mount point, or using iSCSI, it would be far better

Hope this helps

Authorised Symantec Consultant

Don't forget to "Mark as Solution" if someones advice has solved your issue - and please bring back the Thumbs Up!!.

SOLUTION
inn_kam's picture

Thanks all 

After giving credentials to Netbackup Client Service ,We give administrative credentials to "NetBackup Remote Manager and Monitor Service" and the job successfully started