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 |
|
sha_agrawal
Starting Member
24 Posts |
 Posted - 2009-11-05 : 09:34:47
|
| We have 2 sql servers connected via LAN with SQL Server 2000databases . 1 server is at our Admin-Block and another at Plant. I want such a mechanism so that our data stored in Plant's Server could be copied on Office's Server automaticaly either simultenously or after a short span of time, to escape any failure of plant's server. I heard about the replication but it is said that it needs change in front-end's coding. I tried to have backup of Plant's server database backup in our office's PC but SQL SERVER 2000 do not permit remote drive for backup.Pls.suggest me! |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-11-05 : 11:35:22
|
| SQL server 2000 DOES permit backups to a remote server. It's not recommended due to network hiccups (do a Google search) but can be accomplished using a UNC path that is shared and that the account running SQL Server agent has rights to.Terry-- Procrastinate now! |
 |
|
|
krishnarajeesh
Yak Posting Veteran
67 Posts |
Posted - 2009-11-06 : 12:35:05
|
| If you are looking for a DR, try using LogShipping. Lot of very useful documents, with screen shots are available ..try googling.Thanks,Krishnawww.SQLServer.in |
|
|
|
|
|
|
Copy of database at another machine