Is it possible to take an existing MS SQL database backup from the Windows components backup and restore the database onto a new server with a fresh copy of MS SQL?
-Offsite client server with MS SQL 2014
-File backups run daily and Windows Components selected for SqlServerWriter and all databases selected
-Spin up a fresh server at a different client site with the same server OS and version of MS SQL 2014
How would one restore the databases from the existing urbackup client to this new MS SQL server? The original urbackup client would still be live and connected to the urbackup server.
We would like to perform monthly restoration tests to ensure the clients that their databases can be restored offsite for disaster recovery.
Any feedback/suggestions would be appreciated as I have not found a similar scenario posted in the forums so far.