SQL Server Express 2005 - 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

SQL Server Administration (2005)

SQL Server Express 2005

Author

Topic

scmay
Starting Member

22 Posts

Posted - 2007-07-17 : 02:33:57

Hi I am having some problems doing backup for SQL Server Express 2005. I specified the backup file which was done in SQL Server 2000 but when I try to restore database, I get the error as shown in the url.

[url]http://www21.brinkster.com/scmay/backup-prob.jpg[/url]

There are no features such as reattaching a database in SQL Server Express 2005 version

Any ideas how to solve this?

b.veenings
Yak Posting Veteran

96 Posts

Posted - 2007-07-17 : 03:33:58

got this error: HTTP1.1 STATUS 403 Remote Access to this object forbidden This file cannot be directly accessed from a remote site, but must be linked through the Brinkster Member's site.

Need an SQLDB consultant?
check www.veeningsengineering.nl

scmay
Starting Member

22 Posts

Posted - 2007-07-17 : 19:36:31

Sorry I'll write the error here

Restore failed for Server 'MCATSPC07\SQLEXPRESS'. (Microsoft.SqlServer.Express.Smo)
Additional information:
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\bos.MDF'. (Microsoft.SqlServer.Express.Smo)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-07-17 : 19:41:31

You probably need to specify the WITH MOVE option in the RESTORE DATABASE command.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources