Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gazzer 2004
Starting Member
12 Posts |
 Posted - 2004-08-05 : 04:59:42
|
| Hi all.Just a simple question really.We have two servers which are identical, both have Sql Server installed.If I wanted to restore a back-up onto the second server from the first, for whatever reason, what is the correct procedure.Is it as follows.1 - Create Database (not sure about this, does restoring a back-up also create the database)2 - Restore full back-up3 - Restore diff back-up4 - Restore any log files.But what about the master, msdb and model databases, do they also need restoring at the same time.Cheers |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-05 : 08:37:46
|
| 1. You don't need to create the database. The restore will do it for you.2. You should always restore the msdb database. It has your jobs and DTS packages. --After you restore it, you will need to change the originating_server field in sysjobs to the new server.3. Don't restore the model database, unless you've modified it on the source server.4. Don't normally restore the master database. You do need to get a copy of sp_help_revlogin though, which you can find by searching this site or www.microsoft.com. After you restore the databases, you need to run this permissions script on the master database of the source server. It gives you a permissions script that you then run on the destination server to sync up logins.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Back-Up & Restore quicky