sql server agent backup

sql server agent backup

 You should backup the MSDB database, because all of the SQL Server Agent job information is stored in that database.
It will help you to recover jobs information after SQL server disaster or migrating or upgrading your SQL server.
Execute below query to monitor jobs status like this

select * from msdb.dbo.sysjobhistory

select * from msdb.dbo.sysjobs

If you are having SSIS runing using SQL server agent, you can monitor the status of the job using above queries.

To get Instance name of youyr server you can execute below query

select @@SERVERNAME

Satalaj

sql server agent backupMS SQL server shutdownbackup sql databasegodaddy hosting MS SQL server configurationsql server default portsIIS backup Disaster action planThe shrink operation is not duplicated on the mirror database when you use database mirroring in SQL Server 2005sql server free spaceSql server cpu utilisationMS SQL server service packclient server communication

Author

My name is Satalaj, but people call me Sat. Here is my homepage: . I live in Pune, PN and work as a Software Engineer. I'm former MVP in ASP.net year 2010.
Disclaimer: Views or opinion expressed here are my personal research and it has nothing to do with my employer. You are free to use the code, ideas/hints in your projects. However, you should not copy and paste my original content to other web sites. Feel free to copy or extend the code.
If you want to fight with me, this website is not for you.
 

I'm Satalaj.