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 |
|
MyronCope
Starting Member
46 Posts |
 Posted - 2008-02-19 : 08:06:43
|
| I'm trying to restore a db using sql server mgmt studio 2005.I chose the "from device" radio button on the "General" screen and put my .bak file in the C drive.ex: C:\backup.bakI click on the lookup button and then click "Add" which pops up the "Locate Backup File" window.I then enter the following:Selected path: C:\backup.bakFiles of type: backup files....File name: backup.bakI have tried different versions, ie: Sel. Path: C:File Name: backup (or backup.bak)nothing really works i always get the error:"the database service engine could not resolve the specified file location. either the location does not exists or the current login account does not have access to it..."How do i determine if the current login account has access to it? how do i find out what the current login account is? thanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-19 : 09:38:43
|
| Backup/Restore is always done by DBA. If you are DBA, you should have permission to backup/restore. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-19 : 23:35:33
|
| Tried with 'restore database' statement instead? |
|
|
|
|
|
|
Restore database issue