May 11, 2007 at 8:00 am
I created a new "named" instance on the same box as the default instance, then restored from a tape backup an "older" version of the master db to the new "named" instance. It restored successfully, but then crashed and I can't retart this new instance. I think the problem is that the new master is pointing to the default server location for it's db's as noted in the error log files. How do I get this up and running so I can complete the restore of the other db's. I want to use this new "instance" as a test sever on my production box. Thanks for any help you can provide!
May 11, 2007 at 9:23 am
Personally, I wouldn't attempt to restore a backup of master on a new instance. I'd just install the named instance, restore backups of the user databases and recreate logins from scripts generated in the default instance. Sp_help_revlogin, found by searching MS Support Knowledge Base, can script out your logins with passwords.
If you really want to restore master, try it with 'WITH MOVE' to change the location of the database files. Also, I think you may have to restore a backup of msdb.
Greg
Greg
May 11, 2007 at 9:37 am
Thanks for the quick reply.
The server was completley rebuilt and the entire system and user db's have been restored and are up and running. But, I want to restore an older version of the master so I can compare to the current "newer" version because I think the current retored version was hacked/modified.
May 11, 2007 at 9:50 am
In that case, restore it as master_old or some other name, not as "master" on another instance. You just want the data in the tables, not the functionality.
May 11, 2007 at 10:01 am
Thanks..I want to see if any stored or extended procedures have been added to the new master. But I would also eventually want to set up a duplicate of the production sever as a new instance to be a test site. This must be possible, correct?
May 11, 2007 at 3:29 pm
Hey Steve,
Thanks..renaming was the only was to get the system and user db's restored to a new instance on the same server. This has acomplished the immediate task!
How can I now use the renamed system and user db's to make it a funtional instance for a test site to do my development without affecting the production instance?
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply