CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Location
    India
    Posts
    0

    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

  2. #2
    Join Date
    May 2002
    Location
    Colombo,Sri Lanka
    Posts
    1,110
    u can use import and export option

  3. #3
    Join Date
    Nov 2001
    Location
    Pakistan
    Posts
    9
    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
  •  





Click Here to Expand Forum to Full Width

Featured