With each new release of SQL Server, MS are providing the DBA with more tools that are netter equipped. CMS is really starting to become a seasoned tool IMHO!

By using central management server in SQL 2008 you may run multi server script and compare the outputs!

The quorum options have changed with Windows 2008, check out technet for full details

Firstly, a cluster is either active\passive or active\active, thats it

The servers...

No, you may also use virtual machines. See my tech article at this link for how to deploy...

if you're using cell encryption then you need to call the encryptby or decryptby methods for each insert\select. The app code would need to reflect this

That's wrong, it should be

Data Source=servername,port number

You configure the port number via SQL Server configuration manager and then use the...

from memory you need port 1434 UDP and TCP. Can you not configure the application with the server name\IP and port number like so

Myserver, 1933

or

192.168.29.28, 1933

Just open the 1933...

Dude

don't tackle the registry directly! Try this link from MS

Halcyon (9/21/2010)

---

If you install Microsoft Distributed Transaction Coordinator (MS DTC) in your SQL Server group and you have other resources that are dependent on MS DTC, MS DTC will not...

AK1516 (9/21/2010)

---

hi folks,

We have planned for a two node fail over cluster where each nodes should have a instance of sql server 2008 running but with different database on...

isd83 (9/21/2010)

---

We are planning to have two clustering environment, both will be Active/Passive which would require 4 servers. Someone in our group suggested to use the same passive node to...

Run the first log backup followed immediately by another then check DBCC Loginfo

hi

what does the following return when executed against the database in question

DBCC LOGINFO

Hint: scroll down the results and check for a status of 2 near the end of the output!

Hi Jeff

results attached. I have a HP laptop with win XP SP2, 3GB RAM and AMD Turion x2 1.9ghz

query took 23 mins 21 secs

Regards

Perry