How to attach number of database to one(Single) server in sql server 2005 .

Without using  SQL Query you can attach more than one database to single server .
Like SQL server 2005/2008
It is very simple .

1.     Start Sql server .
2.     Jus Right click on  the database name.
3.     Then select Attach .
4.     Add
5.     Select the database .MDF file where you have kept that file  and delete log file if it will not find.
6.     But log file should be present in that particular file  where you have kept .MDF File.
7.     Then OK.

I am not saying that this one is best way but Good way.

Share This