[sims] Backing up Solus3 and a query

[Chuckster]

My Google-fu is weak today and I can't find anything online on how to backup the solus3 database.

 

Can anyone point me in the right direction or know of a script that performs the backing up of the database?

 

Additionally, I noticed a database called 'watersedge' on the SIMS server. Does anyone know what it is and why it might be on there?

[round2it]

might not help but we have this running

 

SET SQLPATH=c:\Program Files\Microsoft SQL Server\MSSQL11.SIMS2012\MSSQL

SET SA_PASSWORD=your sa password here

ECHO.

ECHO ============================================================================

ECHO BACKING UP THE SOLUS3 DATABASE:

"%SQLPATH%\Binn\dbattach.exe" /BACKUP /AUTO /SERVER=%COMPUTERNAME%\SIMS2012 /DATABASE=solus3_deployment_server /USER=sa /PASSWORD=%SA_PASSWORD% /PATH="%SQLPATH%\Backup\SOLUS3_Deployment_Server_%date:~-4,4%%date:~-7,2%%date:~0,2%_%time:~0,2%%time:~3,2%%time:~6,2%.bak"

ECHO ============================================================================

ECHO.

 

IF %ERRORLEVEL%==1 GOTO ERROR

 

:COMPLETE

BACKUP COMPLETE!

EXIT

 

:ERROR

BACKUP FAILED!

EXIT

Edited March 14, 2022 by round2it

[jmcdermott]

as above but using powershell to also transfer the sims users usernames and passwords

 

Import-Module SQLPS -DisableNameChecking

Invoke-Sqlcmd -ServerInstance -Username "sa" -Password -Query "exec sims.sims.db_p_transfer_login"

Start-Sleep -s 30

 

Then backup as above or still in powershell

 

cmd.exe /c "C:\Program Files\Microsoft SQL Server\MSSQL12.SIMS2014\MSSQL\Binn\DbAttach.exe" /BACKUP /AUTO /SERVER= /DATABASE=SIMS /USER=sa /PASSWORD= /PATH=c:\SIMS.BAK

Edited March 14, 2022 by jmcdermott

[Chuckster]

That did the trick - thanks!

[round2it]

think i will go with your version now, mine was a quick fix as a belt and braces aproach as the vms are backed up entirly each night

[TwistedHelixis]

Import-Module SQLPS -DisableNameCheckingInvoke-Sqlcmd -ServerInstance -Username "sa" -Password -Query "exec sims.sims.db_p_transfer_login"Start-Sleep -s 30

 

Should I do similar for FMS?

 

Once the users have been transferred, will they stay transferred, or do I need to run this frequently?

[jmcdermott]

It is only required if new users have been created or passwords have been changed.

 

For FMS it should be something like

Import-Module SQLPS -DisableNameCheckingInvoke-Sqlcmd -ServerInstance -Username "sa" -Password -Query "exec fms.sims.db_p_transfer_login"

 

where the "fms" in "fms.sims.db_p_transfer_login" is the name of the fms database.

[TwistedHelixis]

It is only required if new users have been created or passwords have been changed.

 

For FMS it should be something like

Import-Module SQLPS -DisableNameCheckingInvoke-Sqlcmd -ServerInstance -Username "sa" -Password -Query "exec fms.sims.db_p_transfer_login"

 

where the "fms" in "fms.sims.db_p_transfer_login" is the name of the fms database.

 

Brilliant thanks.

 

One last question, after they have transferred, is it possible to see where they have transferred to using SQL management studio? I assume they end up in the SIMS or FMS database somewhere.

[jmcdermott]

They do get transferred from the master database to the sims/fms database but I am not aware of where you would be able to see them.