When you are using the database name in the directory name and in the file name in a script, there are some things to think about.

One thing is that there...

One way of handling this is to check sys.indexes.allow_page_locks in the index maintenance script. If page locking is disabled for an index (allow_page_locks = 0), the script can then do...

I have looked at the code. It is this code that is setting the directory structure.

INSERT INTO @CurrentDirectories (ID, DirectoryPath, CreateCompleted, CleanupCompleted)

...

It looks like the table is locked and that the index rebuild command therefore is blocked. You have to find out what is blocking the index rebuild command.

Ola Hallengren

http://ola.hallengren.com

There is a job, [Output File Cleanup], that is taking care of that. It is created by http://ola.hallengren.com/scripts/MaintenanceSolution.sql.

Ola Hallengren

http://ola.hallengren.com

This looks like my index maintenance stored procedure.

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

Could you check if you have output - files configured in the job?

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

Ola Hallengren

http://ola.hallengren.com

My maintenance solution has support for excluding databases.

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

Ola Hallengren

http://ola.hallengren.com

If you have used the script http://ola.hallengren.com/scripts/MaintenanceSolution.sql it will create output - files in the SQL Server error log directory.

Please also see this getting started guide.

http://ola.hallengren.com/sql-server-integrity-check.html

Ola Hallengren

http://ola.hallengren.com

>As for "His maint is also set up to do checkdb against the entire db or just the pieces that have changed."

The integrity check stored procedure does not have any...

DatabaseBackup (the ola.hallengren.com backup stored procedure) has an option for this (@ChangeBackupType = 'Y') that I recommend you to use.

It will then check if a backup can be made, before...

If you're interested in using my solution I recommend that you download the script MaintenanceSolution.sql. The script contains all the objects that you need and also a set of jobs.

http://ola.hallengren.com/scripts/MaintenanceSolution.sql

Ola...

You might also want to try out the option @ChangeBackupType = 'Y'. Then the log backup job will see that there is a new database and perform a full backup...

Some input on this. The advantage with backing up to new files with date and time in the file name and the way DatabaseBackup works, is that you're guaranteed to...

I have a parameter for backup striping in my script.

EXECUTE dbo.DatabaseBackup @databases = 'AdventureWorks',

@Directory = 'C:\Backup',

@BackupType = 'FULL',

@NumberOfFiles = 4

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

Ola Hallengren

http://ola.hallengren.com

I was experiencing downtime on my website yesterday, but it's working again now. I'm sorry for the inconvenience.

The script was first published on SQL Server Central 23 Feb 2008.

Ola Hallengren

http://ola.hallengren.com