ArticlesArticles Most Popular ArticlesMost Popular Articles
RSS Feeds
DrillDown Icon Table of Contents
DrillDown Icon 2019 Official Holidays & Support Schedule
DrillDown Icon IMPORTANT: End of Life of SHA1 on Windows Server 2003
DrillDown Icon IMPORTANT: Supported Operating Systems
DrillDown Icon PLEASE READ: Our Update Server IPs Have Changed
DrillDown Icon Support
DrillDown Icon modusGate for Microsoft Azure
DrillDown Icon modusCloud
DrillDown Icon Alleviating Spam – Best Practices
DrillDown Icon directQuarantine Technical Information
DrillDown Icon modusMail & modusGate Technical Information
DrillDown Icon Documentation & Release Information
DrillDown Icon Known Issues (non-release related)
DrillDown Icon Configuration Information
DrillDown Icon modusGate & modusMail
DrillDown Icon modusGate Only
DrillDown Icon modusMail Only
DrillDown Icon SQL Server Information
DrillDown Icon How-To: Enable Full Text Indexing for SQL Server Express
DrillDown Icon Known Issue: SQL Server Express Setup Problems on Windows 2000 Server
DrillDown Icon Info: Extended Database Format for ModusMail
DrillDown Icon How-To: Configure the SieveStore Database in SQL Server
DrillDown Icon How-To: Use SQL Server Instead of the Built-in MDB Database for Quarantine storage
DrillDown Icon How-to: Prevent Quarantine-Related Problems
DrillDown Icon How-To: Configure SQL TCP stack
DrillDown Icon How-To: Move SQL database from one server to another
DrillDown Icon MySQL Information
DrillDown Icon Security
DrillDown Icon Sieve
DrillDown Icon Spam and False-Positives
DrillDown Icon Statistics and Monitoring Section
DrillDown Icon Web Components
DrillDown Icon Troubleshooting
DrillDown Icon Hardware & OS System Requirements
DrillDown Icon Tools
DrillDown Icon Other Product Technical Information
DrillDown Icon Professional Services
DrillDown Icon Newsletters
  Email This ArticlePrint PreviewPrint Current Article/Category and All Sub-Articles/Categories
 
How-To: Move SQL database from one server to another
 

Product: SQL

Version & Build: All

 

 

 

Procedure:

 

It is recommend that both servers  to have the similar version of SQL install or upgrade to a more recent version. Down grade migration requires additional procedures.

 

  1. On the current version of SQL stop all services associated with SQL.

  2. Open windows explorer to locate the database .MDF and .LDF files and copy the files to its new server. normally located under "\MSSQL1X.SQLEXPRESS\MSSQL\DATA"

  3. Paste the .MDF and .LDF files to where the new SQL server will hold its data files. normally the same location under "\MSSQL1X.SQLEXPRESS\MSSQL\DATA"

  4. Open up SQL management studio on the server and right-click on DATABASE and select ATTACH.

  5. Click the ADD button and browser to the file location and select the .MDF file you copied.

  6. Click OK twice to have the databases imported.
  7. Then restart the SQL service.



Modified 1/12/2016
Keywords: SQL move
Article ID: 1920