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 |
|
bsethi24
Starting Member
25 Posts |
 Posted - 2011-11-20 : 11:16:15
|
| Dear All,I have implemented the Log shipping manually on my servers & the same is running without any error.I have a question related to LOG backup files & backup history i.e. after how many days or hours we can remove the LOG backup files (OLD ones) those are generated for copying data from Primary to Secondary server AND Backup & related history by executing "sp_delete_backuphistory" store procedure.If we do the same then is there any reverse effect on Log Shipping process?Also tell me the precautions / guideline those are to be taken in Log Shipping whether on Server or on DB level?Kindly guide me.Thanks |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-11-21 : 17:25:28
|
| You can set "delete files older then" option while setting "backup settings". |
 |
|
|
|
|
|
After log shipping after how many days or hours we