Generate RESTORE DATABASE command from an existing backup

Restoring databases is quite simple, especially if you’re using the GUI.  Just right-click on the Databases “folder” in SSMS, Choose the “Restore Database” option and the interface will prompt you for the database name, from where you want to restore, and other parameters.  I prefer scripting though.  One reason is... [Read More]

Script to generate CHECK Constraints

This is another in a series of “scripts that generate scripts”; in this post I will be covering CHECK constraints. A CHECK constraint basically verifies that the value of the column it is checking evaluates to TRUE when the logical statement defining up the constraint is executed.  The definition of... [Read More]

Database Mail failed to initialize - Unable to start mail session

After configuring Database Mail on a clustered SQL Server 2008 R2 instance using a script based on the Create a Database Mail profile in 4 Steps (or less) article, the test email was not delivered.  Some investigation showed that the email was actually not sent.  I also checked the Database... [Read More]

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]