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 |
|
precept
Starting Member
5 Posts |
 Posted - 2013-08-05 : 15:33:58
|
| Hello,I have setup log shipping for a couple of my databases (SQL 2008). I would like keep any additional logins created on the primary database in sync with the log shipping server. I would like to use the SSIS transfer logins task to accomplish this goal and run via a SQL Agent job. However, when I run the job I get the following error.[Transfer Logins Task] Error: Execution failed with the following error: "Database 'DBNAME' cannot be opened. It is in the middle of a restore.".I have the following settings on the task:AllLoginsFromSelectedDatabasesIf objects exist = SkipCopySids = TrueI understand the logins cant be added while the database is restoring. Is there anyway around this issue?Thx |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Log Shipping Transfer Logins