Posted by Rico on 04/24/07 13:29

Hello,

I'm trying to create a simple back up in the SQL Maintenance Plan that will
make a single back up copy of all database every night at 10 pm. I'd like
the previous nights file to be overwritten, so there will be only a single
back up file for each database (tape back up runs every night, so each days
back up will be saved on tape).

Every night the maintenance plan makes a back up of all the databases to a
new file with a datetime stamp, meaning the previous nights file still
exists. Even when I check "Remove files older than 22 hours" the previous
nights file still exists. Is there any way to create a back up file without
the date time stamp so it overwrites the previous nights file?

Thanks!
Rick

• Next in forum: Re: Having difficulty setting Back Up to back up file wihout datetime stamp SQL 2K
• Prev in forum: Re: READ UNCOMMITTED data
• Thread view: Having difficulty setting Back Up to back up file wihout datetime stamp SQL 2K

[Reply to this message]