sql server 备份
时间:2021-07-01 10:21:17
帮助过:23人阅读
WAP_WORKSHEET;
GO
BACKUP DATABASE WAP_WORKSHEET
TO DISK = ‘E:\SQL\Data\backup\WAP_WORKSHEET.Bak‘
WITH FORMAT,
MEDIANAME = ‘Z_SQLServerBackups‘,
NAME = ‘Full Backup of WAP_WORKSHEET‘;
GO
--backup database WAP_WORKSHEET
--to disk = ‘E:\SQL\Data\backup\WAP_WORKSHEET.Bak‘
--with
--compression,
--format,
--init,
--skip,
--stats=5;
--backup log WAP_WORKSHEET
--to disk = ‘E:\SQL\Data\backup\WAP_WORKSHEET_log.bak‘
--with
--compression,
--format,
--init,
--skip,
--stats=5;
sql server 备份
标签:bsp sql compress orm color rbac ini pre back