Any idea how to translate TimeStamp from fn_virtualfilestats to real time?
Thank you.

A Timestamp of this type has little or nothing to do with a Datetime.  While
the names can be confusing a true timestamp is simply a binary number that
is guaranteed to be higher in value than the last one you got.  If you want
to keep a datetime then insert the results into a table that has an extra
column where you place the GETDATE() at the time you issue the select.

Show quoteHide quote

Primary File Group Full?
How to 'call' UDFs from SPs
How to backup and restore related databases?
Exporting data using T-SQL... something opposite of BULK INSERT.
SAN issues, please help
TRXN LOG BKP time takes so much longer than Full BKP???
could not find stored procdure xp_availablemedia
Is it possible to restore SQL Server from Registry and System file
Help needed with OpenQuery
Data Migration Recommendations Needed