Wie von Db Backups erstellen?

USE master;
ALTER DATABASE ACCOUNT_DBF SET RECOVERY FULL;
GO
-- Back up the ACCOUNT_DBF database to new media set (backup set 1).
BACKUP DATABASE ACCOUNT_DBF
TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\ACCOUNT _DBF.bak'
WITH FORMAT;
GO

USE master;
ALTER DATABASE CHARACTER_01_DBF SET RECOVERY FULL;
GO
-- Back up the CHARACTER_01_DBF database to new media set (backup set 1).
BACKUP DATABASE CHARACTER_01_DBF
TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\CHARACT ER_01_DBF.bak'
WITH FORMAT;
GO


USE master;
ALTER DATABASE LOGGING_01_DBF SET RECOVERY FULL;
GO
-- Back up the LOGGING_01_DBF database to new media set (backup set 1).
BACKUP DATABASE LOGGING_01_DBF
TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\LOGGING _01_DBF.bak'
WITH FORMAT;
GO


USE master;
ALTER DATABASE RANKING_DBF SET RECOVERY FULL;
GO
-- Back up the RANKING_DBF database to new media set (backup set 1).
BACKUP DATABASE RANKING_DBF
TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\RANKING _DBF.bak'
WITH FORMAT;
GO