--备份 BACKUP DATABASE [TEST1] TO DISK = N'D:\TEST1.bak ' WITH NOFORMAT, NOINIT, NAME = N'COMMON_CN-完整 数据库 备份', SKIP, NOREWIND, NOUNLOAD, STATS = 10 GO--如果没有创建 IF DB_ID('TEST2') IS NULL CREATE DATABASE TEST2--还原 RESTORE DATABASE [TEST2] FROM DISK = N'D:\TEST1.bak' WITH FILE = 1, MOVE N'TEST2_Data' TO N'E:\TEST2.mdf', MOVE N'TEST2_Log' TO N'E:\TEST2.ldf', NOUNLOAD, REPLACE, STATS = 10 GO
BACKUP DATABASE [TEST1] TO DISK = N'D:\TEST1.bak ' WITH NOFORMAT, NOINIT, NAME = N'COMMON_CN-完整 数据库 备份', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO--如果没有创建
IF DB_ID('TEST2') IS NULL
CREATE DATABASE TEST2--还原
RESTORE DATABASE [TEST2] FROM
DISK = N'D:\TEST1.bak' WITH FILE = 1,
MOVE N'TEST2_Data' TO N'E:\TEST2.mdf',
MOVE N'TEST2_Log' TO N'E:\TEST2.ldf',
NOUNLOAD, REPLACE, STATS = 10
GO
逻辑文件 'TEST2_Data' 不是数据库 'TEST2' 的一部分。请使用 RESTORE FILELISTONLY 来列出逻辑文件名。
服务器: 消息 3013,级别 16,状态 1,行 1
RESTORE DATABASE 操作异常终止。
GG ~ 不能啊~
IF DB_ID('TEST2') IS NULL
BEGIN
create database TEST2
on primary
(name = 'TEST2_data',
filename = 'E:\TEST2.mdf',
size = 3mb,
filegrowth = 1mb)
log on
(name = 'TEST2_log',
filename = 'E:\TEST2.ldf',
size = 1mb,
maxsize = 5mb,
filegrowth = 1%)
go
END