sql server agent backup MS SQL server shutdown backup sql database godaddy hosting MS SQL server configuration sql server default ports IIS backup Disaster action plan The shrink operation is not duplicated on the mirror database when you use database mirroring in SQL Server 2005 sql server free space Sql server cpu utilisation MS SQL server service pack client server communication MS SQL server mirroring remove end points master key OLE DB provider SQLNCLI for linked server returned message Cannot start more transactions on this session MS SQL server 2005 attach databse without ldf file MS SQL server Transaction commit rollback Asp.net Interview Questions for 2 years or 3 years experiance OLE DB provider SQLNCLI for linked server returned message The partner transaction manager has disabled its support for remotenetwork transactions ASP.net monitor server Asp.net Create Folder On Server asp net image upload Connection Pooling Linq to Sql cliconfg Unable To Connect To The Remote Server ServerTransfer vs ResponseRedirect transaction

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

Currently rated 3.0 by 1 people

Currently 3/5 Stars.
1
2
3
4
5

Sql Server Mirroring SQL server mirroring works based on principal of Transaction log shipping. Alan, has published this tutorial is for people who are really really frust...MS SQL server shutdownHow to stop ms SQL server service? Here is trick for MS SQL server Fast shutdown. Even you can use net stop ms SQL server and net start ms SQL server to sta...backup sql database In this post, I will explain scenarios of taking backup of entire SQL server data bases and restorng it on other servers. You&n...godaddy hosting MS SQL server configuration Here are steps that will let you configure your godaddy MS sql server host. you nee to Login http://www.godaddy.com/gdshop/default.asp ...sql server default ports SQL server default instance listen on port number 1433. You can tell SQL server not to listen on this port and listen to another port. Open...IIS backup Disaster action planSteps required to deploy web sites from IIS6 to IIS7 migrate iis6 to iis7 migrating from iis6 to iis7 upgrade iis6 to iis7 move a website internet informat...The shrink operation is not duplicated on the mirror database when you use database mirroring in SQL Server 2005 The shrink operation is not duplicated on the mirror database when you use database mirroring in SQL Server 2005. If you are trying to shrink dat...sql server free space MS SQL server writes history of execution of the job alerts errors and wornings at below location C:\Program Files\Microsoft SQL Server\MSSQ...

Comments

11/29/2010 8:54:28 AM #

Thank you for this blog. Thats all I can say. You most definitely have made this blog into something thats eye opening and important. You clearly know so much about the subject, youve covered so many bases. Great stuff from this part of the internet. Again, thank you for this blog.

Los Angeles Criminal Lawyer

11/30/2010 1:54:14 AM #

What I wouldnt give to have a debate with you about this. You just say so many things that come from nowhere that Im pretty sure Id have a fair shot. Your blog is great visually, I mean people wont be bored. But others who can see past the videos and the layout wont be so impressed with your generic understanding of this topic.

Cleaning Products UK

12/3/2010 6:36:59 AM #

Aw, this was a really quality post. In theory I'd like to write like this too - taking time and real effort to make a good article... but what can I say... I procrastinate alot and never seem to get something done.

Dofollow Blog Commenting

12/4/2010 12:24:03 AM #

Your thoughts are amazing. Your blog, not so much. I dont want to disrespect you, just hear me out. Add a little something here. What youre saying is so important itd be a shame if people missed it because they were bored to death. May be a video or a link to something as powerful as the subject. Just a suggestion.

magic tricks

12/4/2010 10:02:24 AM #

I personally have embraced the new technologies and the CMS platforms, I think the new tools only make the web designs better. I am glad that new technologies are coming out in web design that make things easier, improved, and better looking for design.

restaurant loans

12/6/2010 10:01:42 AM #

You make a great point. Got some great information here. I think that if more people thought about it that way, theyd have a better time understanding the issue. Your view is definitely something Id like to see more of. Thanks for this blog. Its fantastic and so is what youve got to say.

folliculitis shampoo

12/8/2010 4:57:39 AM #

Im impressed, I must say. Very rarely do I come across a blog thats both informative and entertaining, and let me tell you, youve hit the nail on the head. Your blog is important; the issue is something that not enough people are talking intelligently about. Im really happy that I stumbled across this in my search for something relating to this issue.

Avery

sql server agent backup

Related posts

Comments

RecentPosts

Page List

Author

sql server agent backup

Related posts

Comments

RecentPosts

Page List

Author

Subscribe / UnSubscribe Email list

Thank you