Can you send the errors through please.

The first thing that comes to mind is: Is the Windows Firewall enabled on the SQL Server and if so have you setup firewall...

Have you considered doing a side by side install, then just detach and attach the databases?

This way you can migrate DB by DB (or in related groups) and test at...

Assuming you are looking for the best option have you considered SQL 2012 AlwaysOn High Avaialbility?

This can be configured as a Geo-cluster configuration but is only supported in Enterprise Edition.

Log...

Steve Jones - SSC Editor (3/14/2012)

---

Leo.Miller (3/14/2012)

---

We didn't even backup and restore the database files, they actually migrated the LUNs from the old server to the new one. At one...

We have just done this (morning of March 8th) for one of our clients. The original environment was a 2 node cluster running SQL Server 2005 on Windows Server 2003...

The simple answer I think is poor design by Microsoft. It would make sense for the ReportServer databases to match the system database collations. The good news is it doesn't...

Assuming none of the row you plan to delete are being activly updated, you could backup and restore the database under another name. Put the database in SIMPLE recovery mode...

Active/Active is really only a logical construct. If you fail one of the instances over so both named instances are running on a single node, you are technically now Active/Passive....

Given that the UPDATE will first update the row, then update the indexes and the SELECT will work through the index and then fetch the row, and both the update...

For a 2005 cluster start here http://msdn.microsoft.com/en-us/library/ms190438(v=sql.90).aspx

Otherwise Google "uninstall sql 2005 from a cluster"

Lots of information here.

Leo

I've jsut been batteling with this myself. I've not found exactly what caused the issue, but the follwoing may help:

http://blogs.msdn.com/b/karthick_pk/archive/2009/03/26/installation-of-sqlserver2008-cluster-fails-on-windows2008-the-group-or-resource-is-not-in-the-correct-state-to-perform-the-requested-operation-exception-from-hresult-0x8007139f.aspx

and

http://support.microsoft.com/kb/811889

I eventually manually created the SPN and suspect, but can't...

If you are using VMware ask your vendor for a copy of the SQL Server on VMware Solution Kit. It's about 20GB zipped, but there's a lot of good information...

We support multiple clients with multiple servers. In general we try do the backups in a reasonably resticted window so the flat file backups can get the files to tape....

To answer your actual question, no.

We support multiple SQL servers for multiple companies and unless they have a particular reason to not use compression we have been using it...

This is an...