Post reply

How do I know how long a restore takes after it is done?

  • August 4, 2009 at 7:19 am

    #140361

    Hello everyone

    This might sound very silly due to my novice to DB administration work. Yesterday I started restoring a database with a size of 350GB from a 75GB backup on a testing server from 11pm, and this afternoon at 3pm, when I remote-desktoped the server I found the restore has already finished. I then checked the sql server log in the log file viewer but can't see anything has been logged around 11pm yesterday and there are only two records around 6am early this morning saying that "Starting up database " and "The database is marked RESTORING and is in a state that does not allow recovery to run". Also, there is another log around 2:20pm today stating that "Restore is complete on database . The database is now available".

    So my question is whether this restore started around 11pm yesterday when I starting running the restore script or it actually happened around 6am this morning? How to determine the starting time of a restore then? Or did I totally miss something really important here? Thanks very much in advance for your advice!

    regards,

    Ning

    Bazinga!

  • August 4, 2009 at 7:31 am

    #1034236

    Hi,

    You can check the restorehistory table in msdb database.

    Refer http://msdn.microsoft.com/en-us/library/ms187408(SQL.90).aspx

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • August 4, 2009 at 7:48 am

    #1034243

    You might want to read from Books On Line the following:

    ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/799b9934-0ec2-4f43-960b-5c9653f18374.htm

    The information you are looking for is in the dbo.restorehistory table in the msdb database.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • August 4, 2009 at 7:51 am

    #1034245

    Thank you very much Chandra.

    The msdb.dbo.restorehistory table does tell me the "restore_date" which is the actual time that I started the restore operation. So I can assume that the sql server log does not record the starting time of a restoration then, which seems a little bit strange to me?

    regards,

    Ning

    Bazinga!

  • August 7, 2009 at 6:55 pm

    #1036347

    Nope it doesn't.

    MJ

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply