The goal is to have two copies of each full backup and each log backup stored on different physical media (in this case, the D: drive and F: drive on...

How about this:

CREATE FUNCTION dbo.fGetDateTimeString

(

@dt datetime

)

RETURNS varchar(12)

AS

BEGIN

RETURN Convert(varchar(8), @dt, 112) + Replace(Convert(varchar(5), @dt, 114), ':', '')

END

Gail and Lynn,

Thanks for responding so quickly. I performed a quick test whereby I made a full backup followed by 4 sets of dual log backups. This is a...