[sims] SIMS Backup

[CommodoreS]

Our SIMS server has an extra backup script that I guess Capita placed on it. This runs as a scheduled task but also has the following line:

 

SQLCMD -SLocalhost\SIMS2016 -E -Q"exec sims.sims.db_p_transfer_login"

 

And a similar one for FMS. Can anyone tell me what this command does and what it backs up?

[TwistedHelixis]

Going to have a guess at this, so could be wrong. Some Sims & FMS backup methods don't actually backup the users only the database, as the users are held in a different section within SQL.

 

I was actually stung by this in the past when moving to a new server, everything seemed fine after restoring the databases but I could not login, after searching around I found the users accounts had not been backed up along with the databases. Luckily I still had the old server and found a script to transfer the logins, which I am guessing you script is also doing.

[matt40k]

SQL logins are stored in the MASTER database. That stored procedure copies the logins\passwords into the SIMS \ FMS database.