Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NeilG
Aged Yak Warrior
530 Posts |
 Posted - 2010-07-23 : 05:12:01
|
Hope some guru can help on this one, I'm trying to restore a database but the backup file is kept on a network location, I knew you couldn't use a mapped drive so i've used the conventional UNC path \\backupsrv\SQLBackupsThen using the full backup name Migration.bakHowever, it then returns an error saying the file couldn't be located. I've then tested this on another SQL server and that server is capable of finding the file easily. On both sql servers i'm a sysadmin so it's not security at sql server level, and our IT team have added the SQL Server service account to be able to read/write files to/from that location, but were still getting the same problemPlease help guys  -----------------------------------------------Learning something new on SQL Server everyday. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2010-07-23 : 06:22:43
|
| Is the SQL Server service account added to the folder directly? Or permissioned via a security group?I've noticed that sometimes (depending on the version of windows/AD) the changed group permissions only take affect after a restart. Can you try adding the account individually?Are you running the RESTORE in a query or via SQLAgent? |
 |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2010-07-23 : 06:43:27
|
| Its added to the folder directly, and i'm trying to restore through SSMS not via any scheduled job which would use the SQL Agent Account |
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2010-07-23 : 06:55:18
|
| Can you verify that the folder is correct? From the server, Start --> Run --> "\\backupsrv\SQLBackups" enter. Does it open in the file browser? If possible, can you logon as the SQL service account and check?Spelling, or spaces -- sometimes it's the silly/small things ... check the filename too.If you have xp_cmdshell enabled (probably not), can you get the directory listing for that folder?Can you post the error message? |
|
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2010-07-23 : 08:37:22
|
| Sorry it won't let me copy and paste the error, but yes we've check the spelling, path, filename and we've even logged onto the server where the databases instance is held under the SQL server service AD account and we can access the file via explorerthe weird thing is this is the only database instance which has this problem so we can't understand why |
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2010-07-23 : 10:54:53
|
| Interesting... What's different about this instance/server?- domain, maybe a trust issue- account - double-check the SQL service account - file access - can you use ProcessExplorer to check?- event-viewer logs - anything logged at the same time?Can you post the error message from the SQL Server ErrorLog?Sorry - I've not been much help here. Maybe someone else can advise. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-07-23 : 12:36:43
|
| show us your restore statement and the exact error. there is no reason that you can't copy/paste it if you're using T-SQL to restore. |
|
|
|
|
|
|
|
|
Problem connection to backup file.