Upgrading the edition of SQL Server

Today I realized that I had a clustered instance of a SQL Server 2008 R2, which was installed as a Standard edition.

The databases which were about to be moved to that instance were residing on a Enterprise edition test environment, and I know for a fact that they were utilizing some of the Enterprise features.


Continue reading […] Upgrading the edition of SQL Server […]


How to find SQL Server agent jobs related to a database

When migrating a database to a new SQL Server instance, there are numerous steps to be taken, as I mention here.

One of the considerations is to move all Agent Jobs related to the database to the new instance.

How do we find which jobs to move, though?