[sims] System Manager Backup

[MattDLEA]

I think I have done it correct but just wanted to check.

 

I went into systems manager > create backup > gave it a Description and got a .bak file saved ( 1Gb we are a primary school with not much stuff on there)

 

So what is this .bak file ?

Is it just a backup of the MsSQL database?

So all the data is there?

 

Cheers

Matt

[bobsmith]

Whenever Capita want a backup from me to upload and trouble shoot a tech case this is the method they use.

 

It's not a pure SQL backup, but I've never deconstructed one to see what the differences are.

[MattDLEA]

OK,

so what do you backup in Sims?

Our LA back ours up but I just want to also make sure that we have a copy ( we are looking at going to hosted Sims)

Edited March 14, 2016 by MattDLEA

[bobsmith]

Our Network Manager runs proper SQL backups.

 

The system manager route is only used when Capita want a backup they can use.

 

I presume the major difference is the security on the file, the SQL backup still has the SQL user permissions attached, whereas the .bak from system manager doesn't?