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 |
|
scottpt
Posting Yak Master
186 Posts |
 Posted - 2004-08-23 : 14:22:16
|
| Is it possible to backup the secondary DB of a logshipping pair? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-23 : 14:36:08
|
| Yes if it is read-only. You would only want to full backups on it though.Tara |
 |
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2004-08-23 : 16:14:24
|
| Server: Msg 3036, Level 16, State 1, Line 1Database 'pd_training' is in warm-standby state (set by executing RESTORE WITH STANDBY) and cannot be backed up until the entire load sequence is completed.Server: Msg 3013, Level 16, State 1, Line 1BACKUP DATABASE is terminating abnormally. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-23 : 16:17:07
|
| So is the database read-only or in a loading state?Tara |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-08-23 : 16:27:00
|
| Why do you want to back up the read-only pair of the log-shipping DB anyway? You already have a backup of it that you restored, just use that backup again.... |
|
|
|
|
|
|
Backup readonly DB