The DNS alias points to the virtual clustered server name. Our DR server is also clustered, has its own virtual name. The DR databases are kept in sync...

Forgot to mention, this is on a SQL Server 2008 SP4 environment, running Windows 2008 R2.

We're failing over from the DR site back to production tomorrow afternoon, at...

We found that pausing SQL using administrative tools/services worked OK. Not sure why this work around is required.

Good article, thanks. Have done this a number of times over the years. One additional step we always take is to reboot the server afterwards. Not sure...

We just added the proc below to master, works like a charm:

CREATE PROCEDURE [dbo].[sp_PageClusterHostname]

AS

DECLARE @p_hostname VARCHAR(500)

DECLARE @v_hostname VARCHAR(500)

DECLARE @STR VARCHAR(1000)

SELECT @v_hostname = @@ServerName + ' SQL Server Restarted'

SELECT...

Now I can see them - I'm further enlightened now. Thanks.

The images are also not showing up for me, either. When I hover, it says 'screenshot' or 'query extract', but a lot of blank spaces in this article.

Thanks for the great article, Brad.

We've been using SQLdm for a number of years, we like it a lot. The History Browser is handy, too.

And we DBAs...

Neat concept, but did you consider that since you've added a linked server to connect to your 2005 instance, anyone with a login on the 2000 instance now can access...

Interesting concept, thanks for an eye opening article. However, as a fan of the 'Keep it Simple' club, I'd prefer not to have to configure & keep updated all...