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