Opengist

Explore

  • All gists
  • Topics
  • Users
Give feedback on the new UI Powered by Opengist ⋅ 398ms

user:thomas gists created by user

title:mygist gists with given title

description:sync gists with given description

filename:myfile.txt gists having files with given name

extension:yml gists having files with given extension

language:go gists having files with given language

topic:homelab gists with given topic

all:systemctl search all fields

Login
f

for-attach

Recently created Least recently created Recently updated Least recently updated

timmy / 📦 SQL Server 附加 MDF / LDF 快速還原資料庫教學

Last active 6 hours ago database-recovery for-attach ldf mdf restore sql-admin sql-server

用 CREATE DATABASE ... FOR ATTACH 方式快速還原資料庫,不需還原備份檔也能立即啟用舊有 .mdf 與 .ldf!🧠

0 0 0 1
1 -- 建立資料庫並附加現有的 MDF(主資料庫檔案)和 LDF(記錄檔案)
2 CREATE DATABASE [你的資料庫名稱] -- 指定要建立的資料庫名稱
3 ON (FILENAME = '/你的路徑/你的資料庫.mdf'), -- 指定主資料庫檔案(MDF)的路徑
4 (FILENAME = '/你的路徑/你的資料庫_log.ldf') -- 指定交易記錄檔(LDF)的路徑
5 FOR ATTACH; -- 使用已存在的 MDF 和 LDF 檔案來附加資料庫
6 GO
7
8 -- 具體範例:附加 SalesDB 資料庫
9 CREATE DATABASE SalesDB -- 指定要建立的資料庫名稱為 SalesDB
10 ON (FILENAME = '/var/opt/mssql/data/SalesDB.mdf'), -- 主資料庫檔案(MDF)存放位置