I am trying to restore a database from copies of data file and log file from a database thats in log shipping.
When I run:
sp_attach_db @dbname = N'partner_dirty',
I got the error message:
Msg 1824, Level 16, State 1, Line 1
Cannot attach a database that was being restored.
I was able to restore databases this way in sql 2000. Is there a way to get around in 2005?