SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Restore database from network drive


Restore database from network drive

Author
Message
Jeffrey Williams 3188
Jeffrey Williams 3188
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18887 Visits: 10042
ansz5 (8/1/2008)
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 !!!


Does the account running SQL Server have access to the share? If the account is not a domain account, then you cannot get access to the shared folder.

Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs

rajiniforu
rajiniforu
Old Hand
Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)Old Hand (399 reputation)

Group: General Forum Members
Points: 399 Visits: 436
Try restoring the database using the following query:

restore database "dbname"
from disk = 'Servername\sharedlocation\db.bak'


servername - This is not the local server name, it is the servername where the backup files are located.

or else to do it through GUI:

Know the exact shared location, you can type the servername(\\servername) in the "run" and that would autoamtically display all the shared locations on the server to which your account has access. From there navigate to the correct location and use it in the restore path.

The other server need not have SQL installed on it. Its just storing the backup files.
ansz5
ansz5
Old Hand
Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)

Group: General Forum Members
Points: 302 Visits: 188
Hi !

Thank you every one for all you replies and suggetsions,

The problem had been resolved , I could not post it here on the forum.

I used the command net use on command prompt to find out exact name (UNC) name of the shared drives and used this complete name in the File name text box of locate backup window , while restoring the backup.

It worked.

Thanks again !

Best Regards,
ansz5
kma-359837
kma-359837
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

Group: General Forum Members
Points: 54 Visits: 9
I have similar issue as the last user. I try to restore a db from a db backup file on another server. I use the full UNC name as \\sourcecomputer\shre drive\testdb.bak in the file name. Got the same erorr. I wonder if someone can confirm if itworks for them. My account I use has full admin priv on both servers.
ansz5
ansz5
Old Hand
Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)

Group: General Forum Members
Points: 302 Visits: 188
May I know , if you are using a shared folder or you have a network drive mapped on your server ?

If its a network drive mapped, then pls use 'net use' command on command prompt to fetch the complete name for the drive.

I faced the same problem but when I fetched the name this way, it worked.
Please refer to my previous reply for steps.

Hope it helps.

:-)

Rgds,
ansz5
kma-359837
kma-359837
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

Group: General Forum Members
Points: 54 Visits: 9
Hey guys,

Thanks for all your comments. It works for me now. My issue is even though I have a local logical drive map to the targer server's shared drive, and net use shows that the UNC name. The restore still failed to locate the bakcup file. The run cmd showed that I have no access to the shared drive. So, one I fix that, it works . Thanks guys.
Maurice Pelchat
Maurice Pelchat
SSC-Enthusiastic
SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)SSC-Enthusiastic (127 reputation)

Group: General Forum Members
Points: 127 Visits: 57
Be careful how you grant your permissions, there is share permissions, and there is ntfs permissions. I got this problem some day because I forgot share permissions.
Sandeep.Lad
Sandeep.Lad
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 Visits: 27
I am facing same issue. Can anyone help me ?

Sandeep Lad
jinx8402
jinx8402
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 512
I did not want to create a new post, so I am bumping this sort of old topic...

I am trying to determine what would be better to restore a larger (96GB) database from a remote server as far as I/O on the production server.

The backup file is located on the production server and I want to restore into a test box. My two options are:

1. Copy the bak file to the test server and restore locally

2. Restore using an UNC path

Which would have the least impact on the Prod server (where the bak file is located)?

I am new to the DBA field and want to make the best decision possible.

Thanks for any help
James Horsley
James Horsley
Right there with Babe
Right there with Babe (719 reputation)Right there with Babe (719 reputation)Right there with Babe (719 reputation)Right there with Babe (719 reputation)Right there with Babe (719 reputation)Right there with Babe (719 reputation)Right there with Babe (719 reputation)Right there with Babe (719 reputation)

Group: General Forum Members
Points: 719 Visits: 451
I would copy the bak file over and restore locally - I doubt there is much difference in the new traffic to do this once - but it means you can restore the bak multiple times to the test box without further load. Copying the bak over the network will saturate the lan connection on the prod box - making all other clients slower - so if it is an option I would recommend copying to e.g. a USB drive on the server then walking that to the test box ... watch out for USB weirdnes though - if you test box is similar config make sure the drive works on that OK before plugging into prod




James Horsley
Workflow Consulting Limited
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search