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 |
|
wardsan
Starting Member
48 Posts |
 Posted - 2004-07-02 : 03:39:42
|
| Folks,we are trying to setup replication using the EMC component SRDF. EMC have recommended that we create the system dbs i.e. master, model, msdb and tempdb on a local disk or a non-replicated SAN disk and the app databases on SAN disks (which will be replicated). Doing it this way, I am concerned about adding logins/users on the primary database. The users will be replicated across but the logins won't and therefore will have to be added manually on the failover server (on the odd occasion that it's brought up!) and resynced. Are there other scenarios that I should be concerned with? ThanksSandra |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-02 : 10:16:49
|
| You would also lose your jobs and DTS packages if you don't have the msdb database backed up. I would have a process in place to migrate any new logins using the sp_help_revlogin script. The msdb database should be replicated though.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
entries in system tables