Thursday, February 16, 2012

Backup

Hello,
Newbie question.
How do I have have a complete backup of a database for one weeks time frame
and the backups append to the file name the date it was backup up? Anything
after a week the oldest backup will be deleted. Thank you.There is nothing in SQL Server that does exactly that for you. You can
accomplish the same thing with a bit of TSQL programming. Just one thing:
you cannot delete parts of a backup file. When you do a backup, it is either
all or nothing (append or overwrite).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"vpont" <anonymous@.discussions.microsoft.com> wrote in message
news:B4A8313C-1472-400D-BCD2-4EA7C4DEC18B@.microsoft.com...
> Hello,
> Newbie question.
> How do I have have a complete backup of a database for one weeks time
frame and the backups append to the file name the date it was backup up?
Anything after a week the oldest backup will be deleted. Thank you.

No comments:

Post a Comment