Could you please advice me.

thanks

Hi,

I found the below script to find last performed Tail...

Hi,

Is there a t-sql command to know the last performed Tail backup on Primary? and last restored tail backup on Secondary?

And on Primary, the last transaction log backup happened is...

Thank you very much for the clarification steve

Thanks

Hi Steve Jones,

I'm waiting for your advice before performing the above steps(which worked in my Test environment) in Production. As you said we cannot do this, I want to know...

I'm NOT using any 3rd party tools for backups and just using Spot light for monitoring

Thanks, I have googled it and read the information about this from the link

How will you set the primary to restoring? you can't back up the tail log, set the database to restoring, and then restore a log from the secondary. You will...

Thank you,

we are not going to create/drop any users. We...

ok.. these are the values I got from perfmon for

0.022792896

0.018652975

So do I need to divide these numbers with any value?

If I get a value 2.0 or >2.0, then...

Hi Scott,

DECLARE @cmds TABLE (

id INT IDENTITY NOT NULL PRIMARY KEY CLUSTERED,

...

Ignacio A,

I have tested the below script many times.

The jobs are showing as they were disabled in SQLAgent, after executing this script BUT the backups are running as usal.

Is...

I'm using the below script to DISABLE log shipping backup jobs:

USE MSDB;

GO

UPDATE MSDB.dbo.sysjobs

SET Enabled = 0

WHERE [Name] LIKE 'LSBackup%';

GO

After executing the above script, backup jobs are showing as DISABLED but...

I got the script from below link http://www.mssqltips.com/tip.asp?tip=1400

thanks

Could you help me on above issue?

thanks