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