|
Need a script to take a backup for daily of required database and want to delete the two days backup files, after taking the third day backup....
(comments are locked)
|
|
I'd suggest just using the Maintenance Plans. You're requirements are very simple and straight-forward, so you don't need a sophisticated script to take care of them. The Maintenance Plans will do exactly what you need with minimal work.
(comments are locked)
|
|
As Grant mentioned, Maintenance Plans will work just fine, however if you would prefer something codish, I would suggest checking out Ola Hallengren's Maintenance Solution. You can find the URL below. Just another option. Hope this helps! No arguments. Ola's scripts are great. I just find them to be like swatting flies with JDAMs if you don't have fairly sophisticated requirements. Gets the job done, but...
Sep 20 '12 at 12:13 PM
Grant Fritchey ♦♦
Use them myself... but the learning curve can be a little steep for newbies :)
Sep 20 '12 at 12:29 PM
Blackhawk-17
No arguments here. Just was throwing it out there as an option. The OP can decide what is best for their environment/skill level. ;-)
Sep 20 '12 at 12:54 PM
JohnM
That one is great but i'm poor on segrigating the script... Can anyone please post a exact script for taking the backups...
Sep 20 '12 at 03:52 PM
narendba
For those that dont know (like me) - JDAM == http://en.wikipedia.org/wiki/Joint_Direct_Attack_Munition
Sep 22 '12 at 03:22 PM
Fatherjack ♦♦
(comments are locked)
|
|
Maintenance plans are good & easy to start with they are actually SSIS package, you have the right tools there to do stuffs like backup, notification, older File delete and the list goes. Also, it alllows you to generate the scripts for the plans you created.... But again scripts provides you greater flexibility, but should be error free. :-)
(comments are locked)
|
