Migrate SSR 2013 database to new server

[Ravi_Bhandari]

Hi,

apologies if I'm covering old ground, but since moving to SSR 2013 Management Solution from SSR2011, I now wish to migrate the database from Sqlserver 2005 to Sqlserver 2012 and was wondering what the procedure is.

The database would be on a different host and named instance, ie. not the default mssqlserver.

Many thanks in advance.

[TRaj]

SQL 2012 is not supported with SSR- MS 2011 or SSR-MS 2013

[Markus_Koestler]

SQL 2012 should be supported later this year afaik.

[Ravi_Bhandari]

Thanks, that's good to know. So what would be the process if I was to move to SQL 2008 R2 ?

Will it require a registry hack or an odbc configuration to look at a different server and instance?

[Markus_Koestler]

No, this settings can be changed in the Settings of the Notification server (Symantec Management Console).

[TRaj · Accepted solution]

Hope all your queries are resolved..

[Ravi_Bhandari]

Is this to be found under Settings and Notification server database?

I'll try changing this and see what happens.

[Markus_Koestler]

Yes