June 24, 2014 at 4:58 am
Hello,
Please can anyone help with a script or SP that can help determine when databases where last archived?
N.X.O.J
June 24, 2014 at 5:23 am
What do you mean by archived? Can you pl. elaborate terms archived? Have you implemented any archive solution to database?
Reason I am asking is: in ORACLE it is different meaning and related to log.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
June 24, 2014 at 5:24 am
By archived, do you mean backed up? If so, then you can query the msdb database to see the backup history[/url]. If you mean some other process where data is archived off, that's something you're managing through custom processes and I don't have information of your internals.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply