Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    8

    Unanswered: Upgrading server...

    Hi All,

    We're about to upgrade/re-build our SQL server box.

    We have 2 apps which use the server (both fairly small), one uses NT security - the other uses SQL security.

    My question is, apart from our 2 databases, what else should we backup (and restore onto the new clean machine) so as to preserve the user logins for the app that uses SQL security (the other one's dead simple)? The app itself maintains the user details and creates the SQL logins (with passwords etc.) but I can't find a way to 're-create' them.

    Any help would be greatly appreciated.

    Thanks,

    John

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Upgrading server...

    DTS Packages, Scheduled Tasks, Configuration settings(if you changed the default), Link Servers, and Login IDs.

Posting Permissions

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