little help for an error!! - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

little help for an error!!

Author

Topic

melzkielicious
Starting Member

1 Post

Posted - 2010-02-28 : 00:25:38

hello to all of you im new here at forum
and i have a question that nid your help guys

i use SQLexpress 2005 and i want to restor a databases
but when i try to restore the databases this error appears...

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Restore failed for Server 'MARK-PC\MS$DPM2007$'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

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.4\MSSQL\RanGame1.mdf'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

could some1 help me with this error??
what should i do?
is there anysolution about this?? and how?

thnx for advance more power!!

Kristen
Test

22859 Posts

Posted - 2010-02-28 : 01:12:35

You are trying to restore to:

c:\Program Files\Microsoft SQL Server\MSSQL.4\MSSQL\RanGame1.mdf

yes?

Does that file already exist?

Is it perhaps used by something else? Another instance of SQLExpress perhaps?

This is the relevant message:

" The operating system returned the error '5(Access is denied.)' "

and generally that means that either a) you don't have enough permissions for that folder (unlikely if this is your PC rather than some bit IT department server) or b) the file is in use by something else, or readonly, or in some other way you don't have permissions to overwrite it.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources