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 |
|
dave
Starting Member
15 Posts |
 Posted - 2004-09-29 : 18:50:21
|
| We have a situation which I am sure is not that uncommon and I'd really appreciate any recommendations. Our SQL Server databases are hosted at a remote location and whilst we have direct access to them we unfortunately don't get administrator privelages. We have a fairly critical application where we cannot really afford to not have access to the data for any length of time. What we would really like to be able to do is have the latest changes the the database backed up to a local SQL Server (which we do currently have). We can then at least access the local version in read only mode until the live server comes back online. Right now we simply have a scheduled DTS package to copy the objects across which of course means remembering to update the job whenever a table or sp is added!Is replication a viable possibility or is there some other software that anyone would recommend? If replication is used I'm assuming that we'd be wise to use SSL to encrypt the download.Any suggestions or recommendations would be very gratefully appreciated! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-29 : 18:54:58
|
| It sounds like log shipping would be best for your scenario. Do you have Enterprise Edition of SQL Server 2000? If you do, log shipping comes with it. If you don't, then you can create your own custom stored procedures to do this. It just involves full backups, tlog backups, copying of files, and restores.Tara |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2004-09-29 : 20:52:12
|
| Why use SSL? Are the SQL boxes directly accessable from the internet? Or do you have a private connection into the network they are located on?The log shipping approach sounds best for you. If you have Enterprise edition use the wizard to set it up as suggested by Tara. If you have Standard edition you can use the scripts in the SQL 2K resource kit. I thinkt they called it Simple Log Shipper or something like that.-ec |
|
|
|
|
|
|
Remote backup