Skip to content

copy-databases-to-other-servers.md

Latest commit

 

History

History
46 lines (36 loc) · 2.54 KB

copy-databases-to-other-servers.md

File metadata and controls

46 lines (36 loc) · 2.54 KB
title Copy Databases to Other Servers | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic article
helpviewer_keywords
servers [SQL Server], copying databases between
bulk exporting [SQL Server], between servers
database copying [SQL Server]
migrating databases [SQL Server]
moving databases
copying databases
bulk importing [SQL Server], between servers
ms.assetid 978406d6-a3c8-4902-b1f4-4ced75234be5
caps.latest.revision 42
author JennieHubbard
ms.author jhubbard
manager jhubbard

Copy Databases to Other Servers

It is sometimes useful to copy a database from one computer to another, whether for testing, checking consistency, developing software, running reports, creating a mirror database, or, possibly, to make the database available to remote-branch operations.

There are several ways to copy a database:

  • Using the Copy Database Wizard

    You can use the Copy Database Wizard to copy or move databases between servers or to upgrade a [!INCLUDEssNoVersion] database to a later version. For more information, see Use the Copy Database Wizard.

  • Restoring a database backup

    To copy an entire database, you can use the BACKUP and RESTORE [!INCLUDEtsql] statements. Typically, restoring a full backup of a database is used to copy the database from one computer to another for a variety of reasons. For information on using backup and restore to copy a database, see Copy Databases with Backup and Restore.

    [!NOTE]
    To set up a mirror database for database mirroring, you must restore the database onto the mirror server by using RESTORE DATABASE <database_name> WITH NORECOVERY. For more information, see Prepare a Mirror Database for Mirroring (SQL Server).

  • Using the Generate Scripts Wizard to publish databases

    You can use the Generate Scripts Wizard to transfer a database from a local computer to a Web hosting provider. For more information, see Generate and Publish Scripts Wizard.