6 reputation
2
bio website
location
age
visits member for 1 year, 7 months
seen Apr 8 '13 at 8:17

Oct
20
awarded  Popular Question
Apr
8
comment Automated SQL backup on a timely fashion, & cleaup the database for the backed up data
Regarding point 1) Thank you for the information. I was after more flexibility. I will definitely utilize your script, and see what other keywords I can use. As for point 2) do you what the maximum value can be, instead of 24? For example can it be equivalent to several weeks or months' time?
Apr
8
comment Automated SQL backup on a timely fashion, & cleaup the database for the backed up data
Thank you for the offer. I have already seen the product, and its screenshots, but am not sure as to what it can offer in comparison to what one can acheive using scripts, only. Please enlighten me!
Apr
5
comment Automated SQL backup on a timely fashion, & cleaup the database for the backed up data
I like the UNC option. Thank you. As for the O/S, I have tried really hard. The answer I've got has been "deal with it", I am afraid. As for the edition, it is not a developer edition, and as you suggested that would be in violation of licence agreement if it were the case. The edition I am using is only meant to be for the purpose of historian, and one must not use it for any other purpose. Thank you for the reminder, anyways. Please provide any other suggestions you may have.
Apr
5
comment Automated SQL backup on a timely fashion, & cleaup the database for the backed up data
Thank you for your kind response. I have considered the Maintenance solution, but have not invested enough time to explore all the options, yet. With regards to the script you have provided, it looks great, but there are several points I will bring to your attention: 1) I do not intend to do Full backup. The backup is meant to capture say, the last two weeks (a configuratble parameter), whereas the database may contain 3 months' worth of data. 2) How reliable is the clean up method? Have you used it extensively? By the way, I am not using R2, just 2008. I look forward to your response.
Apr
2
awarded  Student
Apr
2
asked Automated SQL backup on a timely fashion, & cleaup the database for the backed up data