It seems like it's working fine for me.

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

-- Login: abcbatch

CREATE LOGIN [abcbatch] WITH PASSWORD = 0x0100426FF48BA5C8A93F45E51C4AA866286B2B010A0F9735D846 HASHED, SID = 0x125002F102F0184ABDA7E8CA604588D3, DEFAULT_DATABASE = [EDM], CHECK_POLICY = OFF, CHECK_EXPIRATION = OFF

Ola Hallengren

http://ola.hallengren.com

Are you getting anything in the error log?

Default the Login auditing is set to 'Failed logins only'. This means that you should be able to see all failed login and...

I have done a trace on this. I have a Maintenance Plans that is doing a full backup of all user databases. I'm on version 9.00.3054.00. This is what is...

If you drop a database it is captured in the default trace.

Look in the trc - files that are located in the same directory as the error logs.

Ola Hallengren

http://ola.hallengren.com

You could also use the extended stored procedure xp_dirtree.

EXECUTE xp_dirtree 'C:\Backup', 1, 1

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1270919,00.html

The disadvantage is that it's undocumented. The advantage is that you don't have to enable xp_cmdshell.

Ola Hallengren

http://ola.hallengren.com

I think that you should use the dymanic management view sys.dm_db_index_physical_stats instead of DBCC SHOWCONTIG.

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

DBCC SHOWCONTIG will be removed in a future version of SQL Server.

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

I have a stored procedure...

Thanks, Private Gripweed. Just send me an e-mail and I'll help you to get started. It's very easy.

http://ola.hallengren.com/About.html

Ola Hallengren

http://ola.hallengren.com

Microsoft has as whitepaper on this.

"Generally, you should not be concerned with fragmentation levels of indexes with less than 1,000 pages. In the tests, indexes containing more than 10,000 pages...

You also need something to create the folders. I'm using xp_create_subdir in my stored procedure. It's undocumented, but it's the one that the Maintenance Plans are using.

Ola Hallengren

http://ola.hallengren.com

I think that I have a solution that can do this for you. It's a backup stored procedure that supports exclusion of databases as well as creation of subdirectories.

EXECUTE dbo.DatabaseBackup...

In SQL Server 2005 you can also see the page_count in the dynamic management view

sys.dm_db_index_physical_stats.

I have a stored procedure that is using sys.dm_db_index_physical_stats to dynamically rebuild / reorganize your indexes.

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

Ola...

I think that you should do full backups of all user and system databases to .bak files (using my or some others script). You should also have something that copies...

I have a solution for this that you are welcome to use.

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

sqlcmd -E -S .\SQLEXPRESS -d master -Q "EXECUTE [dbo].[DatabaseBackup] @databases = 'SYSTEM_DATABASES,USER_DATABASES', @Directory = 'C:\Backup', @BackupType...

Microsoft has as whitepaper on this.

"Generally, you should not be concerned with fragmentation levels of indexes with less than 1,000 pages. In the tests, indexes containing more than 10,000 pages...

>2. If you rebuild/reorganize the index, should that be done before or after the full db backup? Or does it not matter (i.e., is it indepedent of the db backup...