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 |
|
drman
Starting Member
38 Posts |
 Posted - 2003-01-30 : 09:14:59
|
| Our shop is relatively new to SQL, and therefore we are learning as we go.With the SQL Slammer out and about, we wanted to update our server to SP 3, but after reading some other user comments, we decided to hold off, stick with SP 2 and only run the updated security patch (MS02-061). We also verified that UDP port 1434 was closed on our firewalls.This brought up the issue of setting up a test environment for SP updates. We have backups of all the required databases (Master, MSDB, Model, and the user databases). We installed SQL on a test server. Next, we attempted to restore the Master database, but we were not successful. Here is what we tried:1. We issued SQLSERVR.EXE -C -M to start the default instance of SQL server in single-user mode. 2. We issued OSQL.EXE -U SA -P ***** -Q "RESTORE DATABASE MASTER FROM DISK = 'C:\BACKUP\MASTER.BAK'"This did not work...Am I even going in the correct direction??Any Help would be appreciated..Thanks in advance..DRMAN |
|
|
srf
Starting Member
42 Posts |
Posted - 2003-01-30 : 15:24:15
|
| On a test server you should only be restoring user databases. System databases are can be specific to a given server (they even store information like the server name), and you could screw things up quite a bit. |
 |
|
|
drman
Starting Member
38 Posts |
Posted - 2003-01-30 : 16:05:08
|
| Thanks for the response. My concern was that I have a half dozen dts packages installed that I also need to "RESTORE" to the test server. If the original server crashed, and I wanted to rebuild my SQL server on another box, how should I go about this? Without all of the details, could you point me in the right direction??? Would the DTS packages and jobs have to be setup all over again? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-30 : 16:12:21
|
| You can could save the DTS packages to your test server by going into the DTS package and doing a save as. Change the server name to your test server. You will then have to modify the DTS package so that the connections are to the test server.As far as a disaster scenario: if your server crashed, but you are able to bring it back online but say with different disks, you could then restore master, msdb, model, and the user databases. But you can not do this to another machine. You would have to setup all of the other things on the other machine. You can easily prepare for this by scripting out the jobs (just right click on the jobs in the sql server agent and generate the script). Probably the only thing that would be lost would be the user passwords, but that's only if you are using sql authentication for the users. |
|
|
|
|
|
|
|
|
rebuilding sql server from backups