Sumanta Roy (1/26/2012)

---

Hi,

There is a user database which has 1 mdf, 6 ndf and 4 ldf files. I have taken the database offline. I cannot move all the files. For...

Run this and check the results, it will return the cluster groups that are active and the node they're active on

CLUSTER GROUP /NODE:dbhced01

CLUSTER GROUP /NODE:DBHCED02

This will get the cluster...

hwat were the results of your cluster verification report when you first deployed the windows cluster. try running it again to see if it pinpoints any issues

Yes I have VMWare ESX4i at home and VMWare Server 2.0.2 on my laptop.

Ok so both nodes are part of the windows cluster. Now run the command to list the possible owners of the clustered SQL server resource.

go onto one of the cluster nodes and post the results of this when run from the command prompt

cluster /CLUSTER:yourwindowsclustername NODE /STATUS

check the cluster error events within failover cluster manager for more info

There was never any doubt this would work as the truncate will de allocate all the pages, no ghost records to clean up!

MarkThornton (1/24/2012)

---

and then...

You shouldn't treat the VM any different to s physical machine. How do you back up these?

Options such as VMWare vmotion make a virtual machine highly available and all...

The SQL server 2008 installer has an option to maintain SQL server editions. Run the installer and check the maintenance section, from memory it's in there.

Just out of interest, why????

Have you checked the subversion help material? This will give you a basic idea

http://svnbook.red-bean.com/en/1.7/svn-book.html

database name would normally be a data type of SYSNAME or NVARCHAR(128). varchar(32) could result in the database name being truncated

What is the schema definition of this table

Unit4_Beheer.dbo.DATABASES_TO_RESTORE

execute the following query against the principal and the mirror instances

select sid from sys.sql_logins where name = 'yourlogin'

The output will be different. You can either use sp_helprvlogin as already suggested,...

The number of virtual...

shijimon.jacob (1/20/2012)

---

Hi

Thanks for your clarification on this.

One of the articles on MSDN states the below.

http://msdn.microsoft.com/en-us/library/ee308825(v=bts.10).aspx

"SQL Server 2008 and SQL Server 2005 Standard Edition supports 2-node failover clusters. If you...