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

 

How to decommission database or SQL Server instance

RIL_button( “http://sqlconcept.com/2011/05/13/how-to-decommission-database-or-sql-server-instance/”, “How to decommission database or SQL Server instance” );

How to decommission a database

Before decommissioning a database, try to find out which application the database is related to. Either talk to the application owner or run Profiler for some time and check if anyone is using the database.

Here are some steps to take:

Check if

Continue reading [...] How to decommission database or SQL Server instance [...]

Work on itWell, now...OKGoodGood job! (2 votes, average: 3.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 ...