September 9, 2008 at 5:34 pm
IF NOT EXISTS(SELECT * FROM msdb..backupset WHERE database_name=@Dbname
AND type='D' AND backup_start_date >=CONVERT(VARCHAR,GETDATE(),101))
DECLARE @Date DATETIME
SELECT @Date=MAX(backup_start_date) FROM msdb..backupset WHERE database_name=@Dbname
AND type IN ('D','I') and backup_start_date>=CONVERT(VARCHAR,GETDATE(),101)
In above script I just want to know the type in ('D','I')?
September 9, 2008 at 9:13 pm
If you can't trace this procedure down, you probably need to get some basic training.
The procedure just simply runs through a set of IF THEN logic and executes statements. If you go through it, you will see where it calls the BACKUP LOG and BACKUP DATABASE commands. Before that it uses devices to do the backups. If you don't understand devices, you should read up in Books Online.
September 9, 2008 at 10:09 pm
thanks Steve..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply