SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 SQL Server 2008 User		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

i2865
Starting Member

3 Posts
Posted - 07/09/2012 :  22:29:01  Show Profile  Reply with Quote
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)

USA
6997 Posts
Posted - 07/10/2012 :  00:39:46  Show Profile  Reply with Quote
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
Edited by - Michael Valentine Jones on 07/10/2012 00:42:29
Go to Top of Page

i2865
Starting Member

3 Posts
Posted - 07/10/2012 :  21:25:25  Show Profile  Reply with Quote
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?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35007 Posts
Posted - 07/10/2012 :  21:35:52  Show Profile  Visit tkizer's Homepage  Reply with Quote
This is what we used and I wrote to transfer the logins: http://weblogs.sqlteam.com/tarad/archive/2008/06/24/How-to-transfer-SQL-logins-between-SQL-Server-2005-instances.aspx

I can't imagine you have that many email profiles to warrant a fancy script.


Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000