If you for some reason can not implement the Microsoft hotfix, I have a Maintenance Plan - like stored procedure that you could use to check the integrity of your...

I think that you need this hotfix.

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

Ola Hallengren

http://ola.hallengren.com

I have a stored procedure that could help you with this. It is using the DMV

sys.dm_db_index_physical_stats to dynamically rebuild / reorganize indexes based on the fragmentation levels. It could...

My theory is that if you pregrow your data and log files and never do any shrinking, then maybe you don't need DiskKeeper.

Ola Hallengren

http://ola.hallengren.com

I'm thinking about if file level fragmentation really is a problem on sql server data and log files if you grow your files in large chunks and if you do...

>Which I think is the safest way to go... you should have a validated backup before you remove the old one.

If you have more than one large database it is...

I have a backup stored procedure as well, that you are welcome to use.

EXECUTE dbo.DatabaseBackup @databases = 'USER_DATABASES', @Directory = 'C:\Backup', @BackupType = 'FULL', @verify =...

I would not do a configuration like this. I think that it will make things less robust.

1. Consider a short network outage, planned or unplanned. Then all your maintenance job...

Paul Randal has a good blog post about this.

http://blogs.msdn.com/sqlserverstorageengine/archive/2007/06/07/what-happens-to-non-clustered-indexes-when-the-table-structure-is-changed.aspx

About the index optimization stored procedure it outputs things like this to the output file.

DateTime: 2008-03-05 21:58:59

Command: ALTER INDEX [IX_Address_StateProvinceID] ON

[AdventureWorks].[Person].[Address] REORGANIZE

Comment:...

I have a set of Maintenance Plan - like stored procedures that you are welcome to use. They have features for backup, integrity check, index rebuild, index reorganize and update...

Ken Hendersen has a blog post about this.

"If you think about it, it makes perfect sense—the clustered keys, which are the record locators in the NC indexes, aren’t changed merely...

>I am not sure but i think rebuilding clustered index will not rebuild non-clustered automatically..

You're right on this. Please see Books Online.

"Rebuilding a clustered index does not rebuild associated...

I think that we need to do this test again. I would like to analyze the _lsn columns in the backupset table in msdb and also do some restore tests....

I have a stored procedure that could help you with this. It is using the DMV

sys.dm_db_index_physical_stats to dynamically rebuild / reorganize indexes based on the fragmentation levels.

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

Regarding 3) about...

I tried to figure out how this works some time ago. Here are some tests that I did. It seems like log backups can complete while the database backup is...