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 |
|
tafadzwa
Starting Member
18 Posts |
 Posted - 2008-06-02 : 04:12:59
|
| Hi Guys!I am trying to create a 'scheduled back up database task'maintenance plan which has an option to 'overwrite backups' but with also the "Create a backup file for every database" option checked. Does anyone know how to do this?Thanks Guys. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-02 : 08:27:23
|
| Yes you can do it .Have you ever tried? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-02 : 22:49:58
|
| Create maintenance plan with wizard, there are those options in backup page. |
|
|
|
tafadzwa
Starting Member
18 Posts |
Posted - 2008-06-03 : 02:23:57
|
| Hi Guys,I tried all that, the problem i am facing is that the moment that i have the "Create a backup file for every database" option checked, the option to overwrite becomes greyed out (unavailable). The option to overwrite is only available when i have the "Backup Database across one or more files" option checked which is not what i want.Thanks guys! |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-03 : 10:04:52
|
| you can't have both option in Maintenance plan.You can delete older backups like older than 1 day. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-03 : 15:56:18
|
| Sql will create backup file everyday with timestamp in file name in your case. |
|
|
|
tafadzwa
Starting Member
18 Posts |
Posted - 2008-06-04 : 05:07:27
|
| Thanks Guys! |
|
|
|
|
|
|
Maintanence Plan - Backup Database Task