Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Restore database from network drive Expand / Collapse
Author
Message
Posted Saturday, April 19, 2008 8:45 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 3:10 PM
Points: 759, Visits: 654
Hi All,

All of our database servers are doing backups and saving the .bak files out
on a network share. With SQL 2005, how can I point to that share and restore
the database in SQL 2005 environment?

When I do 'restore database --> From Device --> File; when I click the 'ADD;
button, I only see my local drives on the computer. How can I map to my
network share and point to my restore file on the network?

I need to do a restore for a database with the latest backup which is there on a network drive.
--
Post #487613
Posted Saturday, April 19, 2008 9:19 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 30, 2014 10:08 PM
Points: 1,038, Visits: 444
Browse there manually using Windows Explorer and then cut&paste the path and backup name into the bottom text field of the dialog box that's showing you your folders. You cannot map a network drive in your windows session and have SQL Server use it as its running under a service account. I haven't tried but you could set SQL Server to log on using a specific user account and have that account have a mapped drive persistently mapped? Using a full UNC of the form \\computername\share\folders\file.bak is always going to be more reliable than a mapped drive letter.


Post #487615
Posted Saturday, April 19, 2008 9:29 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 3:10 PM
Points: 759, Visits: 654
thanks, but is this possible to do that, i dont know exactly where to put the copied pathname you are telling, in which dialog box, More over when i specify the network path name, its unable to access even if i am keeping the network drive on local system through map drive.
Post #487616
Posted Monday, April 21, 2008 4:08 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 14, 2014 5:31 AM
Points: 159, Visits: 432
Remember the network share the backup is being restored from has to be accessible to the user that is running the SQL server service - it is not enough to log on to the server console yourself and find the file




James Horsley
Workflow Consulting Limited
Post #487794
Posted Thursday, April 24, 2008 7:16 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 7:24 AM
Points: 283, Visits: 115
When you do 'restore database --> From Device --> File; click the 'ADD' Button-->
Get the FULL UNC path as "\\ComputerName\Shared folder\Backup\abc.Bak" by mapping in the
explore window.
Copy the path & paste this path under add button-->File Name. It will work.
Post #489901
Posted Thursday, April 24, 2008 1:46 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 3:10 PM
Points: 759, Visits: 654
i am not restoring it, i am trying to give the backup path, anyways thanks for your reply, let me know how can you add a drive
In my case, the drive is there in the local system, but the problem is when i am giving a backup, its only showing 2 drives out of 4 i have. its on a cluster server
Post #490277
Posted Thursday, April 24, 2008 2:22 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, June 1, 2013 9:57 AM
Points: 252, Visits: 316
I think I see your issue, you have a local drive that you want to back up to, yet, your SQL Server database is on a Cluster that does not see that local drive (probably because it is connected to the San box).

This situation will require you to use UNC naming as there is no guarantee that the local server will be the active server in the cluster. This basically mean that you will have to backup over the network even though this is a local drive because SQL Server does not see the local drive since it is not part of the cluster.

The next issue you will face is backing up over the network. Not a very good way to accomplish backups as SQL server is not very tolerate for small network hiccups that always occur.

The best way to do this is to backup to the cluster and then utilize xp..cmd shell to move the file using UNC to the drive on the local machine to your target backup drive.

Remember, Clusters are very different from stand alone servers. The best way is to think of the cluster as it's own server as it is very independent of the nodes hosting it.

Hope this helps


Marvin Dillard
Senior Consultant
Claraview Inc
Post #490310
Posted Wednesday, June 4, 2008 10:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, August 15, 2013 7:32 AM
Points: 1, Visits: 72
I have the similar Issue.
SQL 2005 Cluster with a san box attached. After the Cluster was configured we added a drive on the san ( G.) Now we want to create a maintenance plan so the back up copy to the G drive rather than the local D or E Drive. I can't see the G drive in the context of Management Studio when creating the maintenance plan.

I can only accomplish the task using a share. G=\\sql\backups
Is there a way to get the cluster to see the G drive as a local drive?
Post #511549
Posted Thursday, July 17, 2008 11:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, November 21, 2013 11:17 AM
Points: 4, Visits: 53
It may help to check your cluster configuration. Use the cluster admin to add the G:\ drive as a dependent SQL resource.
Post #536168
Posted Friday, August 1, 2008 12:25 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 9, 2011 8:12 PM
Points: 42, Visits: 188
I am trying to restore a database on SQL Server 2005, using the backup placed on a different server ( in same domain). I have shared the folder and tried the same with sharing the complete drive too.

The account, I am using, has been granted full permisisons... but still when I type the complete path ( in file name test box), the message says..the database engine cannot find the specified path or the account does not have access to it. Should the server(with shared folder) have SQL Server installed on it..???

Also what should be the computer name here - "\\ComputerName\Shared folder\Backup\abc.Bak" I used the local computer name (in case of mapped drive) and the other server name in case of shared folder.

Pls advise.

Thanks !!!
Post #544866
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse