There are a few DR options

Site A (2 servers)

- Windows clustering - Active/Passive

- Mirroring

Site B

- Log Shipping - quite robust but slower to recover your DR database

- Mirroring - depending...

Solved my own problem - Firewall had turned itself on the Witness / XP box -grrr!

Thanks Abbs, will keep an eye out for it 😎

Can anyone recommend an alternative to the MS guide for 70-432? After seeing Winston's review on Amazon, I'm a little reluctant to purchase this guide.

Yes, they are completely independent of each other.

I'd suggest sp_lock to get a list of locks. You might also want to read up about locking types.

For blocking processes, sp_who & sp_who2 will give you a good idea...

Sorry I didn't suggest this earlier but Transaction Log Shipping is another good option for your migration.

This might prove to be lower risk and slightly less downtime. You then...

The detach/attach process is very quick as you're not creating files and hitting I/O.

You could script it for minimal downtime as I find the GUI can be cumbersome if you...

I'm quite certain there is no direct upgrade path from x86 to x64in SQL 2005.

If backup and restore isn't an option, detach/attach should be a fair bit quicker.

Unless he is talking about a backup drive or a drive...

Check your Dependencies in Cluster Administrator for SQL Server.

Make sure all your clustered disks are added as dependencies. If the SQL resource comes online before the physical disk does, SQL...

If MSDTC has been setup correctly in its own cluster resource group, all nodes should be able to access MSDTC regardless of which node has ownership. I don't think SSIS...

Hi,

How about a function that strips the Alpha out like this

CREATE FUNCTION dbo.RemoveAlpha(@Str varchar(1000))

RETURNS VARCHAR(1000)

BEGIN

declare @NewStr varchar(1000),

@i int

set @i = 1

set @NewStr = ''

while @i <= len(@str)

-- STRIP...

SQL Server Side: Go to SQL Server Configuration Manager - Under SQL Native Client Configuration is your Client Protocols and the order your instance will use. You can put TCP/IP...

Hi Erin,

A few conditions need to be true for this to work

- Client & server are in the same domain

- You've run the setspn stuff against the SQL startup account...