-
Help MS SQL 2000
I want help regarding MS SQL 2000
I installed MS SQL 2000 on 2 servers,
I configured, created databases with some data on one server,
i want to do the same thing , with the same databases, same data on the other server, is there any way,(like copying .MDF and other files )
{the database instance name on both server is same,}
Any Comments
-
u can use import and export option
-
its very simple. Just stop MSSQL Servr by double clicking icon on task bar. Goto your following directory Program Files\Microsoft SQL Server\MSSQL\Data. Here you will .MDF and .LDF files over there just select both files and copy to the second server. Start Enterprise Manager. Right click on databases and select attach database from All Tasks and mention .mdf file by browsing and finally the file will be attached..