MSSQL 資料庫用 SQL 語法進行備份、還原、新增
[color=Red]新增資料庫[/color][code]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
[/code][color=Red]備份資料庫[/color][code]
BACKUP DATABASE [MYDB] TO DISK='D:\DBBackup\MYDB_20100101063000.bak'
[/code][color=Red]還原資料庫[/color][code]
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
[/code]
頁:
[1]