Daily Archives: 10/14/2014

Downgrading a SQL Server database to a lower version

This entry was posted in Sql Server 2005 Sql Server 2008 Sql Server DBA Sql Server tutorials and tagged database downgrade scripting server sql sqlserver2008 on by .

Scenario proposal After recently upgrading a SQL Server instance to SQL Server 2012 a few days ago, you noticed that your application is not functioning properly. You decided to roll back the upgrade by downgrading the SQL Server database engine to SQL Server 2008 R2.  After the downgrade of the database engine, you are unable […]

Testing options in SQL Server 2005 and 2000

This entry was posted in Sql Server DEV Sql Server tutorials and tagged options server sql testing on by .

Scenario Testing database applications for many organizations is a challenging task that is difficult to setup, automate and validate.  Luckily, more time is getting allocated into development projects to conduct more rigorous testing.  In this tip we will outline some of the realities to perform SQL Server 2000 and 2005 testing and opportunities to streamline […]