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.
| Author |
Topic |
|
kopzen
Starting Member
34 Posts |
 Posted - 2008-11-17 : 08:31:42
|
| Hi When I try to attach a database on SQL Server 2005 I get the following error message:TITLE: Microsoft SQL Server Management Studio------------------------------Attach database failed for Server '(Server Name)'. (Microsoft.SqlServer.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.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)------------------------------SQL Server detected a logical consistency-based I/O error: incorrect checksum (expected: 0x2d140ffa; actual: 0x3c541e7a). It occurred during a read of page (1:2195) in database ID 47 at offset 0x00000001126000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\Credit_Old\Credit_Note.mdf'. Additional messages in the SQL Server error log or system event log may provide more detail. This is a severe error condition that threatens database integrity and must be corrected immediately. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information, see SQL Server Books Online.During redoing of a logged operation in database 'Credit_Note', an error occurred at log record ID (3044:3511:417). Typically, the specific failure is previously logged as an error in the Windows Event Log service. Restore the database from a full backup, or repair the database.Could not open new database 'Credit_Note'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 824)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=824&LinkId=20476------------------------------BUTTONS:OK------------------------------ |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-11-17 : 11:38:56
|
| Is it a replicated db by any chance ? |
 |
|
|
|
|
|
Problems attaching a database