bestlong 怕失憶論壇
標題:
MSSQL 資料庫用 SQL 語法進行備份、還原、新增
[打印本頁]
作者:
bestlong
時間:
2010-3-25 14:00
標題:
MSSQL 資料庫用 SQL 語法進行備份、還原、新增
新增資料庫
USE [master]
GO
CREATE DATABASE [MYDB] ON PRIMARY
( NAME = N'MYDB', FILENAME = N'D:\DB\MYDB.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'MYDB_log', FILENAME = N'D:\DB\MYDB_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
複製代碼
備份資料庫
BACKUP DATABASE [MYDB] TO DISK='D:\DBBackup\MYDB_20100101063000.bak'
複製代碼
還原資料庫
RESTORE DATABASE MYDB
FROM DISK = 'D:\DBBackup\MYDB.bak'
WITH
MOVE 'MYDB' TO 'D:\DB\MYDB.mdf',
MOVE 'MYDB_log' TO 'D:\DB\MYDB_log.ldf',
REPLACE;
GO
複製代碼
歡迎光臨 bestlong 怕失憶論壇 (http://www.bestlong.idv.tw/)
Powered by Discuz! X1.5