Backing up wizbin

[BigSwifty]

I've looked in the historical documents but haven't convinced myself what the best automated process is for backing up important Sage files. I've seen scripts to run but the main question I have is does the sage service need to be stopped to copy the wizbin and ensure the copy is not corrupt.

I image my machine often but am still looking for a reliable way to copy the wizbin db.

Current thoughts?

[tmiranda]

You should make sure Sage is stopped before backing up the wiz.bin.

[BigSwifty]

Thank you. That's what I thought.

I'm not a coder.

I'm writing a bat file and have come up with this:

net stop SageTVservice
timeout /t 30 /nobreak
xcopy "C:\Users\evan\desktop\cows.doc" "E:\abkp\%date:/=_%_cows.doc"
net start SageTVservice

I believe it works. Note that I'll change the paths to the appropriate Sage directory. Now, I'd like to add a command to only keep perhaps a week's worth of bkps.

Any tips? Again, please excuse my rather rudimentary knowledge of code.

[Skirge01]

What does failure to stop the service do? I ask because I've been backing up the Sage directory both manually or with a backup program for years and I've never stopped Sage to do so. In that time, I've also restored the directory with the wiz.bin and never had an issue there either. (Obviously, I stopped Sage during the restore.)

Is this a case of you really should stop Sage before backing it up, but it probably doesn't matter under most circumstances?

[mechling-burgh]

I use a free program called Cobain Backup, and it uses windows shadow copy so no need to stop any service. It also backs it up to a simple zip file so its easy to recover. I have my wiz.bin file in its own directory c:\wizbin. So I run two backups one for SageTV directory and one for the wizbin directory. It's worked well for me for years now.

[BigSwifty]

Originally Posted by mechling-burgh

I have my wiz.bin file in its own directory c:\wizbin.

How do you relocate your wizbin?
I use Aomei and image my disk pretty often. I can restore successfully from this image however I'd like to be able to copy just the wizbin more frequently.

[nyplayer]

Originally Posted by BigSwifty

Thank you. That's what I thought.
I'm writing a bat file and have come up with this:

net stop SageTVservice
timeout /t 30 /nobreak
xcopy "C:\Users\evan\desktop\cows.doc" "E:\abkp\%date:/=_%_cows.doc"
net start SageTVservice

I believe it works. Note that I'll change the paths to the appropriate Sage directory. Now, I'd like to add a command to only keep perhaps a week's worth of bkps.

I'm not a coder.


Any tips? Again, please excuse my rather rudimentary knowledge of code.

I created this I backup the whole SageTV directory not just the Wiz.bin ... You can back it up to 4 different places if you like and you say how many days to keep. Most windows already have robocopy.

I also run it before upgrading SageTV. I do not care whether SageTV is up or not as robobocopy takes care of that.

set SageDIR=C:\Program Files (x86)\SageTV
set DaysToKeep=7
set NUMBKUPS=3
set backup1="\\NAS-BE-B8-48\backup\SageBackups\%COMPUTERNAME%"
set backup2="h:\SageBackups\%COMPUTERNAME%"
set backup3="%USERPROFILE%\OneDrive\%COMPUTERNAME%"
set backup4="xxxxxxxxxx\%COMPUTERNAME%"

************************************************************************************************************************************************
CD /d "%~dp0"
set folderin="%~dp0"
for /f "useback tokens=*" %%a in ('%folderin%') do set folderin=%%~a
set folderin=%folderin:~0,-1%
forfiles /p "%folderin%\%COMPUTERNAME%" /m SAGEBACKUP*.zip /c "cmd /c Del @path" /d -%DaysToKeep%
if exist  "%~dp0\%COMPUTERNAME%\SageTV" robocopy "%~dp0\%COMPUTERNAME%\SageTV" "%~dp0\%COMPUTERNAME%\SageTV_BKUP" /E /MT /MIR /R:3
robocopy "%SageDIR%" "%~dp0\%COMPUTERNAME%\SageTV" /E /XD "%SageDIR%\SageTV\GeneratedThumbnails" "%SageDIR%\SageTV\logs" "%SageDIR%\SageTV\jetty\logs" /E /MT /MIR /R:3
if exist  "%~dp0\%COMPUTERNAME%\SageTV_BKUP" zip.exe -r "%~dp0%COMPUTERNAME%\SAGEBACKUP_%date:~-4,4%%date:~-10,2%%date:~-7,2%_%time:~0,2%%time:~3,2%%time:~6,2%.zip" "%~dp0\%COMPUTERNAME%\SageTV_BKUP" 
rem if exist  "%~dp0\%COMPUTERNAME%\SageTV_BKUP" zip.exe -r "%COMPUTERNAME%.SAGEBACKUP_%date:~-4,4%%date:~-10,2%%date:~-7,2%_%time:~0,2%%time:~3,2%%time:~6,2%.zip" "%~dp0\%COMPUTERNAME%\SageTV_BKUP" 
if %NUMBKUPS% GEQ 1 robocopy "%folderin%\%COMPUTERNAME%" %backup1% /E /MT /MIR /R:3
if %NUMBKUPS% GEQ 2 robocopy "%folderin%\%COMPUTERNAME%" %backup2% /E /MT /MIR /R:3
if %NUMBKUPS% GEQ 3 robocopy "%folderin%\%COMPUTERNAME%" %backup3% /E /MT /MIR /R:3
if %NUMBKUPS% GEQ 4 robocopy "%folderin%\%COMPUTERNAME%" %backup4% /E /MT /MIR /R:3

[mechling-burgh]

Towards the bottom of the sage.properties files there is a location for the wiz.bin and the wiz.bak file location. I changed it so I could do upgrades and testing without ever worrying about the wiz.bin. I will make copies of the sagetv directory before upgrades or testing things. Then if I decide its not working the way I like I rename the copied directory back to Sagetv and I don't have to worry about coping the wiz.bin file back. Works for me, not sure it's the best way but I think it works well.

[BigSwifty]

Thank you for sharing.

Originally Posted by nyplayer

I do not care whether SageTV is up or not as robobocopy takes care of that.

Interesting. So the service doesn't have to be stopped? A very handy script!

[nyplayer]

Originally Posted by BigSwifty

Thank you for sharing.


Interesting. So the service doesn't have to be stopped? A very handy script!

No I never Stop the service ... robocopy if a file is in use and updating it will retry again.

[BigSwifty]

Thank you.