SQL 2012 SP1 - backup path not showing correctly in SIMS system manager 6.

[louise_perry]

Hi

We have installed SQL 2012 on a SIMS server. I have checked all settings in SQL Studio Management Studio and this all points to the new SQL 2012 path ie D:\Microsoft SQL Server\MSSQL11.SIMS2012\MSSQL\Backup but in System Manager 6 it still shows the old SQL 2008 backup path ie D:\Microsoft SQL Server\MSSQL10.SIMS\MSSQL\Backup\. Any ideas gratefully received.

[Bubbles]

Does it not pick it up from the SIMS.INI?

[louise_perry]

I have checked the SIMS.ini and the SQL path is correct in here as well.

[matt40k]

Check the SQL bin folder, if I remember correctly there should be something called set backup path or something to that effect. There is a Capita doc somewhere on SupportNet as to how to use the command line tool.

 

PS: You should avoid using Sysman6 like the plague.

[louise_perry]

Couldn't find anything in the binn folder

Will check Capita tomorrow.

 

We don't use system manager 6 but this seems to be the only place where the backup path shows in SIMS and is still used when using dbattach.

[vikpaw]

It's in the SIMS share - take a look at this thread, it has a link to another useful thread too. http://www.edugeek.net/forums/mis-systems/87886-sims-backup-latest.html

If it's what i'm thinking of it's called setsimsbackupfolder - but be careful and check with your support team, you need to do this for both sims and fms, and it might not change the paths for other files being backed up.

 

As matt says avoid sysman 6, and check the latest docs on Capita's MyAccount.

[louise_perry]

Think this thread is going in the wrong direction. I'm referring to the SQL backup path which is used when running dbUpgrade.

Its showing incorrectly in System Manager 6 and this is the only place within SIMS you can view this path.

I have checked the Registry and again all seems to be pointing to the right SQL path as mentioned in my opening query.

Any more ideas greatfully received.

[vikpaw]

That program will set the backup folder but if it doesn't change on sysman 6 I would log a support call and they will advise how to change that.

[louise_perry]

I have been in touch with Capita but they want to set up a remote session but this isn't ideal. I have asked them today what they will do so I can have a look myself.

[matt40k]

The setsimsbackupfolder we spoke about basically sets the path in SQL - if you've got SQL management studio install\ok using osql\sqlcmd then you can check by running: select location from sims.db_backup_location