Data Base sql server 备份数据库
sql server 备份数据库
1.维护计划向导:
右键维护计划-维护计划向导-然后安装提示:
勾选自己要干的事,比如:完整备份数据库、差异备份数据库等等
2.作业计划:
如下图:
SQL Server 代理-作业-右键新建作业
备份:
Declare @DataStr NVARCHAR(200)
set @DataStr = convert(NVARCHAR(19),getdate(),120)
set @DataStr = REPLACE(@DataStr, ':' , '_')
set @DataStr = REPLACE(@DataStr,' ','_')
set @DataStr = REPLACE(@DataStr,'-','_')
set @DataStr = 'C:\Grus\Backup\数据库名_'+@DataStr+'.bak'
BACKUP DATABASE [数据库名] TO DISK = @DataStr WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
删除:
收缩:
USE [master]
GO
-- 收缩数据库
DECLARE @dbname nvarchar(255) SET @dbname = 'WebOSv3-2013'
-- 1.截断事务日志
EXEC('BACKUP LOG ['+@dbname+'] WITH NO_LOG')
-- 2.收缩数据库
EXEC('DBCC SHRINKDATABASE(['+@dbname+'], TRUNCATEONLY)')
-- 3.设定自动收缩
EXEC('EXEC SP_DBOPTION '''+@dbname+''', ''autoshrink'', ''TRUE''')
GO