Home Forums SQL Server 2005 Backups Determining a database's completed restore date and time... RE: Determining a database's completed restore date and time...

  • SQL_ME_RICH (11/9/2012)


    Hi opc...It was a timing thing to determine how long a database would be available that we are doing slow boat to china copy jobs from. It's a copy of our PROD system, but is refreshed on a nightly basis. I was able to determine that both 2005 and 2008 R2 does show when it is completed, just as you suggested...I just didn't want to assume so.

    Good to know. BOL is amazingly complete in terms of its general coverage of the product but the wording in BOL can be frustratingly ambiguous when considering nuances like what you highlighted. Thanks for posting back.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato