Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bogey
Posting Yak Master
166 Posts |
 Posted - 2007-03-15 : 15:13:03
|
| Was not thinking today and forgot to script my users in my sql server 2005 database after I uninstalled the db. Here is what happened. I backed up all my databases including sysem databases and uninstalled sql 2005. I then took those backups and restored on another server. I now need a way to retrieve all those users. Can I restore the master to do this? The db is for development only.thanks. |
|
|
rlaubert
Yak Posting Veteran
96 Posts |
Posted - 2007-03-15 : 16:04:08
|
| Will have to be restored to a SQL2005 server. But then you can script the names. Install a copy of SQL on a test box, do your restore, script the users and uninstall SQL if needed.Raymond LaubertMCDBA, MCITP:Administration, MCT |
 |
|
|
|
|
|
How do I get my users from a master db backup?