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.
| Author |
Topic |
|
pankajum
Starting Member
2 Posts |
 Posted - 2011-11-09 : 04:52:04
|
| A Software is Running on a Server(i.e. S1) with a SQL 2000 DataBase(i.e. DB1), it is uesd by User Directly.There is a another Server(i.e. S2) of Same Database Name but not Used by User.I want to update DatabBase of S2 from S1. So that Software installed on S2 shows same Data like S1.It May be Automatically/Manually.I try DataBase Replication/Mirroring, I do not know how to use.Please Help me.Pankaj Kumar |
|
|
vikki.seth
Yak Posting Veteran
66 Posts |
Posted - 2011-11-09 : 08:11:24
|
| few things to note. You can setup mirroring between the two instances, however you'll not be able to read from the mirrored database as it'll be in norecovery mode. You can, however, create a database snapshot over the mirrored database for reading. You can also setup log shipping in standby mode, however users will be kicked out whenever restore starts. Probably you'll need to change the schedule of log restore job on secondary.Refer to Books Online for details.Edit - You said you are using mirroing? Mirroring was introduced in SQL Server 2005. If you have 2000 server, this is not a solution. |
 |
|
|
|
|
|
SQL 2000 DataBase Updation from Other Server