Issues Attaching MdxStepByStep.mdf

  • exec master..sp_attach_db

    'MdxStepByStep',

    'C:\Microsoft Press\MDX SBS\Setup\SQL Server\MdxStepByStep.mdf'

    When i exeucte above query facing with the following error message.

    Msg 5173, Level 16, State 1, Line 1

    One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup.

    Log file 'C:\Microsoft Press\MDX SBS\Setup\SQL Server\MdxStepByStep_log.LDF' does not match the primary file. It may be from a different database or the log may have been rebuilt previously.

    Msg 1813, Level 16, State 2, Line 1

    Could not open new database 'MdxStepByStep'. CREATE DATABASE is aborted.

    Can anyone let me know the solution for this?

  • I found the solution at

    http://support.microsoft.com/kb/970767

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply