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?