June 19, 2008 at 2:58 am
We had a disk crash of our SQLserver and now I' m trying to restore everything.
I short explanation of our setup.
We use the C-drive for the OS, D- drive for the SQLserver installation, E-drive for the database files, F-drive for the transaction logs and Y drive for backup files.
C, D and E are configured as RAID5 and F as a mirror. Y is a network drive.
We had a crash of our RAID 5 configuration and after the rebuild the D and E drive were gone. We only have a backup to tape of the Y drive. I create a D and E drive and tried to install SQLServer again on D. I problem occurs because the installation told me that SQLserver already was installed. Uninstall was not possible because the information on D drive were missing. I decide to install a new instance, this was successful and after this I was able to uninstall SQLserver without warnings or error notifications.
After a reboot a reinstall SQLserver on the d-drive and restore all user databases (+/- 20) (these were running in full mode) just before the crash.
After this I tried to restore the master database (procedure get from microsoft.com) and get an error that the back up of the master does not belong the present instance.
So far as I can see I missed the user accounts and their privileges. I create a known user account without a problem but when I mapped this account to the user database it tells me that the account already exist in the user database.
My question is there any possibility to get the information about logins and their privileges out of the previous master database and how to proceed?
Regards
Bert
For information: I'm an experienced Oracle DBA with a minimum experience of SQLserver (this is my first recovery after a hardware crash of SQLserver)
June 19, 2008 at 4:16 am
Bert,
If you check each database, you will see under Security\Users a list of users, which will give you a clue what logins you will have to recreate. When you recreate the login, you will need to drop the user in the database before you can map the login to the database. Before deleting the user make a note of the permissions.
June 19, 2008 at 6:28 am
If you lookup sp_change_users_login in books online, in particular the Auto_fix option, which should allow you to create logins for the orphaned users in your restored user databases, This process should also fix the mapping between the db users and the server logins.
Gethyn Elliswww.gethynellis.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply