Backup Script - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

Backup Script

Author

Topic

Noonien
Starting Member

2 Posts

Posted - 2013-04-08 : 03:22:37

Hello !
Hope this is the right forum.
I am doing a backup job on my sql server that looks that way:

BESMgmt:
BACKUP DATABASE [BESMgmt] TO DISK = N'D:\SQLBackup\BESMgmt\BESMgmt Backup' WITH NOFORMAT, NOINIT, NAME = N'BESMgmt-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

BMSStore:
BACKUP DATABASE [BMSStore] TO DISK = N'D:\SQLBackup\BMSStore\BMSStore Backup' WITH NOFORMAT, NOINIT, NAME = N'BMSStore-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

Master:
BACKUP DATABASE [master] TO DISK = N'D:\SQLBackup\master\master Backup' WITH NOFORMAT, NOINIT, NAME = N'master-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

Model:
BACKUP DATABASE [model] TO DISK = N'D:\SQLBackup\model\model Backup' WITH NOFORMAT, NOINIT, NAME = N'model-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO

Works.
My problem: The backup allways writes in the same backup file.
I need every day a new backup file, not allways stored i nthe same file.
In case that i really need to recove rbackup I will take much to long to restore such a big file instead of a dayli backup file, and , I am getting freespace problems on the hdd ...

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-04-08 : 11:23:32

Change NOINIT to INIT