sp_attach_single_file_db problem       SQL7

exec sp_attach_single_file_db @dbname='MailArchiver_200609_IN',
   @physname='X:\MailArc\MailArchiver_200609_in_Data.MDF'

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

http://support.microsoft.com/kb/271223 says this is by design when multiple logs files were used.
This was not the case. LDF's have been deleted.
database was dismounted using    exec sp_detach_db 'mailArchiver_YYYYMM_IN';

the MDF file was then renamed to be the month in question.

exec sp_attach_db @dbname='MailArchiver_200609_IN',
   @filename1='X:\MailArc\MailArchiver_200609_in_Data.MDF'

generates same error.  X drive has 130G spare. MDF is 1.5G.

I can reattach a DB detached yesterday using the singlefile sp.
Start Free Trial