Occasionally, Microsoft SQL Server Management Studio will not allow database files to be attached, possibly due to the corruption of data. The error shown in Figure 1 will be displayed.
“Attach database failed for Server ‘DB_CONNECT_NAME’.
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The log scan number (xxx) passed to log scan in database ‘skfuser’ 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 ‘skfuser’. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 9003)”
This article provides a way to “force” SQL Server Management Studio to attach the skfuser database for SKF @ptitude Analyst.
Comments
0 comments
Please sign in to leave a comment.