How do I change the default backup location for Sims and FMS

[edutech4schools]

Last year when I used the SQL2008 to SQL2012 migration tool it gave me the option of choosing a backup location so if I updated Sims or FMS with any updates the automatic backups would be in a folder of my choice and not progfiles\mssql........\backup

 

I have just had to re install Sims and FMS on a new server, so no migration tools. Everything seems OK but I can't work out how to change the default Sims and FMS backup locations.

 

Any ideas

 

- - - Updated - - -

 

I am using SQL Express 2012 but with tools such as sql studio.

[BestTech]

You need the SIMS command to change the backup path: (ignore all <> and replace with the actual names of server, sql instance, etc.)

 

:\sims\setups\setsimsbackupfolder /server=\ /database= /backup_path=":\Program Files\Microsoft SQL Server\\Backup" /user=sa /password=

 

Make sure to remove all <> and insert correct paths, sql instance, server name, etc.

[edutech4schools]

Thanks. Do I run the same 'setsimsbackupfolder' for FMS?

[BestTech]

Yes, you just change the database name.