首页 > 数据库技术 > 详细

数据库备份(存储过程)

时间:2016-02-13 17:07:28      阅读:203      评论:0      收藏:0      [点我收藏+]
USE T_PaotuiChannel
GO
/****** Object:  StoredProcedure [dbo].[T_Paotui_Dic_BackupDBToLocalDisk]    Script Date: 2016/2/13 16:08:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
---
--- SQL作业
--- 数据库备份
--- 

create proc [dbo].[T_PaotuiChannel_BackupDBToLocalDisk]

AS

DECLARE @FullPath varchar(1000) 
declare @FolderPath varchar(500)
set @FolderPath= f:\uupaotui_bak\T_PaotuiChannel\
set @FullPath = @FolderPath+ T_PaotuiChannel_+convert(VARCHAR(4),year(getdate()))+right( 0+convert(VARCHAR(2),MONTH(getdate())),2)+right(0+convert(VARCHAR(2),DAY(getdate())),2)+_+ convert(VARCHAR(4),DATEPART(hour,getdate()))+ .bak

backup database T_Paotui_Dic to disk=@FullPath WITH INIT

 

数据库备份(存储过程)

原文:http://www.cnblogs.com/renfushuai/p/5188032.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!