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 |
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
 Posted - 2008-04-07 : 07:13:12
|
| In log shipping the transaction logs backups are scheduled for every 15 min. If we took some manual transaction log backup on the primary server in the meantime. As a result of this operation will it effect log shipping or log shipping will fail because of the logs are not in the right sequence. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-07 : 09:14:12
|
| Why you have to take transaction log backups when they are backed up every 15 minutes? You have to manually restore in secondary server. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-07 : 23:44:42
|
| If you backup log by running log shipping job manually, file copy job will copy it along with normal log backup file at next scheduled time. And log restore job will restore them as well. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-07 : 23:57:38
|
| But have to backup in Same shared folder. |
|
|
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
Posted - 2008-04-08 : 05:43:51
|
| Suppose if i want to implement log shipping as well as backup strategy.Backup strategy every night full backup. every 4 hours differential backup. every half nour transactional backup.In log shipping every 15 min backup jobs are running and they are located on a shared folder.Will this possible or they contradict each other ( because in log shipping for every 15 min we are taking t-log backups and in backup strategy we are taking t- log back ups for every 30 min) . is it possible. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-08 : 13:24:37
|
| You can not run a transaction log backup outside of the log shipping job or you'd have to manually apply it to the secondary server. Even if you put it in the same shared folder, log shipping will not copy and apply it to the secondary server. All tlog backups must occur through the log shipping transaction log backup job. Otherwise you will break log shipping. There is really no point to creating a different backup strategy though as log shipping is your backup strategy. In the LS plan, have it perform a full backup daily.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
log shipping