May 24, 2013 at 11:42 am
Can some one help me to find the server rebuild information... I am trying to find when the server has been rebuilt. We had some disaster and needed to rebuild the server. I forgot when did we rebuilt the server. Please help
May 24, 2013 at 12:44 pm
hydbadrose (5/24/2013)
Can some one help me to find the server rebuild information... I am trying to find when the server has been rebuilt. We had some disaster and needed to rebuild the server. I forgot when did we rebuilt the server. Please help
What exactly are you looking for? If you have to rebuild the server I don't see why it matters when the server was last built.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 24, 2013 at 1:04 pm
The rebuild date. I have to provide the incident report so i need the rebuilt date.
May 24, 2013 at 1:12 pm
hydbadrose (5/24/2013)
The rebuild date. I have to provide the incident report so i need the rebuilt date.
Ahh meaning you already rebuilt it and you need to know when. That makes total sense. Assuming it was complete rebuild (meaning completely fresh install of sql) you could look at the create date for msdb. There may be some other way of knowing for sure but I don't know one off the top of my head.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
May 24, 2013 at 1:20 pm
I aleady checked it and its not giving the exact date. I might restored the old msdb.
May 24, 2013 at 1:24 pm
The file date stamps on some of the installation logs maybe. Look around near the location of the SQL binaries, sure to be an install log file somewhere around there.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2013 at 1:33 pm
I did that already and its not giving me the expected date.Can you find out from event viewer you think?
May 24, 2013 at 1:37 pm
Maybe, if the rebuild was recent enough.
Install logs do show the correct date, as in the date the install was done. Make sure you're looking at the right logs.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 24, 2013 at 2:06 pm
I will- Thanks!
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply