Glad you guys found this useful, i found it helped immensely when performing installs with the RTM media which had a few issues!

Windows 2008 setup creates the first partition (boot) and automatically aligns the partition when creating it.

For windows 2003 you have to manually align using diskpart.

At the end of the day...

xbarf (12/19/2010)

---

Hi,

Many people talk about "disk alignment" for Windows Server 2008 and its effect on SQL Server performance.

I have a new PC and I am going to install Server 2008...

the network binding error is common on Windows 2008. You need to go into the registry and find the key as follows

HKEY LOCAL MACHINE\SYSTEM\CurrentControlSet\Services\TCPIP\Linkage

Check the values for the Bind entry....

As you are using Windows 2008 you have multiple clustered MSDTC applications, one for each clustered instance of SQL server is possible!

each sql server instance may have only 1...

nikshepmehra (12/13/2010)

---

Sorry , guys ... I was trying to connect to the server and had the ODBC on my machine i.e the client instead of the server just did it...

endpoints are created locally and used as the connection points between mirroring sessions!

it would be helpful if you could provide a little more detail as to your current setup.

Which version VCS are you using?

do you have a suitable driver installed on the server, check ODBC settings for the currently installed driver versions

If any packages are using dts only components they will need re writing immediately and won't run in legacy mode.

INNOCENT GUMBO (12/7/2010)

---

I am more concerned with DTS Packages from SQL 2000, Is it possible to let all of them run on Legacy Mode or it is advisable to upgrade...

Rich Holt (12/3/2010)

---

Perry Whittle (5/8/2010)

I use FreeNAS and present the LUN's over iSCSI to the Windows 2008 cluster nodes. Check my tutorial at this link

http://www.stokecs.co.uk/TechDocs/Creating%20a%202%20node%20SQL%20Server%202008%20Cluster%20Configuration%20using%20Windows%202008%20MSCS.pdf

for details of how to...

it's easier to slipstream the service pack at install time!

weaseludo (11/30/2010)

---

Hola a todos , me ayudarian mucho si alguien me pudiera contestar si hay forma de crear un backup de un base de datos por medio de la instruccion...