Category Archives: Automation in SQL Server

Running SQLDiag as Agent Job


This was the discussion of last evening, which was started after we receive a similar request from a specific team. The team wanted to start this trace by themselves without involving the DBAs. One of the possibility was to run … Continue reading

Posted in Automation in SQL Server, How To, Just Learned, SQL Server Tools | Tagged , , | Leave a comment

Failed Job Notification To Event Log


Earlier, I had written a post about a failed job issue. A friend of mine, after reading this post, asked how should he verify the SQL jobs running in his environment without this notification option? By executing the following script, … Continue reading

Posted in Automation in SQL Server, How To, Jobs, Just Learned, SQL Server, T-SQL | Tagged , , , , , | Leave a comment

Database Mirroring with SQLCMD


Finally, I build my script to configure Database Mirroring in High Safety Mode. Earlier, I had written a post on configuring Database Mirroring in High Availability Mode. However, this time, I had written a script to automate the complete process … Continue reading

Posted in Automation in SQL Server, Database Mirroring, How To, Just Learned, SQL Server, SQLCMD, T-SQL | Tagged , , , | 2 Comments

Creating Maintenance Plan with Maintenance Plan Wizard in SQL Server 2005


In this post, we will discuss how to create Maintenance plan in SQL Server 2005. The environment is having SQL Server 2005 SP3 installed. Before creating the maintenance plan in the lab environment, let’s see our requirement. Maintenance Plan Details … Continue reading

Posted in Automation in SQL Server | Leave a comment