USE [xxdeathly] 
  GO 
  /****** Object:  StoredProcedure [dbo].[otodbyedekal]    Script Date: 01/29/2011 07:34:36 ******/ 
  SET ANSI_NULLS OFF 
  GO 
  SET QUOTED_IDENTIFIER OFF 
  GO 
  ALTER procedure [dbo].[otodbyedekal] 
  AS 
  declare @location varchar(120) 
  set @location = N'D:\yedekler-'+replace(str(year(getdate()))+'-'+str(month(getdate()))+'-'+str(day(getdate())),' ', '')+'.bak' 
  BACKUP DATABASE [xxdeathly] TO  DISK = @location WITH NOFORMAT, INIT,  NAME = N'xxdeathly-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10 
  declare @backupSetId as int 
  select @backupSetId = position from msdb..backupset where database_name=N'xxdeathly' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'xxdeathly' ) 
  if @backupSetId is null begin raiserror(N'Verify failed. Backup information for database ''xxdeathly'' not found.', 16, 1) end 
  RESTORE VERIFYONLY FROM  DISK = @location WITH  FILE = @backupSetId,  NOUNLOAD,  NOREWIND

Msg 3201, Level 16, State 1, Procedure otodbyedekal, Line 7 
  Cannot open backup device 'D:\yedekler-2011-1-29.bak'. Operating system error 5(Access is denied.). 
  Msg 3013, Level 16, State 1, Procedure otodbyedekal, Line 7 
  BACKUP DATABASE is terminating abnormally. 
  Msg 3201, Level 16, State 2, Procedure otodbyedekal, Line 11 
  Cannot open backup device 'D:\yedekler-2011-1-29.bak'. Operating system error 2(The system cannot find the file specified.). 
  Msg 3013, Level 16, State 1, Procedure otodbyedekal, Line 11 
  VERIFY DATABASE is terminating abnormally.