-
attaching a detach 'SUSPECT' database in MSSQL7
greetings!
first of all I want to congratulate you guys for this great forum you have. It have help me lot just reading several threads here. I myself have posted my own questions of couple of times before and the response have been great.
now I've got new concern with my SQL7. this regards attaching a formerly 'SUSPECT' status database which was detach.
I have detached a database(by the way the database is broken into filegroups) using 'sp_detach_db' while the database was in 'SUSPECT' status, because I was trying to restore the database to its normal state, I tried everything and detaching/attaching was the last option I tried... now its worse.
When I tried attaching using sp_attach_single_file_db' this error occurs:
Server: Msg 3624, Level 20, State 1, Line 1
21 transactions rolled forward in database 'DelMonte' (7).
Location: scanrid.cpp:315
Expression: m_len != 0
SPID: 8
Process ID: 1712
Connection Broken
I've run out of ideas already.
Any suggestions? help. :-)
I really need to re-attach the database.
thank you very much.
regards,
pparker
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|