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

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.

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)?

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.