-
July 2nd, 2002, 03:54 PM
#1
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
-
July 16th, 2002, 12:36 AM
#2
u can use import and export option
-
July 17th, 2002, 07:58 AM
#3
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..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|