One more thing to consider is that if you're taking log backups every 30 minutes, and if you wanted to do a point-in-time restore to 17.15, say, and your last...

Did you follow Jack Corbett's suggestion?

I stop the services through Configuration Manager before shutting down the server. Best to try for a graceful shutdown ;).

One thing to be aware of (but which probably isn't strictly...

I agree with John Mitchell.

What recovery model are you in? If it's Full, are you taking regular log backups?

What do you get if you run this?

SELECT name,log_reuse_wait_desc FROM sys.databases

I use Transcender purely because I bought a training package that gave me access to the practice tests for 180 days or something like that. I haven't actually taken an...

Did you stop the trace before trying to open the file?

There's no error attached at the moment...

Good luck from me too!

A side effect of too many meetings that I have noticed is the general acceptance that attendees will both be late and just leave when they have another meeting to...

Wow, that's very weird. Are you still in touch with the recruiter?

And your job title is Senior DBA? That must be very dispiriting.

No need to go into detail, but would you say the salary is about what you'd expect a Senior...

Good luck!

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...

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....