Restoring database on local machine

Hi,
Have you tried the Wizards or DB Copy functions in your local version?
This is not 2005 Express, right? Some of these functions only work in the 2008 Express version, never before the 2008 Express version.
Salute,
Mark

Technical Evangelist for DiscountASP.NET

Find ASP.NET code samples with my Dev Coop search tools below.
Google
Microsoft

DiscountASP.NET Technical Webcasts:
http://www.iis7test.com/webcasts/

My Microsoft Technical Blogs
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx

 

Hi,
I have backed up my database on DiscountAsp and want to restore it on my local machine for development purposes. I have an XP with SQL Server 2005 installed. When I select the .bak file to restore, I get:

Restore failed for server 'DELL\SQLEXPRESS' (Microsoft.SqlServer.smo)

System.Data.SqlClient.SqlError: The operating system returned the error '5(accessdenied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\dbname.mdf'. (Microsoft.SqlServer.smo)

I can see the database being restored is under user 'sa'. I tried to check the settings of the MSSQL folder but I don't see a security tab to check who has access to it.

How can I restore this database to my local machine?

TIA.

 

Hi,
Once I get back into the Webcasts I will be creating some on how to do this on DASP servers.
I've done a Blog post about these features that may help for now:
weblogs.asp.net/markwisecarver/archive/2009/01/19/import-export-wizard-is-not-copy-database-wizard.aspx
Salute,
Mark

Technical Evangelist for DiscountASP.NET

Find ASP.NET code samples with my Dev Coop search tools below.
Google
Microsoft

DiscountASP.NET Technical Webcasts:
http://www.iis7test.com/webcasts/

My Microsoft Technical Blogs
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx

 

This is not 2005 express, it is 2005 enterprise.
Not sure how to use any of wizard or db copy. I work mainly with .net and am not db savvy.

Thanks.