February 3, 2004 at 1:55 pm
I am testing recovery plan for a sql7 database server . One of the sticking points is the mdf file has no log file . So the database comes up suspect and when trying to get it off the mode it says unable to active some files .. How the system backs up (per software company ) is the system stop the sql and backs it up and restarts .
February 6, 2004 at 8:00 am
This was removed by the editor as SPAM
February 6, 2004 at 9:25 am
I hesitated answering this, because I know with SQL2000, you can attach an mdf without the ldf. But I cannot remember in SQL7 if this was a possibility.
If you use the sp_attach_db process in Query Analyzer, does your database attach without being in suspect mode?
Michelle
February 10, 2004 at 12:43 pm
I know this is an older post so I hope it's not to late to help. SQL 7 does support sp_attach_single_file_db but the caveat is that the database must have been gracefully 'detached' prior to peforming this operation. So, you'd have to detach, then copy the mdf file, then re-attach your production DB, then use the single_file option to attach the mdf at another location or server. HTH. Cheers.
My hovercraft is full of eels.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply