Error setting private property 'VirtualServerName' when installing an SQL Server 2008 R2 cluster

I was recently installing SQL Server 2008 R2 Standard Edition on a two-node failover cluster (see Features Supported by the Editions of SQL Server 2008 R2 on MSDN).  The cluster was working perfectly and the Validate a Cluster Configuration Wizard reported all components in green. I had prepared a slipstreamed... [Read More]

Script to Generate CREATE TABLE Definitions

Once the target environment is installed and configured, a database migration cannot commence before the database and the table structures that will hold the new data are in place.  Creating table definitions can be performed using various methods, a couple of which are tools provided with SQL Server, and third-party... [Read More]

Moving the tempdb Data and Log Files as Part of a Planned Relocation

A colleague recently told me that an SQL Server instance tempdb was installed to the Program Files folder of the C: drive and that occasionally the server was complaining of low disk space.  The only way this could be solved was by restarting the server. The tempdb is a system... [Read More]

Automated Database Scripting to Preserve Intellectual Property

Copies of live database are frequently hosted on development servers. In some cases these occupy several Megabytes or Gigabytes of disk storage. This is acceptable for the duration of the project development, testing (and other uses) however it might not be feasible, both from an economical as well as security... [Read More]