Friday, November 26, 2010

How to attach and detach databases in SQL server.

Open MSSQL management studio
login user with admin privileges
To detach database

expand databases tab
Select database (which you want to attach are detach)
Right click on selected database ?tasks ? detach ?OK

To Atach database

After login the user with admin privileges
Right click on databases ?Attach ?select ldf and mdf  fles ?OK

No comments:

Post a Comment