CREATE PROCEDURE [dbo].[sp_DB_DelLog]
AS
BEGIN
SET nocount ON
DECLARE @DBName VARCHAR(50)
SET @DBName=db_name()
DUMP TRANSACTION @DBName WITH NO_LOG
BACKUP LOG @DBName WITH NO_LOG
DBCC SHRINKDATABASE(@DBName)
END

CREATE PROCEDURE [dbo].[sp_DB_Bak]
@BakPath VARCHAR(255)
AS
BEGIN
SET nocount ON
DECLARE @DBName VARCHAR(50)
SET @DBName=db_name()
DECLARE @Now datetime
SET @Now=getdate()
SET @BakPath = REPLACE(@BakPath,'/','\')
if right(@BakPath,1)<>'\'
SET @BakPath = @BakPath+'\'
SET @BakPath = @BakPath+@DBName+'_'+datename(yyyy,@now)+datename(mm,@now)+datename(dd,@now)+datename(hh,@now)+datename(mi,@now)+datename(ss,@now)
datename(ms,@now)+'.Bak'
Declare @BakName varchar(50)
SET @BakName='FULL Backup OF '+@DBName
BACKUP DATABASE @DBName
TO DISK = @BakPath
WITH FORMAT,
NAME = @BakName
end