MS-SQL7 Datenbank sichern per Batch

Bei uns sieht das ganze folgendermaßen aus. Das Script ist noch von meinem Vorgänger und ich hab mich noch nicht damit auseinandergesetzt aber es funktioniert bis jetz fehlerfrei.

Eine Batch, die folgenden aufruf beinhaltet, wird vom jeweiligen Server ausgeführt:

OSQL -S %MSSQL_SERVER% -E -n -i "\PFAD\Backup_DB.sql" -p -a 8192 > "ZIEL DER LOGDATEI"

Die Backup_DB.sql hat folgenden Inhalt:

CLOSE rs_cursor
deallocate rs_cursor

declare @dbname as varchar(40)
declare @msgdb as varchar(40)
declare @dbbkpname as varchar(60)
declare @dbbkpsetname as varchar(60)
declare @dbfilename as varchar(60)
declare @currdate as varchar(8)
declare @currtime as varchar(8)
DECLARE @hostn as varchar(40)
SELECT @hostn = HOST_NAME()

declare rs_cursor CURSOR for select name from master.dbo.sysdatabases
open rs_cursor
Fetch next from rs_cursor into @dbname
IF @@FETCH_STATUS <> 0 PRINT '<<db>>'

print '----------------------------------------------------------------------'
select @msgdb = 'DB Backup with Format: ' + @dbname
print @msgdb
select @dbbkpname = @dbname + '.dat'
select @currdate = CONVERT(char(12), GETDATE(), 5)
select @currtime = CONVERT(char(12), GETDATE(), 8)
select @dbbkpsetname = 'Full DBBackup of ' + @dbname + ' ' + @currdate + ' ' + @currtime
select @dbfilename = N'\BACKUPPFAD\'+@HOSTN+'\'+@dbname+'_'+@currdate+'.bak'
print 'File Name: ' + @dbbkpname
print 'Label: ' + @dbbkpsetname
backup database @dbname TO DISK = @dbfilename WITH NAME = @dbbkpsetname, NOUNLOAD
Fetch next from rs_cursor into @dbname

WHILE @@FETCH_STATUS = 0
BEGIN
if @dbname <> 'tempdb' BEGIN
print '----------------------------------------------------------------------'
select @msgdb= 'DB Backup with Append: ' + @dbname
print @msgdb
select @dbbkpname = @dbname + '.dat'
select @currdate = CONVERT(char(12), GETDATE(), 5)
select @currtime = CONVERT(char(12), GETDATE(), 8)
select @dbbkpsetname = 'Full DBBackup of ' + @dbname + ' ' + @currdate + ' ' + @currtime
select @dbfilename = N'\BACKUPPFAD\'+@HOSTN+'\'+@dbname+'_'+@currdate+'.bak'
print 'File Name: ' + @dbbkpname
print 'Label: ' + @dbbkpsetname
backup database @dbname TO DISK = @dbfilename WITH NOINIT, NAME = @dbbkpsetname, NOUNLOAD, SKIP
END
FETCH NEXT FROM rs_cursor INTO @dbname
END
print '----------------------------------------------------------------------'
PRINT 'DB tempdb was skipped...'
PRINT 'Backup Job Completed..... ;)'
CLOSE rs_cursor
deallocate rs_cursor
GO

Ich hoffe, das hilft Dir weiter