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 |
|
ksr39
Posting Yak Master
193 Posts |
 Posted - 2012-02-01 : 13:08:48
|
| Hi Experts,Is this possible to take a full backup on a log shipping database in SQL Server 2008R2.I heard that we can take a full backup on log shipping database in Sql Server 2008.Please conform me whether we can take a full backup or not.Thank you |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-02-01 : 13:32:30
|
| Hi Kizer,Thank you for the information. Do we need to restore all the transaction log backups which are taken after full backup or all the tlogs which are taken from first. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-02-01 : 20:49:17
|
| Sorry for the delay Kizer,We already have a log shipping setup. On that database if we take a Full Bcakup, will the log shipping breaks or not in sql server 2008R2. As i need to take a emergency full backup of that database which is under log shipping. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ksr39
Posting Yak Master
193 Posts |
Posted - 2012-02-01 : 22:48:45
|
| Oh Ok Thank you very much for this valuable information Kizer. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Log Shipping