Posted by Rico on 04/24/07 17:32

Hi Robert,

Thanks, but I should have mentioned that I'm using SQL 2000 and I'm not
using T-SQL, just trying to create the Maintenance plan from the Enterprise
Manager.

Rick

"Robert Klemme" <shortcutter@googlemail.com> wrote in message
news:596ghdF2jtij6U1@mid.individual.net...
> 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

[Back to original message]