SIMS & FMS Backup

[itgeek]

Hi,

 

We currently use veeam to backup our SIMS & FMS server. How is everyone backing up the sims database, cmd and dbattach in case they need to restore?

 

 

Thanks

[BKGarry]

This is the batch file I used on top of our Microsoft DPM Backup, this makes sure I have at least 2 copies of the DB backup on top of our main VM backups if ever needed

 

rem Please set the following variables 

rem ----------------------------------- 

rem PLEASE CHECK THERE ARE NO EXTRA SPACES AT THE END OF THE FOLLOWING LINES. 

Set SAPassword=
Set SQLPath=D:\Administration\Server Applications\MS SQL Server 2016\MSSQL13.SIMS2016\MSSQL
Set DBAttachPath=%SQLPath%\BINN\DbAttach.exe
Set SIMSInstance=SIMS2016
Set FMSDB=CCSFMS
Set SIMSDB=SIMS
Set DISCOVERDB=DISCOVER
Set SIMSServerName=%ComputerName%
Set BackupRootFolder=D:\Administration\Server Applications
Set SQLBackupFolder=D:\Administration\Server Applications\SQL Backups
  
rem PLEASE CHECK THERE ARE NO EXTRA SPACES AT THE END OF THE LINES ABOVE. 

rem ----------------------------------- 

rem First check to see if the backup destination folders exist 

if not exist "%BackupRootFolder%" mkdir "%BackupRootFolder%"

if not exist "%SQLBackupFolder%" mkdir "%SQLBackupFolder%"

  
rem - Delete any existing OLD file 
rem ---------------------------------- 
del "%SQLBackupFolder%\FMSDB.old"
del "%SQLBackupFolder%\SIMSDB.old"
del "%SQLBackupFolder%\DISCOVERDB.old"

  
rem - Backup the existing BAK file 
rem   by renaming it 
rem ---------------------------------- 
ren "%SQLBackupFolder%\FMSDB.bak" FMSDB.old
ren "%SQLBackupFolder%\SIMSDB.bak" SIMSDB.old
ren "%SQLBackupFolder%\DISCOVERDB.bak" DISCOVERDB.old
  
  
rem - Run the ESS script - FMS 
rem ---------------------------------- 
"%DBAttachPath%" /BACKUP /SERVER="%SIMSServerName%\%SIMSInstance%" /USER="sa" /PASSWORD="%SAPassword%" /DATABASE="%FMSDB%" /AUTO /PATH="%SQLBackupFolder%\FMSDB.bak" 
  
  
rem - Now run the ESS script - SIMS 
rem ---------------------------------- 
"%DBAttachPath%" /BACKUP /SERVER="%SIMSServerName%\%SIMSInstance%" /USER="sa" /PASSWORD="%SAPassword%" /DATABASE="%SIMSDB%" /AUTO /PATH="%SQLBackupFolder%\SIMSDB.bak"


rem - Now run the ESS script - DISCOVER 
rem -----------------------------------
"%DBAttachPath%" /BACKUP /SERVER="%SIMSServerName%\%SIMSInstance%" /USER="sa" /PASSWORD="%SAPassword%" /DATABASE="%DISCOVERDB%" /AUTO /PATH="%SQLBackupFolder%\DISCOVERDB.bak"

[Jobos]

We run a scheduled task to export the DB before the backup runs.

[BKGarry]

I have also moved this thread to MIS Systems, just for categorisation :-)

[6Foot2]

We took advantage of our LEA's offering to backup off site.

[jthompson]

Veeam application aware backups are a good idea if you're not already using them as part of your Veeam jobs.

 

Additionally, a maintenance plan in SQL Server can automate a scheduled backup of your databases, retaining them in the backup location for a configured period to avoid. Haven't read this particular article, but from the screenshots it looks like it's pointing in the right general direction.

 

https://www.sqlshack.com/automate-sql-database-backups-using-maintenance-plans/