by cmdrriker » Wed Oct 13, 2010 9:42 pm people like this post
I'd like to move an existing Veeam database from a locally installed sql server (sql is currently installed on the same server as Veeam) to a remote dedicated sql server. We are consolidating all of our standalone application sql instances on to one dedicated sql server. I know how to do a database backup and restore in sql, so my question is not how to move an sql database. What I don't see is a configuration option in Veeam to change where it should look for it's database. So, if I want to move the database only, not the Veeam installation itself, how do I change the database location in the Veeam application?
A registry edit is fine with me if there's not an option in the interface to do this. If a registry edit is the only way to do this, then specific information on the keys and values that need to modified would be appreciated.
by Gostev » Mon Dec 06, 2010 8:44 pm people like this post
I did email both dev and QC manager asking for help on this, have not heard back yet... and forgot to ping today... as always, your best bet would be to go through support with requests like this. Anything that came to dev/QC through support will never be forgotten or ignored, because support staff will sit on them until the issue is resolved or answer is provided
by Bunce » Wed Dec 08, 2010 8:26 pm people like this post
That can't be right. One of the commonly posted methods on handling DR for the Veeam Server involves replicating the SQL database manually to the DR site.
This requires redirecting the Veeam server to the new SQL server. We use this as do many others, and is recommended by Veeam staff given there are currently no built in alternaves.
Are you sure you changed those keys correctly? If you've got a spare server, try a fresh install to the new SQL Server and compare the reg keys to what you are currently using.
There may even be a key which differentiates between local and external databases.. I know there's an additional key that needs to be changed if you are conneting to the DB from a different Veeam server
by lobo519 » Wed Dec 08, 2010 8:45 pm people like this post
OK - support confirmed that these keys were the correct ones to change even with Version 5. Where I got caught - I filled in the "SQLInstanceName". with this specified I could not start the Veeam Backup service. Leaving it blank did the trick!