WinSvr 2008 Backup script

We have Windows Server 2008 Foundation Class.  There is a SQL database that has a batch file that will update a backup copy of the database to a different drive (let's say D drive).  There is also a folder on D which has some .DAT and .IDX files that I wish to back.  I am currently backing up all the data to two externals.  But I want to take it to a new level with a daily backup to take off site.  (Please no cloud suggestions).

What I would like to do is to copy the important stuff to a DVD that will be removed every night or every morning.  So my thought is some type of script.  It will need to copy the SQL backup file and the folder on D drive to a folder and then burn this folder to a DVD every night (or every evening when if the script is manually executed).  We don't have any special software other than what comes with the server.  

I realize this may seem like a simplistic backup scheme, but I only need this currently until the end of this tax season (April 15).

I now open the floor to ideas...

thanks in advance.
jjackson2004Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

it_saigeDeveloperCommented:
No script needed, you can use WBADMIN (Windows Server Backup).  I'm not certain if there is an interface in Windows Server 2008 Foundation, but you just install the Windows Server Backup Features and look in Administrative Tools to see if there is a Control Panel applet for it:
Open server manager, select 'Features' and click 'Add Features'.  Locate and select 'Windows Server Backup Features'.Once the install is completed, you can access Windows Server Backup here.
With Windows Server Backup, you can perform a full backup of the server.

https://social.technet.microsoft.com/Forums/windowsserver/en-US/e1cbcafd-5a84-4592-be91-3770b68a0086/how-to-take-incremental-backup-and-backup-on-cddvd-of-system-using-wbadminexe?forum=windowsbackup

-saige-
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Lionel MMSmall Business IT ConsultantCommented:
A DVD only has a 4.7GB capacity and even if you had a dual layer DVD that is till only about 9GB so are you saying the files you want to put onto a DVD each night is less than 4.7GB in size?
0
jjackson2004Author Commented:
Yes, the absolute must keep files that I need will fit on a DVD, which is why I was pursuing that route.  DVDs are cheap and will give easy off site, archived copies until April 15.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

jjackson2004Author Commented:
Apparently my reply yesterday did not get posted (thanks noscript).

I already use WBadmin.  I installed it so I could get a full metal backup of the server.  Daily, I do incremental backups using syncback.  But I would like this extra step to give the additional protection of the core data files being backed up daily off site and also to have archived copies.

WBADmin might be feasible for this, do you know if it will run a batch file (the one to backup the SQL database) prior to the backup, and will it backup to DVDs?
0
jjackson2004Author Commented:
Ok, ignore last question's part about the DVD, I just went and looked at the article you forwarded.
0
jjackson2004Author Commented:
The article did not seem to cover what I needed, but it did give a couple of ideas, but I do not with to do incremental copies, I wish to do full copies of the specified files.
0
it_saigeDeveloperCommented:
You can definitely do full backups of the individual files from a batch or script using WBAdmin.

-saige-
0
Lionel MMSmall Business IT ConsultantCommented:
wbadmin start backup –backupTarget:d: -include:g:\folder1
Did not Test this--here d: is your DVD drive and g:\folder1 is a folder you create or exists that has the files you want backed up to the DVD. See this link for other examples https://technet.microsoft.com/en-us/library/cc742083.aspx
0
jjackson2004Author Commented:
The script I want it to run is the SQL backup.  Also, I would be backing up from several locations, but I would assume I could set up a backup set to point to the folders/files I wish to backup.  And then can I not refer to the backup set with the command line?  I would prefer not to have to copy the different files to a single folder if I did not have to.
0
jjackson2004Author Commented:
Looking at the technet article, it does not appear I can backup the SQL backup file in it's current configuration as it is at the root of D:,  so I guess a little reconfig is in order.
0
it_saigeDeveloperCommented:
You can specify as many targets as you want (I believe that the -include flag uses a comma-delimited list).

Yes it is a comma-delimited list:
For Windows°Vista and Windows Server 2008, specifies the comma-delimited list of volume drive letters, volume mount points, or GUID-based volume names to include in the backup. This parameter should be used only when the -backupTarget parameter is used.

For Windows°7 and Windows Server 2008 R2 and later, specifies the comma-delimited list of items to include in the backup. You can include multiple files, folders, or volumes. Volume paths can be specified using volume drive letters, volume mount points, or GUID-based volume names. If you use a GUID-based volume name, it should be terminated with a backslash (\). You can use the wildcard character (*) in the file name when specifying a path to a file. Should be used only when the -backupTarget parameter is used.
Source

-saige-
0
Lionel MMSmall Business IT ConsultantCommented:
as I indicated you can change the drive letter to be whatever it needs to be; also as indicated the "-include" is what you want to have backed up. In the link I sent you the example listed there shows you how to include more than one file or folder -- copying it here for your convenience
 wbadmin start backup –backupTarget:d: -include:g:\folder1,h:\folder2
0
jjackson2004Author Commented:
Still working on this, so it will be a little while before I have my next response.  Thanks to all for the suggestions so far, though I would still like to see some script if possible.
0
Lionel MMSmall Business IT ConsultantCommented:
what I gave you is a script -- you can put this in a batch file and run the batch file
 wbadmin start backup –backupTarget:d: -include:g:\folder1,h:\folder2
0
jjackson2004Author Commented:
My apologies for being vague, I meant a script that does not use wbadmin, rather collects the files and then calls dvd burn function.
0
Lionel MMSmall Business IT ConsultantCommented:
I don't know of anyway of doing this with native windows -- you have to install some CD/DVD software that allows for command line arguments -- these are some CreateCD, cdrdao, cdrtools, CDBurnerXP, ImgBurn. I have imgburn and it is free and works great from the GUI, never used it from the command line but it has many options--see picture
ee-img-burn-options.jpg
0
jjackson2004Author Commented:
I guess this is all I am going to get, and the system is bugging me to close this question, so I guess I will go ahead and close it.

Thanks for all the suggestions.
0
Lionel MMSmall Business IT ConsultantCommented:
You asked for a script then you award the points to a non-script answer; I then also give you scrip solution to make a DVD on the fly and you simply ignore it. I was the one who gave you a script answer, one that will work http://www.experts-exchange.com/Software/Backup_Restore/Q_28627776.html#a40645066. In one of your comments later you say " I meant a script that does not use wbadmin that does not include" yet you award the point to instructions that tel you how to use the GUI for wbadmin so how come you give points to using the windows interface -- that is the furthest from a script? And why did you not try my DVD recommendation after you said you do not want a wbadmin solution. I usually don't dispute points awarded but in this case it makes no sense at all what you have done based on your comments--thank you
0
jjackson2004Author Commented:
I am not quite sure where this is coming from.  I am quite appreciative of your answers, I even awarded points to the final answer.
I try to give some points to those who take the time to answer my questions and the other person did put in some time with several answers.  No one answered the original question about a script, but did give me answers that let me know that I would use WBAdmin to backup to a DVD, which I was not aware of.  I was already aware that I could call WBAdmin  from command line and also knew that I could write my own batch file to copy the files and then call WBAdmin.

I did not receive a non-script answer until after I requested it again.

I may be naive in my points awarding.  From past experiences it would seem the points system is not indicative of the solutions (some would expect 500 points for a two line answer).  So I apologize if I offended you and your answers towards the end of this discussions were certainly helpful.  I originally was going to split the points but as I went through the answers I would up giving an additional 50 points to the other.  Again, I apologize, you did give me the most effort towards a script answer and in hind sight you should have received the higher reward.
0
Lionel MMSmall Business IT ConsultantCommented:
This is not so much about points as it what you asked for and what you awarded. You gave 250 point to http://www.experts-exchange.com/Software/Backup_Restore/Q_28627776.html#a40642130 as a answer to a request for a script? That has nothing to do with a script but about how to use windows backup from the Windows Interface, Later you said you did want to use windows backup so why is that your accepted answer when you said you did not want a solution using windows backup? Makes no sense that is what I am questioning not so much the points although that does indicate what you consider a solution to what you asked and it just cannot be based on what you question and your comments.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Storage Software

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.