备份数据库可以用这个存储过程吗?这样不备份日志文件可以吗?

CREATE PROCEDURE BACKUPmyData

AS
DECLARE @path varchar(15)
set @path=convert(varchar,getdate(),112)
set @path='C:\dbbak\'+@path+'.MDF'

BACKUP DATABASE BookOperater
TO Disk = @path
WITH FORMAT,
NAME = 'Full Backup of BookOperater'

RETURN
GO

还有,我想问一下还原数据库的存储过程怎么写?高手提供一下,谢谢

[此贴子已经被作者于2007-3-30 10:23:11编辑过]