If these are native SQL backups, you can do a verify only like this:

RESTORE VErifyONLY FROM DISK = 'J:\replication\FULL_SQL4_XRMWH20_20120614_151504_1.sqb',

DISK = 'J:\replication\FULL_SQL4_XRMWH20_20120614_151504_2.sqb',

DISK = 'J:\replication\FULL_SQL4_XRMWH20_20120614_151504_3.sqb',

DISK =...

This is trying to perform a native SQL restore. Is it a native SQL backup? Can Redgate Backups be read natively by SQL Server?

You're reading from and writing to the...

Queries that are executed and their query plans are cached in memory (with a few exceptions like trvial plans). You can query the Dynamic Management Views and functions (DMVs) to...

No built-in function to tell you that. Look at the query plan.

Just to make sure you are aware, it is recommended to never do this. You should take the extra step to ensure you are abl eto control who has access...

I wrote a script to do this a long time ago. It is flexible so you can specify an old and/or new owner and it can change only jobs owned...

For a free tool, it's actually pretty nice despite its limitations, the biggest of which is that you can only monitor a single server with it. It provides good info...

Can you post the script?

Are you restoring to the same server or a different server? Are all of the file paths available and not already in use for the restore?...

I'm only going to add one thing:

You are less likely to have a name resolution problem if you use the fully qualified domain name of the servers. Name resolution is probably the root cause of the...

I'm not sure what replication explorer is, but you can clearly see the status in Replication Monitor that comes with SSMS.

otherwise, agree with vultar that it sounds like it needs...

Yes, definitely uninstall. Should be no issues. Having it installed opens you up to a lot more patches and a lot of security vulnerabilities.

Changing the IP address didn't fix the issue. Something else did. Probably something that was fixed by rebooting (like maybe a "poisoned" service broker queue for one of the partners)....

The updates will not perform a manual failover for you. You need to do that part yourself. Or if you've configured it to reboot automatically as part of the updates,...

Agree 100% with Lynn. Is there any signs of memory pressure or any other reason why you think it should be using more than it is? If not, then you're...