MSSQL 資料庫用 SQL 語法進行備份、還原、新增

bestlong

新增資料庫

1. USE [master]
   
2. GO
   
3. CREATE DATABASE [MYDB] ON  PRIMARY
   
4. ( NAME = N'MYDB', FILENAME = N'D:\DB\MYDB.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
   
5. LOG ON
   
6. ( NAME = N'MYDB_log', FILENAME = N'D:\DB\MYDB_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
   
7. GO

複製代碼

備份資料庫

1. BACKUP DATABASE [MYDB]  TO DISK='D:\DBBackup\MYDB_20100101063000.bak'

複製代碼

還原資料庫

1. RESTORE DATABASE MYDB
   
2.    FROM DISK = 'D:\DBBackup\MYDB.bak'
   
3.    WITH
   
4.    MOVE 'MYDB' TO 'D:\DB\MYDB.mdf',
   
5.    MOVE 'MYDB_log' TO 'D:\DB\MYDB_log.ldf',
   
6.   REPLACE;
   
7. GO

複製代碼