Viewing 6 posts - 1 through 6 (of 6 total)
It worked great! Thank you very much!
Geoff
October 21, 2002 at 12:32 pm
Yes, the path is definitely correct. However, I think that the data file somehow refers to that log file (which is not recoverable) thus the error message.
August 14, 2002 at 11:27 am
I stopped SQL Server, renamed the file to 'ActiveSales.mdf'. Then I restarted the server. I dropped the old database called 'ActiveSales'. I still get the following error:
Script:
EXEC sp_attach_single_file_db @dbname =...
August 14, 2002 at 10:41 am
I stopped SQL Server, renamed the file to 'ActiveSales.mdf'. Then I restarted the server. I dropped the old database called 'ActiveSales'. I still get the following error:
Script:
EXEC sp_attach_single_file_db @dbname =...
August 14, 2002 at 10:41 am
Here is the script I ran and the results:
Script:
EXEC sp_detach_db @dbname = 'ActiveSales'
EXEC sp_attach_single_file_db @dbname = 'AS_2',
@physname = 'e:\Program Files\Microsoft SQL Server\MSSQL\Data\ActiveSales_Data.MDF'
Results:
Server: Msg 15010, Level 16, State...
August 14, 2002 at 9:57 am
I tried it and rec'd the following results back:
Server: Msg 1813, Level 16, State 2, Line 1
Could not open new database 'AS_2'. CREATE DATABASE is aborted.
Device activation error. The physical...
August 14, 2002 at 9:49 am
Viewing 6 posts - 1 through 6 (of 6 total)