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 |
|
MBeal
Posting Yak Master
110 Posts |
 Posted - 2002-11-04 : 14:30:27
|
| Please be gentle -- I'm somewhat new at SQL. Our Network Administrator has never done this, I've never done this, and we just want it to go as smoothly as possible.We have a production server and a backup server (both SQL 2000 and Windows 2000). We want to use log shipping to restore the databases on the backup server in the event of a failure. We aren't running the Enterprise Edition (because of the licensing cost) so I can't rely on the maintenance plan wizard to walk me thru this. I haven't found any real assistance on BOL. I understand that log shipping is just backup and restore but I can't get my brain around how you actually ship the data / logs. Do you use a DTS package? If so, do you create the DTS package on the production server or the backup server? If on the backup server, how do you tell it where everything is to come from and go to?I am certain there is an article out there somewhere with step by step instructions -- I would very much appreciate some assistance. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
|
|
MBeal
Posting Yak Master
110 Posts |
Posted - 2002-11-04 : 14:42:44
|
| Muchoooooosss GrassyassMissed the obvious -- again. I searched the forums -- didn't search there though. Thanks again! You guys are great!MBeal |
 |
|
|
|
|
|
Log Shipping