View Complete Post
i've created a job to schedule backup everyday, here the script used:
BACKUP DATABASE [ON_KEY_4] TO DISK = N'D:\BACKUP\E-DRV\Backups Archive\ON_KEY_4_Backup' WITH NOFORMAT, NOINIT,
NAME = N'ON_KEY_4-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
this back up is too big about 120g but when i do manual backup the database is only 3g. i think the DB is not being overwritten but back up on top of each one.
how can i make to overwrite each time the script is executes.
thanks in advance