sqlserver备份两种方式

来源：互联网发布：淘宝上鮀品是什么意思编辑：程序博客网时间：2024/06/05 05:00

1. 通过维护计划2. 通过job运行命令--差异备份EXECUTE master.dbo.xp_create_subdir N'D:\pic\RE\TEST'GOBACKUP DATABASE [TEST] TO DISK = N'D:\pic\RE\TEST\TEST_backup_201101051801.bak' WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'TEST_backup_20110105180152', SKIP, REWIND, NOUNLOAD, STATS = 10go--完整备份BACKUP DATABASE [TEST] TO DISK = N'D:\pic\RE\TEST_backup_201101051802.bak' WITH NOFORMAT, NOINIT, NAME = N'TEST_backup_20110105180256', SKIP, REWIND, NOUNLOAD, STATS = 10go--强制还原--REPLACE覆盖已存在数据库RESTORE DATABASE TEST FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\TEST.BAK'WITH MOVE 'TEST' TO 'D:\pic\TEST.mdf', MOVE 'TEST_log' TO 'D:\pic\TEST_log.ldf',STATS = 10, REPLACEGO--显示备份列表RESTORE FILELISTONLY FROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Backup\TEST.BAK'go生成年月日的备份文件declare @databasename nvarchar(50)set @databasename = 'ExtDB'DECLARE @strPath NVARCHAR(200)set @strPath = convert(NVARCHAR(19),getdate(),120)set @strPath = REPLACE(@strPath, ':' , '.')set @strPath = 'E:\工作目录\bk\' + @databasename+@strPath + '.bak'BACKUP DATABASE @databasename TO DISK = @strPath WITH NOINIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

0 0