Stored Procedure to backup

[risoam]

I have a stored procedure:

CREATE PROCEDURE dbo.MVEMS_BACKUP AS
declare @dbbkpname as varchar(40)

select @dbbkpname='d:\ftp\myfolder\monroe.bak'
backup database MVEMS to disk=@dbbkpname

GO

that backs up my database. How do I make it so it doesnt append to the backup file? Each backup keeps appending and i'm not sure how to change it so it doesnt do that. Thanks!

 

[topher0303]

Goto BOL and lookup BACKUP DATABASE. The answer is at your fingertips.

If you need to know where to find BOL, check out this excellent FAQ by tlbroadbent:

http://www.tek-tips.com/faqs.cfm?pid=183&newpid=183&sfid=689

Chris.