Litespeed question

Hi,
We are using litespeed(version 4.8) to backup databases on SQL Server
2005(SP2 database) but everytime few databases are left out although drive
has enough free space and also it doesnot generate any error
Script for the same is:
EXEC sp_MSforeachdb 'IF ''?'' NOT IN (''tempdb'')
exec master.dbo.xp_backup_database
@.database = ''?'',
@.filename = ''Backupdrivepath\FULL_?.BKP'',
@.backupname = ''FULL ? backup'',
@.desc = ''FULL Backup of ?'', @.init = 1, @.logging = 0,
@.compressionlevel = 5, @.comment = '''', @.with = ''SKIP'',
@.with = ''STATS = 10'' '
Please help me.
ThanksHi Manu,
If you are backing up to Tape drive or network storage then see if there is
any issue with netowrk connectivity Also look at SQL server logs to determine
all databases have been selected for backup.
"manu" wrote:
> Hi,
> We are using litespeed(version 4.8) to backup databases on SQL Server
> 2005(SP2 database) but everytime few databases are left out although drive
> has enough free space and also it doesnot generate any error
> Script for the same is:
> EXEC sp_MSforeachdb 'IF ''?'' NOT IN (''tempdb'')
> exec master.dbo.xp_backup_database
> @.database = ''?'',
> @.filename = ''Backupdrivepath\FULL_?.BKP'',
> @.backupname = ''FULL ? backup'',
> @.desc = ''FULL Backup of ?'', @.init = 1, @.logging = 0,
> @.compressionlevel = 5, @.comment = '''', @.with = ''SKIP'',
> @.with = ''STATS = 10'' '
>
> Please help me.
> Thanks
>