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 |
|
Dev@nlkss
134 Posts |
 Posted - 2008-12-10 : 04:09:10
|
| Hi All,I created an sql job which performs daily backup of my production db runs everyday morning and stores it in a folder.The problem is newly taken backup file is overwriting the old one.how can i create new backup file with timestamp extension which differs from old one.Plz help me ASAP.Thanks in advance.Regards,SatyaSatya |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-12-10 : 04:14:03
|
| Use Maintenance Plans to create backup jobs, and set how long to keep old files. |
 |
|
|
Dev@nlkss
134 Posts |
Posted - 2008-12-10 : 23:26:51
|
| I have created as part of maitanance plan using script but its created only single file and overwriting for new job execution schedule.can anybody help on this.plz save my time thanQ.Satya |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-12-11 : 04:31:34
|
| Edit Maintenance plan in designer:History Cleanup Task - option to remove historical files older than (set this) |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-11 : 09:08:33
|
quote:
Originally posted by darkdusky
Edit Maintenance plan in designer:History Cleanup Task - option to remove historical files older than (set this)
Not History Cleanup task. Its Maintenance cleanup task. |
|
|
|
Dev@nlkss
134 Posts |
Posted - 2008-12-11 : 22:50:55
|
| If you dont mind plz tell me the navigation pathbcoz i am new to DBA concepts strucked up with this.Thanks in advanceSatya |
|
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-12-12 : 06:40:16
|
| Management\Maintenance Plans. Either edit current or create new. |
|
|
|
|
|
|
SQL Job