April 29, 2003 at 10:43 am
I'm trying to attach a database and I keep receiving an error 3448. I've attempted to attach without the log file but it gives me a different error when trying that.
It seems to be a transaction that needs to be reversed on the database prior to attachement, but I'm not sure. Does anyone know how to correct this problem and successfully attach the database?
April 29, 2003 at 11:12 am
Did you used sp_detach_db in the source server to de attach the db, or you didn't deattached it?
April 29, 2003 at 11:59 am
I used the sp_detach - only instead of writing the sp_detach in query analyzer, I did it by right clicking on the database and clicking on detach in enterprise manager. It seemed to have an error (that I can't recall) but it did detach.
April 29, 2003 at 8:27 pm
If you can't attach the database you might try doing the below steps.
Create a new database with the name of your original database.
Detach the data file.
Rename the old data file to the name of the new data file
Attach this file.
After this you might want to run dbcc rebuild log(), if you have lost any transactions
Good luck
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply