Help with script to backup the Solus3 database.

[TwistedHelixis]

Hopefully someone already has this or doesn't mind creating me a script, as scripts are just not my thing.

 

Need the script to run as a scheduled task and take a backup of my Solus3 database. Would be handy if it could keep the last 3 versions in the folder and delete older backups, but if needed it can just save a single copy over itself and I can worry about the versions later.

 

Thanks in advance :-)

[Boredguy]

In Powershell we have the following as part of our backup task, but you can do similar via batch file

 

$BackupPath = "F:\Backups"

$SAPassword = "Blah"

$DBServer = "server\instance"

$DBAttach = "d:\program files\microsoft sql server\mssql12.sims2014\mssql\binn\DbAttach.exe"

 

&$DBAttach /BACKUP /AUTO /SERVER=$DBServer /DATABASE=Solus3_deployment_server /USER=sa /PASSWORD=$SAPassword /PATH=$BackupPath\SOLUS.BAK

[jthompson]

Using a maintenance plan in SQL Server might be another way to achieve that, if you weren't needing it to specifically be a scheduled script.

[TwistedHelixis]

Thanks :-)

 

I'll test both options out over the weekend.

[Steve21]

Have you checked the one that comes with SIMs? There's a default batch file that's normally setup already that does a 5 day backup cycle including automatic zipping etc of the files (it does the SIMs database too as well as FMS/Solus etc but could always make another copy if you wanted a seperate one) it should be called SIMSDailyBackup.bat on the server (or at least it's normally setup with the original installs etc)

 

Steve

Edited December 16, 2021 by Steve21