Right click on the maintenance plan. Select Modify

Above the maintenance plan name there is bar with few icons.

Click on the icon with tip Reporting and Logging. It is next to...

On a single server, mirroring works between two instances.

If you drop and recreate an object, you have to grant all the permissions again to the users.

If you alter an object, all the existing permissions will be remain.

Timothy.Cloud (4/23/2010)

---

I have been asked if I can setup replication to get those 2 servers identical in case we need to fall back to the physical vs. the VM.

Can this...

Insert/Update/Deletes cause index fragmentation.

Alter index rebuild/reorganize is used to defragment index.

Your stored procedure has only one task or many?

Use WAITFOR between tasks inside the stored proc.

How many CPU's are there in the server?

You can limit the number of CPU's...

There is a script in BOL to rebuild/reorganize indexes.

Icon does get updated automatically. You need to refresh.

venkatreddy.bashi (4/15/2010)

---

The size of the log file is not reducing even I took the transactonal log backup.

I am sure the the log file has no active transactions, because when i...

Any plans to upgrade to SQL Server 2008 Enterprise Edition?

It has native backup compression option.

Another third party tool for SQL Server 2005 is Idera's SQLSafe.

See this log file on the server:

C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt

How many rows are there in the...

SET ROWCOUNT can limit the number of...

http://support.microsoft.com/kb/918992

Use EXEC sp_help_revlogin provided by Microsoft in the above link