Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jheds
Starting Member
17 Posts |
 Posted - 2007-01-12 : 04:03:49
|
| Hi friends, I am backing up the database using the Database Maintenance Plan. Everything is in place. I want to save the file name in the format yyyy-mm-dd_finbck.bak. how can i assign the date from here itself ? this should be done through the DB maintenance plan only. is it possible ? can we assign the date to the backup file through the DB maintenence plan ? kindly guide.Regards,Amit |
|
|
mightypenny_ph
Yak Posting Veteran
54 Posts |
Posted - 2007-01-12 : 04:09:21
|
| are you using SQL Server 2005??? the database maintenance plan (provided by SQL) automatically assigns a date and etc to database backup files names.SlayerS_`BoxeR` + [ReD]NaDa |
 |
|
|
Jheds
Starting Member
17 Posts |
Posted - 2007-01-12 : 04:20:19
|
| im sorry for not mentioning that.we are working on sql server 2000. windows 2003 server.i havent exactly understood what u have said.kindly spare a few moments and guide in detail.regards,Jheds |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-01-12 : 04:24:59
|
| "SQL2005 database maintenance plan automatically assigns a date and etc to database backup files names"SQL 2000 too if I'm not mistaken."i havent exactly understood what u have said."Maintenance Wizard will create "unique" filenames for backups by including the date and time in the filename.Kristen |
|
|
|
Jheds
Starting Member
17 Posts |
Posted - 2007-01-12 : 07:02:16
|
thanks kirsten and friends...Regards,jheds |
|
|
|
|
|
|
Backup Related