August 21, 2008 at 7:14 am
Hi,
I am trying to restore a Database of which I have taken backup in the default location. The db is in a server instance which is the default instance of my machine.
I want to restore it to another named instance on my local machine.
It doesnt show the backup file in the UI and when directly given the path to file - It is giving the following error
location does not exist, or the current login account does not have access to it. Verify
that the file location exists, and that the login account has permissions on it.
I use a domain account and have Windows Authentication for logging into the servers. Could this be some permissions issue?
August 21, 2008 at 8:03 am
Could be permissions. Dont' forget that you're asking the SQL Server to do the work, it's not your account. The service account must be able to see the backup file.
August 21, 2008 at 8:08 am
- apparentley you are using SSMS to try to restore the dbs.
It will use the connected instances service account authority to query the backup locations.
With sql2005 that access is restricted to the "known" directories;
If you grant the new insances service account read auth to the backup folder of the "old" instance, you'll be able to use it.
IMO you will be better of by just copying the .bak files from the backup folder of the old instance to the new instances backup folder. (because you don't need to grant anything)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
August 22, 2008 at 5:46 am
Hi,
How to check which service account has which which permissions on a folder. And how to grant permission in case we want to.
My Default instance is running under the LocalSystem log on. Named instance is running under NTAUTHORITY\NetworkService log on.
TIA
August 22, 2008 at 7:15 am
Even though you can't browse to the path to select it, you can use Copy-Paste to enter the path you want.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply