Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Replicate Database

Author  Topic 

SIEBELSQL
Starting Member

2 Posts

Posted - 2004-09-03 : 11:24:09


Hello Everybody,
First of all let me tell you that this is my first serious SQL server task and I am not a DBA.
I have a SQL SERVER instance with three databases on one computer and would like to replicate the same on other computer with data OR you can say that I want to move my SQL SERVER database to another hardware. Can any one please give me instructions so that I can follow it.

Thanks in advance.

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2004-09-03 : 11:39:15
USE Backup / Restore for one time operation that is you dont want the data changes after backup.
Otherwise look for topic REPLICATION

Read Programs>Microsoft SQL Server>BOL (Book onLine) for detailed instructions.



- Sekar
Go to Top of Page

SIEBELSQL
Starting Member

2 Posts

Posted - 2004-09-03 : 11:52:03
Thanks! let me try it.
Go to Top of Page
   

- Advertisement -