SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Log shipping error


Log shipping error

Author
Message
arooj300
arooj300
SSC Veteran
SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)

Group: General Forum Members
Points: 295 Visits: 533
Yes , recovery model is Full, I have talked to my sysadmin, he doesnt have time slot so that he put backup stratgy like this.but i wanted to set log shipping . would it possible to set log shipping with same backup startgy. Please advise
Beatrix Kiddo
Beatrix Kiddo
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2730 Visits: 4391
Ok, please answer every question as fully as possible;

1) why are you log-shipping at all? What are you hoping it will achieve for you (or is this purely experimental for your own knowledge)?

2) why are you only backing up the log once a day?

3) is this a production environment?

4) are you "the DBA" or is there another DBA on-site?

Thanks
arooj300
arooj300
SSC Veteran
SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)

Group: General Forum Members
Points: 295 Visits: 533
Hi, thanks for the reply,

1) I am giving you answer for your first question, log-shipping will help to decrease the disaster recovery. if production server will go down , user will sit odlw they can use secondary database.

2) I am not taking log backup. one more DBA is there he is taking , he asked , but he is finding time slot to run log backup frequently. for that one we are planning . we are just strtup comapny , so it will take some time to grow.

3) this one alredy included in 2nd question , please see the 2nd point.

4) this question , i have already given.


I have some doubt. please clarify.

1)by that time can we configure log-shipping in this environment, hence log backup is runing once in everyday.
2) shall i stop taking log backup , so that chain will not break.
Beatrix Kiddo
Beatrix Kiddo
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2730 Visits: 4391


2) I am not taking log backup. one more DBA is there he is taking , he asked , but he is finding time slot to run log backup frequently. for that one we are planning . we are just strtup comapny , so it will take some time to grow.

That's probably your problem right there, then. How often is he taking log backups (which are separate to the one you take)?
arooj300
arooj300
SSC Veteran
SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)

Group: General Forum Members
Points: 295 Visits: 533
oncein a everyday
Beatrix Kiddo
Beatrix Kiddo
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2730 Visits: 4391
Ok, that is almost certainly why your log-shipping isn't working. Your first task (if you really want to set up log-shipping) is to get him to stop that completely. If you don't do that this won't work.

- Next (and this is just what I would do), go back to your log-shipping job on the Primary server, and reconfigure it from scratch. Just dump everything and start again. (It's not working anyway, so who cares, right?) This time configure all of the jobs (that's LSBackup, LSCopy and LSRestore) to run more frequently than once a day. How frequently depends on your environment and how much data is changed etc. Plucking a number out of the air, let's say every 15 minutes. Set your jobs to run every 15 minutes.

- When you've done that, run each job manually once and observe what happens. So on the primary, run LSBackup, go to Job History and check that is has completed properly.

- Then go to the secondary and run LSCopy. Wait for it to complete successfully. Go into your log-shipping folder and check that the log backup file is physically there.

- If all is good so far, run your LSRestore job manually once too. Check the Job History and see that your 1 log file has been restored successfully. Monitor the whole process for the first few hours (not continuously- just check it now and then).

All of the above will only work if you are taking no other log backups. If your DBA takes extra log backups separately this won't work. S/He won't even need to take any anyway because you are taking them every 15 minutes.

Does that make sense?
arooj300
arooj300
SSC Veteran
SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)SSC Veteran (295 reputation)

Group: General Forum Members
Points: 295 Visits: 533
Thanks Beatrix , I will follow the same. Thanks for your valuable time and helping me in this scenario.
Beatrix Kiddo
Beatrix Kiddo
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2730 Visits: 4391
Good luck!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search