July 21, 2009 at 8:00 am
can any one send me the script to know what type of backups are scheduled on each database on a server .
July 21, 2009 at 8:28 am
You can't necessarily see what is scheduled unless you review jobs / maintenance plans. You can however review history by looking at the backupset table in msdb. Check out Books OnLine to understand the table contents and post back withs specific questions.
Hope this helps.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
July 21, 2009 at 9:07 am
Nice script that I use...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply