Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2003
    Posts
    4

    Unanswered: Saving and restoring configuration

    Hi all,

    I have an SQL Server 7 machine which took me a while to get set up correctly. I have it fully documented in case I need to rebuild it but I'd like to have a (semi) automated rebuild procedure. Ideally this would involve me manually building the Windows and basic SQL Server installatoin then applying my SQL Server configuration on top. I can't use GHOST for various reasons.

    I know that I can generate SQL scripts for various parts of the SQL Server configuration but does anyone know of a tool/utility which will help me do this?

    TA,

    H.

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    May check tools from Redgate website.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Apr 2003
    Posts
    4
    Thanks for the tip

  4. #4
    Join Date
    Apr 2003
    Posts
    4
    Hi,

    the Red Gates stuff identifies differences (via the DTS Compare tool) but doesn't create a script of any sort.

    Any other ideas anyone?

    H.

  5. #5
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Check this article to create own unattended installation files for SQL Server configuration apart from generating SQL scripts.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •