VIJI,

I am new to SQL but i am going to try your advice.

1) how stop all current transaction to that DB (let my db name be Analytic)

2) after taking it offline Just copying the Analytic.mdf and analytic.ldf to network location with click of your mouse will work? ( because I tried it doing it w/o taking it offline and gave me error: other users might be using it please stop the process and try again)

3) if yes , then I can delete current mdf and ldf file and just create a new one with same names ?

4) then bring it online and everything should work normal , Any idea of it not working when taking it online?

except the fact I lose current data in production

Please advice.

Best

Ash