----------------------------------------------備份數(shù)據(jù)庫-----------------------------------------------------------------------
USE [master]
GO
ALTER DATABASE [TEST] SET RECOVERY SIMPLE WITH NO_WAIT    --簡單

USE [TEST]
go
DBCC SHRINKFILE (N'Leader_Log' , 0, TRUNCATEONLY)    --縮日志

USE [master]
GO
ALTER DATABASE [TEST] SET RECOVERY FULL WITH NO_WAIT   --完整

declare 
@RiQi varchar(6),
@LuJing varchar(200),
@Path varchar(200)
set @Path = '\\DC01\Buckups$\'  --用鏡像賬號網(wǎng)絡共享存儲
set @RiQi = (select CONVERT(varchar(4),DATEPART(YEAR,getdate())) + CONVERT(varchar(2),DATEPART(mm,getdate())))
set @LuJing = @Path  + @RiQi + 'TEST.bak'
backup database TEST to disk=@LuJing  with init 

declare 
@RiQi varchar(6),
@LuJing varchar(200),
@Path varchar(200)
set @Path = '\\DC01\Buckups$\'
set @RiQi = (select CONVERT(varchar(4),DATEPART(YEAR,getdate())) + CONVERT(varchar(2),DATEPART(mm,getdate())))
set @LuJing = @Path + @RiQi + 'TEST.bak'
backup log TEST to disk=@LuJing

-----------------------------------------------查看備份文件--------------------------------------------------------------------------------------

restore headeronly from  disk='\\DC01\Buckups$\20183TEST.bak'

-----------------------------------------------還原數(shù)據(jù)庫----------------------------------------------------------------------

restore database TEST from  disk='\\DC01\Buckups$\TEST.bak' with file=1,replace,norecovery  --第一個完整還原
restore log TEST from  disk='\\DC01\Buckups$\20183TEST.bak' with file=2,replace,norecovery --第二個日志還原
restore log TEST from  disk='\\DC01\Buckups$\20183TEST.bak' with file=3,replace,norecovery --第三個日志還原
restore log TEST from  disk='\\DC01\Buckups$\20183TEST.bak' with file=4,replace,recovery     --最后一個日志還原

當前題目：SQL按月備份與還原
URL標題：http://www.chinadenli.net/article18/gpcggp.html

成都網(wǎng)站建設公司_創(chuàng)新互聯(lián)，為您提供建站公司、網(wǎng)站排名、外貿建站、網(wǎng)站建設、網(wǎng)站改版、品牌網(wǎng)站建設

廣告

聲明：本網(wǎng)站發(fā)布的內容（圖片、視頻和文字）以用戶投稿、用戶轉載內容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內容未經(jīng)允許不得轉載，或轉載時需注明來源： 創(chuàng)新互聯(lián)