How can you see the last restore (NOT backup) date of your database ?

(At this kind of question in a day I answer in other day you answer, today is a day when you can answer) 

---

Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)

The answer is :

select * from msdb..restorehistory

select * from msdb..restorehistory

---

Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)

You can filter for a specific database using the following code sample:

SELECT

TOP 1

*

FROM msdb..restorehistory

WHERE destination_database_name = N'AdventureWorks'

AND TYPE = 'D'               

ORDER BY restore_date DESC

-- Type D stands for database

-- Other types: F = File, G = Filegroup, I = Differential

-- L = Log, V = Verifyonly, R = Revert

 

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro

Imi puteti spune va rog care e semnificatia "N" din dreapta =?

Multumesc

---

Secolul XXI ori va fi religios ori nu va fi deloc

Specificatia N este folosita pentru a specifica faptul ca sirul care urmeaza este UNICODE.

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro