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 |
|
Chief78CJ7
Starting Member
1 Post |
 Posted - 2004-02-11 : 08:18:47
|
| I have log shipping running on three servers. The source (in a distant city over our WAN), a warm standby in that city and another warm standby local to me here.Its big enough (4gb) that copying the database back from the source to here takes a long time over the WAN. I would love to be able to get a copy of the log shipped databases here and restore them to another server (dev server) to be usable. I cannot back up the warm standby databases because they're in warm standby mode.Does anyone have any experience in what I'm trying to do. It seems a shame to have to copy a backup over the WAN when I have these databases 'right here' all up to date and all... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-12 : 17:40:43
|
| If log shipping had been setup so that the destination database were in read-only mode, then you'd be able to perform a backup on it. When you view the database in EM, does it say loading or read-only? Loading means that NORECOVERY mode was specified and read-only is the same as STANDBY = undo file.So if your database is not read-only, then you'll have to pull the backup over the WAN as you mentioned. But 4GB isn't all that big. We pull larger databases across often. Just zip up the file so that you transfer a smaller file across. If you have Winzip and the backup file is over 4GB, you won't be able to zip it up. You'll need WinRAR or Pkzip if it is greater than 4GB. We use Pkzip.Tara |
 |
|
|
|
|
|
Log Shipping Q - Using a database from a WarmStand