advanced backup

[ProBani]

Hi everybody,

how is possible to backup database on different files by date, I mean to be created everyday on scheduled basis bak files by date - bckpmydb08052005.bak;bckpmydb08062005.bak ... I mean not to be appended or overwrited, but each file everyday (everyday toi be created ne file).

Thanks,
ProBani.

 

[qsac]

Enterprise Manager --> Management --> Right Click Database Maintenance Plan

New Maintenance Plan.

If you follow the wizard, you should get the desired results.



Q

 

[mrdenny]

You can also do this by hand by dynamically generating the backup file name.

declare @filename varchar(100)
set @filename = 'c:\mydatabase_' + convert(varchar(4), year(getdate())) + convert(varchar(2), month(getdate())) + convert(varchar(2), day(getdate())) + '.bak'
backup database MyDatabase to disk=@filename

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[ProBani]

Thanks, Denny.