Skip to Content
Former Member
May 14, 2007 at 04:51 PM

Detach/attach SQL for restore URGENT


I have windows backup of MS SQL directries (AFGDATA1,AFGDATA2, AFGDATA3 ) How should I restore the dataase.?(I just copied them while having SAP down)

I was told to reinstall the same systemID. Then I will copy back just AFGDATA1,AFGDATA2, AFGDATA3 , AFGLOG. How should I do that? In SQL server manager I was told to attach the database(how should I do that). I guess I have first to

detach the original database(while having sql services on),

stop sql services ,

restore the old directories ,

start sql services

attach the new database

Am I right?