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 - 2003-11-20 : 10:11:51
|
| Can you do a full backup of the secondary server and not break log shipping? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-20 : 12:17:29
|
| Yes you can. But is your database in loading or read-only state (both options are available when you configure log shipping)? If it is in loading state, then you won't be able to back it up, not because it would break log shipping, but because the database is just unavailable.Tara |
 |
|
|
scottpt
Posting Yak Master
186 Posts |
Posted - 2003-11-20 : 13:11:43
|
| We will be using read-only since this will be a DR/Reporting db. |
|
|
|
|
|
|
Log Shipping and Tape backups