Help me... i need to reload my cluster server running SQL Server 2000!!!

  • We have to reload a server running SQL Server 2000. I will have to reinstall SQL Server, recreate all the databases, jobs, packages, logins, schedules and so on after the reload.

    What will be the easiest way to achive this?

  • GG:

          You'll need to begin by scripting out all your tables, views, stored procedures, DTS packages, etc.  Look at Books OnLiine and other sources about recreating users and passwords. Decide whether you want to deatch and reattach your databases, or restore from a backup. If your DTS packages are really large you may run into some problems when it comes to recreating them. There are some good articles on this in addtion to Books OnLine so plan to do a bit of reading before you begin creating your plan.

    Good Luck,

    Ross

  • Thank yo, Ross.

    A backup of master, msdb, model and tempdb isn´t enough to prevent lost of data?

Viewing 3 posts - 1 through 2 (of 2 total)

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