I'm still struggling with this.

In order to create a condition i need to specify a facet but i'm not sure which facet i should be using.

Thanks for the advice, i'll give this ago when i'm back in the office and let you know how i get on.

Upon further inspection, the virtual disks do indeed have physical disks from the two RAID arrays "mapped" to them and these then appear as the C and D drive on...

Thanks again for your help.

The whole creation of virtual disks is really confusing me, i really dont follow how they relate to the RAID arrays.

I'll continue looking online.

Thanks for the prompt reply, i'm not sure that i follow you here but i dare say i havent made myself very clear. Let me try again.

We are experiencing high...

Nothing other then the completion messages for the other databases being backed up.

ALTER PROCEDURE [dbo].[Backup_Database] @DBName varchar(250) AS

BEGIN

SET NOCOUNT ON;

DECLARE @FILENAME varchar(250)

SELECT@FILENAME = 'D:\SQLBackup\x.bak'

BACKUP DATABASE @DBName

TO DISK = @FILENAME

WITH FORMAT

END

The agent job calls a stored proc which executes a backup database command; there is definitely no log backup taking place.

This is my frustration; i can't seem to track the...

Thanks, but this artcile is talking about taking a log backup before taking a full data backup. I am trying to run a full database backup so it doesn't apply...

No, we are using the same search engine. I have checked each of the websites that are returned on the first two pages.

Could you advise which of the results you...

I have already done a thorough internet search; suggestions go along the lines of "check the log for error messages which may identify the problem".

No entries, other then those which...

Thanks for the advice; i will give this a try.

FYI wrapping the stored procedure call in a try catch did not solve the problem; the error is still thrown and the job stops executing.

Thanks for your contributions; i have been out of the office this week but i will now work through your suggestions.

I will post back the results.

Thanks for the advice; i'll give it a go.