Hi, the only role of a witness server in a Mirroring configuration is to determine automatic failover, so, no, you would not need to restore your database(s) onto the witness...

When you run this query on the secondary, do the results look accurate?

select lss.primary_server,lsms.secondary_server,lss.primary_database,lsms.secondary_database,

lss.backup_source_directory,lss.backup_destination_directory,

lss.file_retention_period [backup file retention period on disk in mins],lss.last_copied_file,lss.last_copied_date,

lssd.restore_delay [Delay time set for resore (Mins)],lssd.disconnect_users [Dissconnect users...

Are you using the Red Gate log shipping feature or the native Sql Server log shipping utility to perform the log shipping?

01. After Backup Set expires can we use backup to restore a database if backup is not purged/deleted?

Answer - The EXPIREDATE option has no effect on whether you can restore...

Correct, you will always want to run an upgrade on the passive node first. Then, when you failover the instance back to that first upgraded node, the databases get...

The advisor appears to examine all sql components. I was thinking it was just centered at the instance level only. If your cluster has different non-clustered aware components...

I would think you could only run the upgrade advisor on the active node only. The advisor checks for database issues that would arise if the upgrade occurs. ...

It sounds like there is definitely an issue with storage for that vm. I would maybe have the VM team move this machine to a different host or possibly...

Try out this script and see if you like the format, of course modify the @path variable per your location -

DECLARE @name VARCHAR(50); -- Database name

DECLARE @path VARCHAR(256); --...

Hi, did this message - "SQL Server has encountered 4084 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file" occur only when the CommVault backup was...

Usually SQL Server Agent alerts for severity 16 through 25 as well as specific alerts for 823, 824 and 825 errors.

Well, at least you have narrowed it down to being a restore problem. I know you have checked this already, but what does the Sql Server error log, windows...

On thing you can try is to stop and restart the mirroring endpoint. This sometimes wakes up the mirroring and it will start trying to catch up - To...

Thanks for the clarification, I should have tested it prior 😉

The basic syntax is this -

ALTER TABLE table_name

ADD CONSTRAINT constraint_name

CHECK (column_name condition);

Example -

ALTER TABLE employees

ADD CONSTRAINT check_value

CHECK (fieldname IN ('Y', 'N', NULL));

Example-

ALTER TABLE employees

ADD...