RIL_button( “http://sqlconcept.com/2011/09/20/upgrading-the-edition-of-sql-server/”, “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
Continue reading [...] Upgrading the edition of SQL Server [...]
RIL_button( “http://sqlconcept.com/2011/07/13/how-to-find-sql-server-agent-jobs-related-to-a-database/”, “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
Continue reading [...] How to find SQL Server agent jobs related to a database [...]