Posted by David Gray on 04/10/07 13:33

Hi,

SQL Server 2005 Standard (X64) edition.

Have a database which has its log backed up every hour during the
normal business day and each evening a full backup is performed.

After two days we would like the the log backups to be automatically
overwritten in the backup device [WebAdmin], is this possible?

This is the command being used.

BACKUP LOG [WebAdmin] TO [WebAdmin]
WITH RETAINDAYS = 2,
NOFORMAT,
NOINIT,
NAME = N'WebAdmin',
SKIP,
NOREWIND,
NOUNLOAD



Currently the backup device has log backups going back to 18/02/2007
which is position number 1 in the device. Basically nothing is being
overwritten.

Thanks in advance.
Dave

• Next in forum: Retrieve ALL tables from ALL Databases
• Prev in forum: SQL Server Performance
• Thread view: Retain/expiration inside a backup device.

[Reply to this message]