I haven't seen a whitepaper for SQL Server 2005. My guess is that the SQL Server 2000 whitepaper is valid on SQL Server 2005 too. Kalen Delaney referred to it...

New_to_being_DBA (8/21/2008)

---

I've read many places where it says to ignore framentation (at 100% if the table has less than 9 pages) although I haven't seen it documented anywhere on msdn....

I think that the question is how to read the message "Databases with simple recovery model will be exluded." in the database selection form.

It looks like it only means that...

I have tested this on version 9.0.3068 and to me it looks like a bug.

I have a backup stored procedure that has this functionality. Please use that if you like.

http://ola.hallengren.com/sql-server-backup.html

Ola...

I was just thinking that you could do a

select name from sys.databases

in the start of the script.

If you use a temporary table you could do a

select name from #dblist

right after...

GilaMonster (8/14/2008)

---

None of the DMVs actually 'store' data. They are not tables. They are views that expose certain aspects of sQL's internal structure. So, as far as I know, dm_db_index_physical_stats...

Very strange. I think that Ray Mond's advice is good. Another thing could be to add some logging to the script and output it to a sql server agent output...

Jeffrey Williams (8/11/2008)

---

Note: if you have any LOB columns on the table then you cannot rebuild the clustered index online. If any of the non-clustered indexes include any LOB...

I have a stored procedure that can help you with this.

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

Ola Hlalengren

http://ola.hallengren.com

It is not a good idea to update the statistics after an index rebuild. The index rebuild operation has rebuilt, not only the index, but also the statistics.

Ola Hallengren

http://ola.hallengren.com

Maybe there are just no indexes that needs to be rebuilt or reorganized in this database.

Sometimes on small databases many indexes fall below the PageCountLevel. Try setting @PageCountLevel = 1...

Some answers to DBA's questions.

The logic in the DatabaseBackup stored procedure is like this.

IF DATABASEPROPERTYEX(@CurrentDatabase,'status') = 'ONLINE'

AND NOT (@BackupType = 'LOG' AND DATABASEPROPERTYEX(@CurrentDatabase,'recovery') = 'SIMPLE')

BEGIN

END

So only databases that are Online...

You need to test your applications carefully after you have changed the compatibility level. There could be things that works in one compatibility level and not in another. If you...

One thing could be to check the compatibility level of your databases. Databases in compatibility level 70 are not displayed in the Maintenance Plans.

http://msdn.microsoft.com/en-us/library/ms189647.aspx

Ola Hallengren

http://ola.hallengren.com

Thanks, Jamie. I understand.

Now I was thinking more of publishing a SQLCMD file on a website and be sure that all people will open it in SQLCMD mode in Management...