Upgrading the edition of SQL Server

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 [...]

Work on itWell, now...OKGoodGood job! (1 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...

 

How to find SQL Server agent jobs related to a database

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 [...]

Work on itWell, now...OKGoodGood job! (3 votes, average: 5.00 out of 5)

If you gave a rating less than the maximum, you must leave a comment with suggestions on how to improve the post. :)

Loading ... Loading ...