using virtual disks for the VMs SQL Server storage will be the weak point. For the SQL Server data storage drives they are better created as RDM's and ideally the...

BigSam (5/20/2011)

---

I have a 2-node cluster that I want to migrate to a 3-node cluster with more storage and memory. The current 2-node cluster will be retired.

Both clusters are running...

king_emperor_in (5/19/2011)

---

Thanks for your reply, Well i did exactly the same thing on my local machine and it was fine.

but if i will do that on my Production Server, wouldnt...

or someone\something is taking a log backup

2008 and 2008 R2 may reside on the same hardware

also you want to be using the sys.database_principals catalog view and not sysusers. This should be better

declare @sql nvarchar(max)

set @sql = ''

SELECT @sql = @sql+

'

print ''Dropping '+name+'''

execute master.dbo.sp_revokedbaccess '''+name+'''

'

FROM

...

you're welcome 😉

you're welcome 😉

Either upgrade to windows 2003 Enterprise 32 bit or windows 2003 Stndard 64 bit 😉

It does indeed but...

Standard 32 bit will only support a max of 4 GB RAM

EdVassie (5/18/2011)

---

My approach would be to do a standard side by side build and test of the new server.

When it comes time to put the new server live,...

wrong

king_emperor_in (5/19/2011)

---

Well I can only move TEMPDB database...

bounceaball (5/19/2011)

---

Our IT guy recently change the server name on my request from CSIADOLP1 to CSIADRPT01. I did use sp_dropserver and sp_addserver.

I am seeing different results.

I have attached the screenshot...

have you checked the sql server logs