autobackupsys

DECLARE @pfad varchar(512);SET @pfad = 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\'

DECLARE @date varchar(64);SET @date = REPLACE(CONVERT(varchar, GETDATE(), 120), ':', '.')
DECLARE @datei varchar(512);DECLARE @name varchar(128)
SET @datei = @pfad + N'ACCOUNT_DBF ' + @date + N'.bak'
SET @name = N'ACCOUNT_DBF ' + @date
BACKUP DATABASE [ACCOUNT_DBF] TO DISK = @datei WITH NOFORMAT, NOINIT, NAME = @name, SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

DECLARE @pfad varchar(512);SET @pfad = 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\'

DECLARE @date varchar(64);SET @date = REPLACE(CONVERT(varchar, GETDATE(), 120), ':', '.')
DECLARE @datei varchar(512);DECLARE @name varchar(128)
SET @datei = @pfad + N'CHARACTER_01_DBF ' + @date + N'.bak'
SET @name = N'CHARACTER_01_DBF ' + @date
BACKUP DATABASE [CHARACTER_01_DBF] TO DISK = @datei WITH NOFORMAT, NOINIT, NAME = @name, SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

--DECLARE @pfad varchar(512);SET @pfad = 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\'
--
--DECLARE @date varchar(64);SET @date = REPLACE(CONVERT(varchar, GETDATE(), 120), ':', '.')
--DECLARE @datei varchar(512);DECLARE @name varchar(128)
--SET @datei = @pfad + N'LOGGING_01_DBF ' + @date + N'.bak'
--SET @name = N'LOGGING_01_DBF ' + @date
--BACKUP DATABASE [LOGGING_01_DBF] TO DISK = @datei WITH NOFORMAT, NOINIT, NAME = @name, SKIP, NOREWIND, NOUNLOAD, STATS = 10
--GO

--DECLARE @pfad varchar(512);SET @pfad = 'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\'
--
--DECLARE @date varchar(64);SET @date = REPLACE(CONVERT(varchar, GETDATE(), 120), ':', '.')
--DECLARE @datei varchar(512);DECLARE @name varchar(128)
--SET @datei = @pfad + N'RANKING_DBF ' + @date + N'.bak'
--SET @name = N'RANKING_DBF ' + @date
--BACKUP DATABASE [RANKING_DBF] TO DISK = @datei WITH NOFORMAT, NOINIT, NAME = @name, SKIP, NOREWIND, NOUNLOAD, STATS = 10
--GO