[sims] Backing up SIMS & FMS SQL2012

[Ghostdancing]

Hi

 

Have written script to backup our SIMS, FMS, Discover & Deployment Server databases, but it is throwing me back an error.

 

"C:\Program Files\Microsoft SQL Server\MSSQL12.SIMS2014\MSSQL\Binn\DbAttach.exe" /Server=vs-xxxx\simsxxxx /Database=discover /user=sa /password=Sxxx@xxx /backup /auto

 

The program crashes with the following error.

 

 

I am presuming my cmd line is correct, just that I might be missing a step before, or a have an issue with something on the server.

[Esteban_Child_of_the_Sun]

Try using the Discover backup utility. Here is a line from my batch script

"%SQLINSTALLPATH%\Binn\Discover.Backup.Console.exe" /Operation=Backup /database=Discover /Server=%SERVERNAME%\%SQLINSTANCE% /Username=SA /Password=%SAPASSWORD% /Backupfilename=c:\backup\Discover.dbk

[Ghostdancing]

Hi

 

It seems you cannot backup the Discover database this way, but it works fine for FMS and SIMS. As the discover Db can be rebuilt from SIMS, this is not an issue.

All working fine now, backup runs to the QNAP every night into a name and dated folder. Any folder older than a month are removed.

 

Happy days.

[Steve21]

%DBAttachpath%\DbAttach.exe /BACKUP /AUTO /SERVER=%DBServer% /DATABASE=Discover /USER=sa /PASSWORD=%SAPassword% /PATH=%BackupPath%\%day%Discover.BAK

"D:\Program Files\Microsoft SQL Server\MSSQL12.SIMS2014\MSSQL\Binn\discover.backup.console.exe" /Operation=Backup /database=discover /Server=%DBServer% /username=sa /Password=%SAPassword% /BackupFilename=%BackupPath%\%day%discoverbk.dbk /Overwrite=True

 

Is what ours uses.

 

Steve

Edited August 19, 2016 by Steve21