You can use the parameter @CleanupTime to delete old backup files. It's in hours so you have to set it to 144 (24 * 6) to keep backup files for...

I prefer to use SQL Server Agent output files. This way the output from the stored procedures are redirected to text files. I have an installation script that creates the...

I think that it's because the database you're in is not in compatibility level 90 or higher.

EXECUTE dbo.sp_dbcmptlevel @dbname=N'DatabaseName', @new_cmptlevel=90

Ola Hallengren

http://ola.hallengren.com

I have a script that you're welcome to use, if you have difficulties getting your script working.

http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

Ola Hallengren

http://ola.hallengren.com

It is only the database that you are creating the objects in, that has to be in compatibility level 90 or 100. All other databases can be in any compatibility...

Satya has written about this in another forum.

"Create a SSIS package to perform this maintenance plan task and use DTUTIL to deploy on multiple servers."

http://www.microsoft.com/technet/prodtechnol/sql/2005/mgngssis.mspx#ERGAE

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1203074&SiteID=1

If you're interested I have a...

>Is there any script like only the tables which really need reindexing should be reindexed?

I have a solution that you're welcome to use.

http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

Ola Hallengren

http://ola.hallengren.com

My script is using the normal BACKUP LOG command. When this command is performed the transaction log is truncated. (It is however not shrinked.)

Ola Hallengren

http://ola.hallengren.com

I don't know about the root cause of the locking issue, but one thing that you could do to prevent the index optimization job from hanging is to use SET...

schep021 (8/29/2008)

---

I wrote a script that will go through each index on a db and determine if it should be rebuilt, reorg, or skipped based on certain criteria. I...

Sagar (8/28/2008)

---

i have already create script or doing some defragmantation task update statistics but it is only for offline. i don't have more knowledge one things i can do while...

You can look at the index_id in sys.dm_db_index_physical_stats.

0 = Heap

1 = Clustered index

> 1 = Nonclustered index

The clustered index is the table.

If you use my solution you could set the...

You can check the page_count column in the DMV sys.dm_db_index_physical_stats.

If you use my index optimization stored procedure it is logged in the output file.

http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

Ola Hallengren

http://ola.hallengren.com

You could use MaintenanceSolution.sql that creates all objects.

You could also just create the objects that you need. That would be DatabaseIntegrityCheck.sql, IndexOptimize.sql, CommandExecute.sql and DatabaseSelect.sql.

Then you just execute DatabaseIntegrityCheck and...

I have a stored procedure that could help you with this. The stored procedure has been designed to only rebuild or reorganize the indexes with fragmentation, but it it can...