Hi eveyone..I have this stored Proc that calls in a Job for the database backup..everytime i try to run an error occurExecution of job 'Backup GP full backup12AM' failed. see the history log for details.CREATE PROCEDURE [dbo].[prcBackupGreatPlainsFull12AM]ASBACKUP DATABASE [CFSCM] TO DISK = N'E:\GPBak\FullBackup\CFSCM_12AM.BAK' WITH INIT , NOUNLOAD , NAME = N'GreatPlains Backup', NOSKIP , STATS = 10, NOFORMATBACKUP DATABASE [CFSHI] TO DISK = N'E:\GPBak\FullBackup\CFSHI_12AM.BAK' WITH INIT , NOUNLOAD , NAME = N'GreatPlains Backup', NOSKIP , STATS = 10, NOFORMATBACKUP DATABASE [CFSI] TO DISK = N'E:\GPBak\FullBackup\CFSI_12AM.BAK' WITH INIT , NOUNLOAD , NAME = N'GreatPlains Backup', NOSKIP , STATS = 10, NOFORMATBACKUP DATABASE [CFSSA] TO DISK = N'E:\GPBak\FullBackup\CFSSA_12AM.BAK' WITH INIT , NOUNLOAD , NAME = N'GreatPlains Backup', NOSKIP , STATS = 10, NOFORMATBACKUP DATABASE [CITS] TO DISK = N'E:\GPBak\FullBackup\CITS_12AM.BAK' WITH INIT , NOUNLOAD , NAME = N'GreatPlains Backup', NOSKIP , STATS = 10, NOFORMATBACKUP DATABASE [DYNAMICS] TO DISK = N'E:\GPBak\FullBackup\DYNAMICS_12AM.BAK' WITH INIT , NOUNLOAD , NAME = N'GreatPlains Backup', NOSKIP , STATS = 10, NOFORMATBACKUP DATABASE [RYC] TO DISK = N'E:\GPBak\FullBackup\RYC_12AM.BAK' WITH INIT , NOUNLOAD , NAME = N'GreatPlains Backup', NOSKIP , STATS = 10, NOFORMATBACKUP DATABASE [SCCC] TO DISK = N'E:\GPBak\FullBackup\SCCC_12AM.BAK' WITH INIT , NOUNLOAD , NAME = N'GreatPlains Backup', NOSKIP , STATS = 10, NOFORMATBACKUP DATABASE [SMSTS] TO DISK = N'E:\GPBak\FullBackup\SMSTS_12AM.BAK' WITH INIT , NOUNLOAD , NAME = N'GreatPlains Backup', NOSKIP , STATS = 10, NOFORMATGO
BUt i can't see any errors in SQL Server Logs
Please Help!! Database backup Job Fails
Posted - 2009-06-15 : 00:29:31
