first time I've ever had problems with SP_ATTACH_D

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

first time I've ever had problems with SP_ATTACH_D

Author

Topic

SQLServerDBA_Dan
Aged Yak Warrior

752 Posts

Posted - 2001-06-27 : 17:46:21

EXEC sp_attach_single_file_db @dbname = 'MxMasterDataLog', @physname = 'd:\MSSQL7\data\MxMasterDataLog_data.MDF'

exec sp_attach_db 'MxMasterDataLog', 'D:\mssql7\Data\MxMasterDataLog_Data.MDF'

Running either will result in the below errors:

Server: Msg 945, Level 14, State 1, Line 1
Database 'MxMasterDataLog' cannot be opened because some of the files could not be activated.
Server: Msg 1813, Level 16, State 1, Line 1
Could not open new database 'MxMasterDataLog'. CREATE DATABASE is aborted.

I dettached the db with:

exec sp_detach_db 'MxMasterDataLog'

Anyone ever have this problem before?

Daniel
SQL Server DBA

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources