Posted by Robert Klemme on 04/24/07 13:55

On 24.04.2007 15:29, Rico wrote:
> 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?

Yes, I believe option is "WITH INIT". Please see BOL for details.

Regards

robert

• Next in forum: Trigger: To fill another Database with using Stored Procedures of the other Database
• Prev in forum: Having difficulty setting Back Up to back up file wihout datetime stamp SQL 2K
• Thread view: Re: Having difficulty setting Back Up to back up file wihout datetime stamp SQL 2K

[Reply to this message]