FMS SQL database is set to FULL but needs to be changed to Simple.

[edutech4schools]

I have been told by the LA to migrate the Sims and FMS databases from SQL2008r2 to SQL2012, but both databases need to be simple and not full before I start. The LA have sent me a script to shrink the Sims database and set it to Simple and they are saying that as the FMS database is only 1gb I can simply use SQL management studio / FMS Database \ properties and change 'Full' to 'Simple'.

 

Before I do this I just wanted to make sure this was all OK.

 

Thanks

[bossman]

@edutech4schools:

 

Why SQL2012 and not SQL2014? as this is supported now?

[vikpaw]

Should be fine, but take a backup using your normal method first.

I would also do a transaction log backup as well. Which you can do in management studio, the wizard should guide you through.

[edutech4schools]

Why SQL2012 and not SQL2014?

 

LA, need I say more. It's taken them ages to get SQL2012 out to the schools.

 

Thanks @vikpaw