August 17, 2011 at 4:02 pm
Hello, if I made a DDL change to a table in the primary database i.e change column data type or add a new column then my testing shows that these changes will be replicated in the log shipped secondary database.
I am just hoping for somebody to confirm this if possible?
Are their any changes that will not be log shipped - I think any logins, users or permissions are not??
thanks
August 17, 2011 at 9:44 pm
With log shipping, any change made to the primary database is applied to the secondard database. This means any DDL change, permission, users etc.
Logins are actually in the master database which cannot be log shipped. So, these are not copied to the secondary database.
If you add a login on the server that contains the primary database, you will also need to add it to the server that contains the secondary database. If the login is a SQL Server login, you will need to specify the SID for the login (this is used as the link between the login and the user)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply