I forgot to ask you what does the sql agent shows as last run?

I'm going to run the script on my test environment. I will let you know what re the results!

Ok, my guess will be that your log shipping is working fine. Maybe your files are not being deleted because the account you use for logshipping does not have enough...

I created a test DB on the primary server backup it, restore with norecovery on the secondary server and then setup a Log shipping.

I ran the backup, copy and restore...

Are you using snapshot replication?

As far as I'm concerned that script should work!

I'm using the SQL overview package. It helps you to monitor your jobs, your logs and a lot of things that are very useful. Then I use reporting services...

Thanks for the script!

Could you please specify what kind of snapshots are you talking about? Thanks in advance

Hi,

It is a huge script. I did not have enough time to check the whole script. But there are a ew things I can see from your output:

1- No all...

Thank you for answering. I got the error only once. I was not able to find what was causing the error. I check all the databases on that server, but...

did you find out what was causing the error?

Your welcome!

Your welcome!

I agree with GRE! Just create the users with the same sids on the master DB.