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 |
|
N-IGMA
Starting Member
7 Posts |
 Posted - 2004-11-19 : 05:40:38
|
| Hi,I need to re-install our production SQL Server (v 7.0) and have a question...I am clear about the backup and restoring of databases including orphaned users, however how do I backup the server itself? I mean all the logins that will need adding, jobs, maintenance plans, operators, etc... My SQL manual only gives details about about backing up/restoring databases, can anyone point me in the direction of any documentation on this issue?TIA- Phil. |
|
|
cipfaadmin
Starting Member
6 Posts |
Posted - 2004-11-19 : 06:36:35
|
| Phil, are you taking backups of the masterdb, model, etc.. because that is where all such information is held. |
 |
|
|
N-IGMA
Starting Member
7 Posts |
Posted - 2004-11-19 : 06:48:54
|
| Thought that may be the case but wasn't 100% sure. Just to clarify then, all operators, logins, jobs, etc.. are in master, model & msdb databases?Thanks.- Phil. |
|
|
|
cipfaadmin
Starting Member
6 Posts |
Posted - 2004-11-19 : 07:50:59
|
| That seem to be about it phil |
|
|
|
|
|
|
|
|
Backing up server