Post reply

How to find when an SQL instance was installed?

  • March 9, 2009 at 2:12 pm

    #128260

    Any input will be greatly appreciated.

  • March 9, 2009 at 2:21 pm

    #956393

    datecreated on installation folder? (/binn)

  • March 10, 2009 at 6:48 am

    #956730

    From install folder (Default: c:\Program Files\Microsoft SQL Server) \90\Setup Bootstrap\LOG\FilesContains log files. I just do a text search for the instance and look for the file like SQLSetupXXXX_ _SQL.log

  • March 10, 2009 at 10:04 am

    #956915

    Jamie:

    Thank you for your reply. You are right. A further question is:

    Can we find the information inside SQL Server instance?

    The reason why I ask is the setup log file has been removed.

  • March 10, 2009 at 10:08 am

    #956920

    you could use VBScript and the FileSystemObject with sp_OA procs to find the date.

    I'm not sure how else you can get this.

  • March 10, 2009 at 10:13 am

    #956927

    Steve:

    I got it. There are couple ways getting the created date.

    1. Using Scripting object;

    2. In the Windows, add the column.

    In my memory, there is a place (table) in SQL 2000, where we can find the installation date.

    Many thanks

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

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