Master.dbf restore problems.

Over the weekend we did a hardware upgrade to our DB
server and some drives did change. We have setup most of
the DB back again, but the security is still in the
master.mdf file. If we restore this file back we will
loose everything that is working now. anyone know how to
export the security tables without blowing everything away
again.
ThanksAlex,
That is a situation where it really pays to test first<g>. Here are some
links that may be of interest:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
Andrew J. Kelly
SQL Server MVP
"Alex" <alex.chadwick@.cma.ca> wrote in message
news:032a01c33f37$3aa37d50$a101280a@.phx.gbl...
> Over the weekend we did a hardware upgrade to our DB
> server and some drives did change. We have setup most of
> the DB back again, but the security is still in the
> master.mdf file. If we restore this file back we will
> loose everything that is working now. anyone know how to
> export the security tables without blowing everything away
> again.
> Thanks