January 8, 2010 at 4:15 pm
Hi Seniors...,
My issues were like one of our staging server gone and luckily I have all the backups of sys dbs and user dbs.
My manager asked me to rebuild on another server.
Please tell me the process to rebuild the server as it was working earlier and we have so many of SSIS packages and replication settings and maintenance plans were there.
Thanks in advance
Kris
January 8, 2010 at 4:28 pm
this will be a lot easier if you can name the server the same as the original, especially as you have replication.
build server with same name
install SQL exactly the same as on original server (same directory locations, patch level)
restore master database and msdb, model as well if you have made amendments to that
restore user databases
that should retrieve your set up exactly as was.
depending on state of replication at time of loss of server, you may need to reinitialise replication.
the local accounts that SQL creates on install I think will be orphaned, if so drop and recreate them by scripting out.
---------------------------------------------------------------------
January 8, 2010 at 5:15 pm
Thanks George........ 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply