September 20, 2012 at 10:34 am
I would like to know answer for this Question
How SQL Server recognise if u run full backup ?
I tried to get answer for this question but :crazy:
September 20, 2012 at 10:41 am
Simha24 (9/20/2012)
I would like to know answer for this QuestionHow SQL Server recognise if u run full backup ?
I tried to get answer for this question but :crazy:
I am not sure what you mean. Are you trying to figure out when the last full backup of a database was run?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 20, 2012 at 10:56 am
There are tables in msdb that record what backups were done, where to (disk path, tape location, network path), what type, when they were done, and what was backed up.
Details on the tables can be found here: http://msdn.microsoft.com/en-us/library/ms188653.aspx
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply