Hi

was looking at tutorial from issue 22 on transferring live to local for testing updates

i use websecurestores hosting (SQL 2005) i have downloaded database on trying to restore database i get error below


System.Data.SqlClient.SqlError: The operating system returned the error '5(error not found)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\A3310284.mdf'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?Prod...nkId=20476

the OS i am using is Vista Home Premium, i have had no problems using SQL Express 2005 for local builds to test DNN and Modules

has anyone else had this problem, and how did they able to fix

Thanks

I'm not sure, but it looks like you've downloaded a copy of the database (.mdf file) and not a backup of a database. I think that you need to restore from a backup.

Hi

Ignore request got it fixed.

the problem was hosting has database on different location, on restore database page, click options

I had to change restore location

from

E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\

to

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\

hope this helps out anybody

Martin