CREATE Procedure BackUp_pubs
@Device_Name Varchar(80),
@File_Name Varchar(125)
As

If Exists(Select @File_Name)
Begin

Exec Sp_Addumpdevice 'Disk',@Device_Name,
@File_Name

Backup Database pubs To @Device_Name

End
GO