Full backup to a different file name

I may be missing something here but is it possible to do a full database
backup each night but to a different file name so as not to overwrite the
existing full backup. The database is relatively small (200Meg) and we have
lots of hard drive space available. Of course we will need to manually
delete the old backups occasionally but we are happy to do that.
I know that I can do either a differential backup or a transaction log
backup but this will make the restoration process slower. Often we just
want to quickly restore a a database fron two days ago just to check we did
not screw something up.
Should I be looking towards 3rd party software?
Dave A
Dave
You can call a backup whatever you like. So yes you can call it what you
like. One of the easiest ways to do it, is to give it a base name and add the
date to it. This creates a file something like mydatabase_ddmmyy.bak (or
mydatabase_mmddyy.bak for our American friends)
Hope this helps
John
"Dave A" wrote:

> I may be missing something here but is it possible to do a full database
> backup each night but to a different file name so as not to overwrite the
> existing full backup. The database is relatively small (200Meg) and we have
> lots of hard drive space available. Of course we will need to manually
> delete the old backups occasionally but we are happy to do that.
> I know that I can do either a differential backup or a transaction log
> backup but this will make the restoration process slower. Often we just
> want to quickly restore a a database fron two days ago just to check we did
> not screw something up.
> Should I be looking towards 3rd party software?
> Dave A
>
>
|||John,
I want to schedule the backup to run everynight automatically. I don't want
to retype the name in each time. Sorry, I should have been more clear.
Regards
Dave A
"John Bandettini" <JohnBandettini@.discussions.microsoft.com> wrote in
message news:BC4DD730-7D65-4866-9652-8AD7D61EB44F@.microsoft.com...
> Dave
> You can call a backup whatever you like. So yes you can call it what you
> like. One of the easiest ways to do it, is to give it a base name and add
the[vbcol=seagreen]
> date to it. This creates a file something like mydatabase_ddmmyy.bak (or
> mydatabase_mmddyy.bak for our American friends)
> Hope this helps
> John
> "Dave A" wrote:
the[vbcol=seagreen]
have[vbcol=seagreen]
did[vbcol=seagreen]
|||The easiest way to do this is to set up a Maintenance Plan ... The
maintenance plan wizard will create a unique name with the date and time
automatically..
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Dave A" <dave@.sigmasolutionsdonotspamme.com.au> wrote in message
news:OuF4BYgAFHA.1404@.TK2MSFTNGP11.phx.gbl...
> I may be missing something here but is it possible to do a full database
> backup each night but to a different file name so as not to overwrite the
> existing full backup. The database is relatively small (200Meg) and we
have
> lots of hard drive space available. Of course we will need to manually
> delete the old backups occasionally but we are happy to do that.
> I know that I can do either a differential backup or a transaction log
> backup but this will make the restoration process slower. Often we just
> want to quickly restore a a database fron two days ago just to check we
did
> not screw something up.
> Should I be looking towards 3rd party software?
> Dave A
>
>
|||"John Bandettini" <JohnBandettini@.discussions.microsoft.com> wrote in
message news:BC4DD730-7D65-4866-9652-8AD7D61EB44F@.microsoft.com...
> Dave
> You can call a backup whatever you like. So yes you can call it what you
> like. One of the easiest ways to do it, is to give it a base name and add
the
> date to it. This creates a file something like mydatabase_ddmmyy.bak (or
> mydatabase_mmddyy.bak for our American friends)
You can use a maintenance job that handles this or roll your own code.
And here in America I prefer YYYYMMDD :-)
Just use datepart to assemble the file name.
[vbcol=seagreen]
> Hope this helps
> John
> "Dave A" wrote:
the[vbcol=seagreen]
have[vbcol=seagreen]
did[vbcol=seagreen]