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 |
|
ewe1d@yahoo.de
Starting Member
17 Posts |
 Posted - 2004-10-15 : 07:27:34
|
| Hi,Have set up log shipping and was looking for a a way to take full db backups from warm standby so as to lighten the load on the primary system. Is this possible? In 'normal' operation (restore with standby) I get Server Msg 3036 Database 'Northwind' is in warm-standby state... but is here any workaround for this?ThanksChidd |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-10-15 : 14:34:00
|
| Yes if you are in warm standby, then you can setup a job at the secondary to do the full backup. So your database is in read-only mode at the secondary server?Tara |
 |
|
|
ewe1d@yahoo.de
Starting Member
17 Posts |
Posted - 2004-10-18 : 07:17:38
|
| Hi,yeah the secondary was set up to receive transaction logs via Log Shipping Wizard, it is running WITH STANDBY but how do I get a backup without getting the error message?(Msg 3036, Level 16, State 1, Line 1, Database 'Northwind' is in warm-standby state (set by executing RESTORE WITH STANDBY) and cannot be backed up until the entire load sequence is completed.) |
|
|
|
ewe1d@yahoo.de
Starting Member
17 Posts |
Posted - 2004-11-04 : 04:15:15
|
| Hi,Quote:"Yes if you are in warm standby, then you can setup a job at the secondary to do the full backup. So your database is in read-only mode at the secondary server?"How can you do the full backup on the warm standby server without running into the eroor "Msg 3036.." ? The only way I can think of is to shut down the SQL server and back up the DB files. |
|
|
|
|
|
|
Backups from warm standby