Suppose I have database backup file.
Can I create a new database(different than the database whose backup it is) and restore the backup into newly created database.
I'm having a backup file of some database, I want to create database from it. Suggest any way to do it?
ThxThat's the way to do it. Just be sure when you restore it, you give it a new database name and make sure the option to 'Force restore over existing database' is not turned on. You don't have to create the database first; it'll create it for you with the name you provide.
If you are restoring to a different server, you'll probably have to run sp_change_users_login to adjust the logins. If restoring to the same server, you won't have to.|||I have to restore it to a different server. I have all the login/passwords of both servers.
Can u gimme details of this sp_change_users_login?
Thx for ur reply|||Books on Line has all the details.|||Got it!
Thx for your help mate!
No comments:
Post a Comment