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 |
|
i2865
Starting Member
3 Posts |
 Posted - 2012-07-09 : 22:29:01
|
| Hi,Currently I'm using log shipping method to failover from backup server to live server. But how about those users and database email profile? It didn't copy from backup server to live server. Does this mean i need to create back one by one? Or anyway which i'm not aware?Anyone can help on my question?Thanks in advance. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2012-07-10 : 00:39:46
|
| Logins (not users) are in the master database and email profiles are in the msdb database, so you will have to create those on the server you are failing over to.You will have to do the same for jobs, DTS or SSIS packages, and linked servers.CODO ERGO SUM |
 |
|
|
i2865
Starting Member
3 Posts |
Posted - 2012-07-10 : 21:25:25
|
| Hi Michael,Thanks for the info.Create those Logins and Profiles manually one by one? If the Live server is down and can't access, we cannot copy from Live to Backup server. Is there any solution on this? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SQL Server 2008 User