Use the below queries:

use msdb

go

select * from sys.services

select * from sys.service_queues

Thanks

I have given db_datareader database role to the user.

He only required read-only access and nothing else. In this case, he can not view the database properties right?

We can not give...

could you please provide your inputs for this cluster upgrade?

Thanks

Thank you. I'm looking only the SCHEMA difference.

Here is what I wanted to do:

We have a Production database Mydb on SQL Server instance1 which refreshed (backup & restore) to other...

I understand that the manageability and clear visibility to do the work with t-sql scripts. But I just want to make sure that the functionality done by the Database Integrity...

I'm looking for other options rather than running the log shipping backup jobs in scheduled time intervals like 5 mins or 10 mins

Thanks

Could you please advice me

Thanks

If Total Memory >= Target Memory ------> Represents Memory Pressure

Total Memory < Target Memory ------> Represents No pressure.

So Instance 4 is not experiencing any mem pressures. But the other 3...

In this case for instance 4, when I set the Max Memory to say 4GB, then if the Total Server memory is...

Could you please advice me..

Thanks

Thanks Gail,

On Server A, we have 4 instances. We have 16 GB RAM. Lock pages is enabled.

For each instance, I have set the Max Memory to 3 GB and Min...

Hi,

I have also the same issue with SQL Server 2008 R2 Standard Edition RTM.

No Mirroring and Log shipping options available when I click the database Properties.

But I can see...

if this is a DR server are you using database mirroring? that could cause this if you are mirroring a large number of databases and there is catching up to...

Thank you,

We have the below three different modes for Database Mirroring:

1. High Performance (asynchronous) -- Commit changes at the principle and then transfer them to mirror

2. High safety without...

Then you don't want to get this from the backup job. You want to run a job that will check for this after all the databases have been backed up....