Showing posts with label restoring. Show all posts
Showing posts with label restoring. Show all posts

Thursday, March 8, 2012

Another Login after restoring database

Hello all,
I have created a backup of a database and Restored as a new database in another machine.
Primary login of the database was X , now after restoring as a new database I dont want X as the login name i want it to be Y ...
how to do that ?

I can create other login as y and Give necessary premissions...but the Problem is i have to manually issue all the permissions to the new user which i feel is a time taking process.

Please let me know about it..

Thanks and Regards
saiI am not sure but u can try this :
script the login and user for the database in question,after generating the script for the user X,delete the the user X from the database ,Replace the user/login name X from the script with Y and run the script on the database.
I think this should work after some enhancements in the script.|||Use roles!

Or sp_change_users_login SP

Sunday, February 12, 2012

Analysis services backup and restore problem.

I'm backing up an analysis services database to an abf file and then restoring it to another database, with a different name, on the same server. However, when I process the database that I originally backed up, the cubes in the restored database are deleted?

I can only think that the objects in the database have a unique identifier and these are the same in both databases, and when I process the original database it's deleting both sets of cubes, but only rebuilding the ones in the database I'm processing.

The only way that I can think of out of this is to restore the database to another server, which I don't want to do.

Any ideas would be much appreciated.

This sounds like a bug. There is a special code during restore which is supposed to change the unique ids you refer to in order for them to stay unique. Sounds like for whatever reason in your scenario this code doesn't work.