goldmineexpert
asked on
sql server log scan number passed to log scan error
I'm getting the below message when trying to attach our database. Any ideas?
Thx bob
Attach database failed for Server 'SLIMLINE\SQLEXPRESS'. (Microsoft.SqlServer.Expre ss.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.Expre ss.Connect ionInfo)
-------------------------- ----
The log scan number (2404:47:1) passed to log scan in database 'IRI' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
Could not open new database 'IRI'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 9003)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=9003&LinkId=20476
-------------------------- ----
BUTTONS:
OK
-------------------------- ----
Thx bob
Attach database failed for Server 'SLIMLINE\SQLEXPRESS'. (Microsoft.SqlServer.Expre
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.Expre
--------------------------
The log scan number (2404:47:1) passed to log scan in database 'IRI' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.
Could not open new database 'IRI'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 9003)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=9003&LinkId=20476
--------------------------
BUTTONS:
OK
--------------------------
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.