---
title: "Discussion on \"How to Move MSSQL to a New Server\" | Hashnode"
description: "Discussion on \"How to Move MSSQL to a New Server\". One way to manually move an entire MSSQL database to a new server is to copy the database files: the .mdf (Main Data File) and the .ldf (Transaction Log File).\nWhat are .mdf and .ldf files?\nThe .mdf file contains all the data and structure of the dat..."
url: "https://hashnode.com/posts/how-to-move-mssql-to-a-new-server/6742d949dcc88a70b3382b17"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [How to Move MSSQL to a New Server](https://louischiang.hashnode.dev/how-to-move-mssql-to-a-new-server?utm_source=hashnode&utm_medium=feed)

One way to manually move an entire MSSQL database to a new server is to copy the database files: the .mdf (Main Data File) and the .ldf (Transaction Log File). What are .mdf and .ldf files? The .mdf file contains all the data and structure of the dat...

Nov 24, 2024 · 2 min read · louischiang.hashnode.dev  
Read the article

-   [#databases](https://hashnode.com/tag/databases)
-   [#mssql](https://hashnode.com/tag/mssql)

## Written by

[louis chiang](https://hashnode.com/@louischiang)

@louischiang

  
[View profile](https://hashnode.com/@louischiang)

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
