sql server 备份
标签：bsp sql compress orm color rbac ini pre back
sql server 备份
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;