All of my deployments are generally documented as a combination of Visio diagrams and Word docs detailing the complete setup from host names and IP addresses to storage.

dmoutray (10/7/2011)

---

The exact wording in the Microsoft document is "Each Server License for SQL Server 2008 R2 Enterprise permits you to run the software in up to four (4) Operating...

Brian Brown-204626 (10/7/2011)

---

When I go to the download screen for R2 SP1, in addition to the I64, x64 and x86 file, there are two files for Management studio. Does...

you could use the Windows 2008 eval or sign up for a Technet subscription 😉

did you check the VMWare...

CHECKDB will rebuild the transaction log too, complete description is here

Lynn Pettis (10/6/2011)

---

The key to your problem is the spaces in the database name. You need to surround the name with [], just like you would with column names...

parissa_bakhshi (10/8/2011)

---

Think it's not a real cluster when you have different network names. What was the reason for using different network names for SQL resources? You can install a new...

amenjonathan (10/6/2011)

---

Is there a way to change the subnet mask of the cluster without dropping and re-adding the IP? I've got the IP properties window open, and the subnet mask...

laddu4700 (10/7/2011)

---

Hi,

One of our dev database is in suspect mode, not sure what went wrong.

Below are the details

DBCC CHECKDB (My1C_DevMS) WITH NO_INFOMSGS, ALL_ERRORMSGS

Msg 926, Level 14, State 1, Line...

yassermat (10/8/2011)

---

Hi

I am going to describe my requirement first:

I have a central SQL server which must be synched to other SQL clients. I need a mechanism to synchronize every database...

Well done Mohammed.

This is article is designed to do exactly what has happened here. You've a deal more now haven't you 😉

You're only showing 1 hard disk attached to the vm, might be worth deleting the virtual machine and starting again.

What subnet do you have configured for VMNet2?

Can you ping...

On a host machine with low resources this is common, creating the pre allocated disk file will...

timscronin (10/5/2011)

---

THis is a good one and I have been given 2 days for a solution.

We have a vendor app which will run a our local and other...