Posted on: 8/2/2013 6:19:33 PM | Views : 215

I tried to use windows scheduler to schedule the SQL express DB backup. I followed these instruction but it didn't work:
USE [VIM]  dabase name
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

create PROCEDURE [dbo].[sp_BackupDb] 
       @dbName sysname, @backupTypeToRun CHAR(1)
AS
BEGIN
       SET NOCOUNT ON;
       DECLARE @sqlCommand NVARCHAR(1000)
       DECLARE @dateTime NVARCHAR(20)
       SELECT @dateTime = REPLACE(CONVERT(VARCHAR, GETDATE(),111),'/','-') +'-' +
       REPLACE(CONVERT(VARCHAR, GETDATE(),108),':','') 
      
       DECLARE @databaseFileNam ...

Go to the complete details ...