If true for SQL Server 2008\R2\Denali - 524272.

This mean maybe max size of log file 16 TB

32,767*16 TB=524272

for SQL Server 2005:

Files per database : 32767 = 32766 data file + 1 log file

Max Database Size = 32766*16 TB + 1*2 TB = 524258 terabytes

My backup script is success on Mirrored databases(tested on principial database server).

What is your error?

Short way Backups of All User Databases with sp_msforeachdb undocumented sp.

Short Way for SQL Server 2008 and SQL Server 2008 R2:

declare @strSQL varchar(max)

set @strSQL ='';

select @strSQL = @strSQL + ' grant exec on ' + name + ' to...

ALTER DATABASE YourDatabaseName COLLATE SQL_Latin1_General_CP1_CI_AS

Mehmet GÜZEL

www.mehmetguzel.net