冀东油田领导班子成员:请问SQL Server 备份数据库的 T-SQL 代码?

if exists (select name from dbo.sysobjects where name = 'proc_backupDataBase' and TYPE = 'P')
drop PROCEDURE [dbo].[proc_backupDataBase]
GO

CREATE PROCEDURE dbo.proc_backupDataBase
AS
BACKUP DATABASE [DataBaseName]
TO DISK = 'D:\DataBase.bak'
GO
上面是执行备份的存储过程，执行该存储过程即可备份数据库
EXEC dbo.proc_backupDataBase
GO

备份
-- Create the backup device for the full MyNwind backup.
USE master
EXEC sp_addumpdevice 'disk', 'MyNwind_2',
'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwind_2.dat'

--Create the log backup device.
USE master
EXEC sp_addumpdevice 'disk', 'MyNwindLog1',
'c:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\MyNwindLog1.dat'

-- Back up the full MyNwind database.
BACKUP DATABASE MyNwind TO MyNwind_2

-- Update activity has occurred since the full database backup.

-- Back up the log of the MyNwind database.
BACKUP LOG MyNwind TO MyNwindLog1

在网上拷贝的一个方法，应该可以

DECLARE @path VARCHAR(50)
SET @path='C:\shop'+CAST(DATEPART(WEEKDAY,GETDATE()) as varchar)+'.'+CAST(DATEPART(WEEKDAY,GETDATE()) as varchar)+'BAK'
BACKUP DATABASE [shop] TO DISK = @path WITH INIT , NOUNLOAD , NAME = N'shop 备份', PASSWORD=N'shop0987', NOSKIP, STATS = 10, NOFORMAT

--这是我自用的1个备份脚本,每次备份数据库shop到c盘的1个文件，文件名字为shop1.1bak(具体的数字和星期有关，就是可以保存1个星期内的备份)，并且备份文件的还原密码为： shop0987.你可以把他加到sql代理里,让他每天运行即可.