How to Copy a Database to Another Server

copy a database to another server
We’re happy to announce that we have a new feature added to sqlbak! This feature is most helpful as it will support you in restoring a database backup on another server on a different server, remotely!

How to copy a database to another server

Like we’ve said, this is a new feature and it’s very easy to use. Below we will show you a step by step tutorial on how you can do this.

      • First off we will have to have set up at least two computers in our SqlBak account in order to copy a database to another server.
        • For this tutorial we will be using two example servers, the DatabaseServer which is the main server from where we will copy the data through the backup
        • The second computer will be the RemoteDatabaseServer, where we will copy the data to, from the first computer
      • After having set up the computers we will have to create a new job in order to have our backup created, which will later be copied to the second server

copy a database to another server

      • In the Job screen just add the credentials in order to connect to your SQL Server instance, credentials which will automatically be used when running the backup job

copy a database to another server

      • After adding the credentials to log into the SQL Server database, you will have to set up the location where the backup will be stored, and will later be automatically read by the restore operation

copy a database to another server

      • Also, please take notice of all available options for your backup in order to make them more secure (use encryption), to make them occupy less space (use compression) etc.

copy a database to another server

      • After setting up the job and saving the configuration, run the job in order to verify that the settings/credentials will work correctly

copy a database to another server

      • Afterwards, go back to your Dashboard and select the Restore option from the server you want the restore to be made

copy a database to another server

      •  A simple interface will pop-up where the last backup will be automatically selected. Press the Restore on another computer link, which will take you to a new interface where you can select which computer, from those which you have set up in SqlBak, you will restore to

copy a database to another server

copy a database to another server

      • You might receive an error when testing the SQL connection if your login user was just created and you haven’t logged into SQL Server with it yet
      • SQL Server will require you to change your password at first login and this is mandatory before you can first use it for your database

copy a database to another server

      • Also, even if you have managed to create a new credential and you succesfully tested the connection to SQL Server with the user’s credentials, you might get an error to the similar below, which means that you will need to add the dbCreator and sysAdmin Server Roles for the login you just created

copy a database to another server

copy a database to another server

      • After you’ve added all the required credentials and tested the connection to your SQL Server instance on your remote server, just press the Restore database button and a loading bar will appear showing you the progress of the operation
      • If the operation will be succesful you will receive a message like the one below

copy a database to another server

      • Now your database has  been remotely restored to your other server and you can go and review this using SSMS

About Radu Gheorghiu

Passionate SQL Developer on the journey of trying to become an expert in all things Data (storage, manipulation, gathering etc.) Information is power, and information can only be obtained from data. Thus, in order to harness the power of information, you must be a master of Data.

8 thoughts on “How to Copy a Database to Another Server

  1. Can the restore to another server be scheduled?
    I have 3 database SQL express located in 2 server that must be restored to an another server weekly.
    Thanks

  2. The restore can not not be scheduled at the moment, but we are considering to add it. We are not certain how often the scheduled restore is needed. What use case do you have?

    1. In my case the scheduled restore has 2 use.

      First – restore database to another server in order to have up to date data of programs where the access is only for statistics and report (no real time needed).

      Second – Test backup integrity for disaster recovery. If programs works, backups are ok. The operator plays two roles, backups tester (unwares) and report / statistics manager.

      TIA

  3. Hi,

    I have installed the free version of sqlbak. I am trying to take the backup and restore it on another server. But I am not getting the option to add another computer.

    Could you please help me on how I can add another server??

    Regards,
    Manasi

  4. Thank you for a quick response. That’s really helpful.

    Currently, I am trying professional version to do the same. I should get back to you in case any further issues faced on this.

    Regards,
    Manasi

Leave a Reply

Your email address will not be published. Required fields are marked *