一、数据库的备份
--1.备份数据库到 D:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup\leosen_dev\leosen_dev_back_20230720.bak
BACKUP DATABASE leosen_dev
TO DISK = 'D:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup\leosen_dev\leosen_dev_back_20230720.bak'
WITH FORMAT;
--2. 查看逻辑备份文件
RESTORE FILELISTONLY
FROM DISK = 'D:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup\leosen_dev\leosen_dev_back_20230720.bak';
二、数据库的导入
--3. 创建目标数据库
CREATE DATABASE leosen_dev_35479;
--4. 从磁盘复制数据库
RESTORE DATABASE leosen_dev_35479
FROM DISK='D:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Backup\leosen_dev\leosen_dev_back_20230720.bak'
WITH
MOVE 'leosen_dev' TO 'D:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\leosen_dev_35479.mdf',
MOVE 'leosen_dev_log' TO 'D:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\leosen_dev_35479.ldf',
STATS = 10,REPLACE