I don't think I was clear in my original post. There are a lot of databases & users for this SQL Server installation. Before the re-install what do I need to do in order to backup the users & permissions for all the databases? Do I just backup the Master database or maybe if I backup the correct configuration database(s), then I won't need to re-attached any of the databases, clean up orphaned users, and/or manually add back all the users & their permissions.
Thanks, Stan
>Is there an easy way to backup and restore the users for SQL Server 2000? I
>will be rebuilding a server soon running SQL Server and I don't want to
>manually clean up the orphaned users when I reattached the database, and
>then manually add all the users and set permissions. There must be an easy
>way to just backup and restore the users & permissions.
[
Todays Threads]
[
This Message]
[
Subscription]
[
Fast Unsubscribe]
[
User Settings]
![]()
