It is quite natural for the Transaction Log to grow during Rebuild index operation. Even if you implement log shipping, the transaction log backup will be *big* in size after...

@barakos,

To add to the list, since you are using SQL Server 2008 you can make use of SSMS to run query against multiple servers by registering the instances....

The URL is hyperlinked to this forum post. Must be a typo!

@thamilanga,

This should be a good...

You can make use of -W switch in sqlcmd utility to remove the trailing space.

http://technet.microsoft.com/en-us/library/ms345419.aspx

You can double click on the column edge to resize it as seen in this screenshot.

Brandie Tarvin (1/4/2011)

---

I didn't even try that... Are you using a name in the drop down list?

I overwrote the list with the account (because it's not on my box),...

Please check if the SQL Server instances was starting up when you saw the error message. You can go through the Event Viewer/SQL Server Error Log.

karthik.catchme (1/4/2011)

---

I would like to know why should we keep the master database in "master only recovery mode". What happens if we don't keep it in the master only recovery...

SQL Server "Alerts" can be configured to trigger when the Transaction Log is xx% full. As you mentioned, you have to write a custom script to meet the requirement.

Sumanta,

Are you able to connect to this instance using SSMS?

Does changing the job owner to a "sysadmin" login help?

Did you click on "Remove Agent History" and click Ok. If yes, this will clean up history.

Hi Wallace,

You can query sysprocesses to check which session is currently active on that database and kill it.

SQL Server tracks changed data through Differential bitmap pages. Here is more information on it.