Pillai,

Look in msdb database for tables like backupfile, backupset, restorefile, restorehistory, etc.

S. Davey (4/30)


MI DIT\Agency Services
7:30 A.M. - 4:00 P.M. ET
517.335.4237 (M- F CCC )
517.373.1349 (MDOT)


>>> "Pillai Sreelatha " <mssqldba-ezmlmshield-x40573115.[Email address protected] 04/30/08 10:09 AM >>>
Does 2005 have tables like sysbackuphistory, sysbackupdetail,
sysrestorehistory, and sysrestoredetail which would store backup and
restore details. Any help on this will be greatly appreciated. TIA


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page