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 |
|
BernKeo
Starting Member
5 Posts |
 Posted - 2011-01-28 : 19:05:05
|
| Hi...Please help!I need to restore a backup file from another server.Currently I'm using Vmware and installed SQL Server with Windows 7.After I lunched the MS SQL Server Management Studio Express, go to database, right click and Restore Database. I'm following the instruction, somehow it states that I have no permission to restore the backup file.This is the first time that I try to use SQL.What did I do wrong? Do I need to configured the system prior to Restore the backup file?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
BernKeo
Starting Member
5 Posts |
Posted - 2011-01-31 : 11:49:25
|
| Hi Tara,I still having problem.I do not know how to run SSMS in Admin mode as Windows 7 puts it into non-admin mode.Can you tell me where can I read to find the direction how to do?Thanks |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-01-31 : 12:02:28
|
In your Windows menu where you click to start the SSMS there you have to do a right-click instead of left-click.Then in the context menu you can choose the admin mode.
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
BernKeo
Starting Member
5 Posts |
Posted - 2011-01-31 : 14:02:13
|
| I run the SSMS in Administration mode, but I still having problem.This is the message that I'm receiving.System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\UBR_MSCRM.mdf'. (Microsoft.SqlServer.Express.Smo)Thanks All, |
|
|
|
anarayanamoorthy
Starting Member
15 Posts |
Posted - 2011-02-04 : 01:30:29
|
| Hi,Did you try to login with windows authentication and did you check with sa user name and password in mixed mode, if you are able to login and restore the database.Narayanamoorthy A |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2011-02-04 : 03:31:46
|
| Are you in fact an administrator on this machine? What happens if you go to the 'c:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\' using Windows Explorer, right-click inside the folder and chose New -> Text document and then click Enter? What if you try to put the mdf/ldf-files in a different directory?- LumbagoMy blog-> www.thefirstsql.com |
|
|
|
|
|
|
Restore backup