attaching sql express files in sql server 2005

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

Express Edition and Compact Edition (2005)

attaching sql express files in sql server 2005

Author

Topic

cookiekhanh
Starting Member

2 Posts

Posted - 2006-04-18 : 10:47:21

Hello,
I am using the full version of sql server 2005 management studio to attempt to attach sql express mdf files to sql server 2005.

I was using the databases from an ASP.NET commerce starter kit in sql express. I want to update to sql server 2005, so i detached the dbs.
i deleted the sql express management studio ctp and installed sql server 2005 from the free 6 month trial available online.

I then attempted to attach the sql express files to sql server 2005 and get the following error:

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

Attach database failed for Server '<servername>'. (Microsoft.SqlServer.Smo)

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

------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------

Could not find row in sysindexes for database ID 9, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'C:\INETPUB\WWWROOT\<location>\ASPNET.MDF'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476

I also tried with the original mdf files i had downloaded without making any changes.

any help here?

thank you,
K

mikewa
Microsoft SQL Server Product Team

84 Posts

Posted - 2006-04-18 : 20:50:41

Hi K,

SQL Express uses the exact same files that every other Edition of SQL 2005 do, so I don't think it's the file. The error would indicate something is wrong with the SMO installation. I would suggest jumping over to the MSDN Forums and posting this question in the SQL Tools forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=84&SiteID=1) to see if they have any ideas what's going on with Management Studio.

Regards,
Mike Wachal
SQL Express

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources