Get Error 1813 when attach db to SQL2005

gerten · October 6th, 2006, 05:04 AM

Hi I read the following Readme.txt how to install TheBeerHouse project. And using SQL Server 2005.

When i try to attach as following i get error:

Code:

exec sp_attach_db @dbname = N'TheBeerHouse',
@Filename1= N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\TheBeerHouse.mdf',
@filename2=N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\TheBeerHouse_Log.ldf'

Msg 1813, Level 16, State 2, Line 1
Could not open new database 'TheBeerHouse'. CREATE DATABASE is aborted.
Msg 602, Level 21, State 50, Line 1
Could not find row in sysindexes for database ID 9, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.

kherrerab · October 6th, 2006, 11:22 AM

create the db first.. then use the scripts to create everithing. the scripts are in the app_data folder.

elliswhite · May 27th, 2014, 05:10 AM

Go through this:- http://www.sqlrecoverysoftware.net/b...rror-1813.html

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Replication with SQL2005	seananderson	Access	0	November 30th, 2007 05:32 AM
Add a 2'nd SQL2005 db	ADH	BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0	1	August 25th, 2007 06:08 PM
Sql Express Error -An attempt to attach an auto-n	virendar23	ASP.NET 2.0 Professional	1	December 19th, 2006 09:24 AM
SQL2005 to SQL2000 issue	SoftMind	BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6	2	May 2nd, 2006 09:09 AM
Attach dB Failed	ioates	SQL Server 2000	5	June 30th, 2003 04:25 AM