If you will be running SQL2000 on both servers just make sure they are both on the same SP level and the only thing you need to do is restore the master database. Then when you restore the individual databases everything will work just fine. We have done that here several times without a problem.
______________________________________________________
<file:///E:/EUColor.gif>
Bill Grover
Manager, Information Systems Phone: 301.424.3300 x3324
EU Services, Inc. FAX: 301.424.3696
649 North Horners Lane E-Mail: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
Rockville, MD 20850-1299 WWW: <http://www.euservices.com/> http://www.euservices.com
______________________________________________________
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 08, 2004 10:09 PM
To: CF-Talk
Subject: RE: Backup SQL Server Users
> 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.
You might find this useful:
http://support.microsoft.com/?id=246133
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
