September 22, 2009 at 1:45 pm
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?
September 22, 2009 at 1:48 pm
I found the solution at
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply