Skip to content

SQLSERVER 数据库备份并新增数据库还原 ​

备份 ​

SQL

USE [master]
BACKUP DATABASE [test] TO  DISK = N'E:\DB_FullBackup\test\test.bak' WITH NOFORMAT, NOINIT,  NAME = N'_FaullBackup_2023_04_14_bak', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
GO

还原 ​

SQL

RESTORE DATABASE test
FROM DISK = 'E:\DB_FullBackup\test\test.bak'  
WITH MOVE 'test' TO 'E:\DB\test\test.mdf',  
MOVE 'test' TO 'E:\DB\test\test_log.ldf'