Scheduled backup in SQL Server 2005 Express

SQL Server 2005 Express does not have any possibilities to schedule backup so
I have made a simple application for scheduling backup, running a stored
procedure in my database.
The procedure backup up to the same backup device so all backup sets are
stored in the same file. RETAINDAYS is set to 365.
In the “Restore Database” dialog in SQL Server 2005 Management Studio
Express I can se all backup sets in the backup file and also the ‘Expiration’
date for each backup set.
I thought that setting option INIT and NOSKIP would overwrite expired backup
sets but instead I get an error message “the medium on device <device>
expires on <date> and cannot be overwritten.
I though that new backup sets would be appended until a backup set expires
but it does not look like that.
Any suggestion on how to preserve backup sets for some days and then
overwrite it?
Help is appreciated.
Regards Kjell Arne Johansen
Hi
What I would do If I were you :-))))) just create .BAK file with GEDDATE()
contacinated , so later on you can delete those files based on file name.
"Kjell Arne Johansen" <KjellArneJohansen@.discussions.microsoft.com> wrote in
message news:6594778E-E17A-4304-AFB1-DFF2D0C8BFD6@.microsoft.com...
> SQL Server 2005 Express does not have any possibilities to schedule backup
> so
> I have made a simple application for scheduling backup, running a stored
> procedure in my database.
> The procedure backup up to the same backup device so all backup sets are
> stored in the same file. RETAINDAYS is set to 365.
> In the Restore Database dialog in SQL Server 2005 Management Studio
> Express I can se all backup sets in the backup file and also the
> Expiration
> date for each backup set.
> I thought that setting option INIT and NOSKIP would overwrite expired
> backup
> sets but instead I get an error message the medium on device <device>
> expires on <date> and cannot be overwritten.
> I though that new backup sets would be appended until a backup set expires
> but it does not look like that.
> Any suggestion on how to preserve backup sets for some days and then
> overwrite it?
> Help is appreciated.
> Regards Kjell Arne Johansen
>
|||Hi
Yes I have an option to create backup with unique filenames also but I want
to know if there is anything I can use in SQL Server to do this for me and if
INIT and NOSKIP or other options can be used.
Kjell Arne
"Uri Dimant" wrote:

> Hi
> What I would do If I were you :-))))) just create .BAK file with GEDDATE()
> contacinated , so later on you can delete those files based on file name.
>
>
> "Kjell Arne Johansen" <KjellArneJohansen@.discussions.microsoft.com> wrote in
> message news:6594778E-E17A-4304-AFB1-DFF2D0C8BFD6@.microsoft.com...
>
>