• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 865
  • Last Modified:

Is log shipping DDL aware?

Is log shipping DDL aware?
0
xnmb
Asked:
xnmb
  • 3
1 Solution
 
SashPCommented:
Can I script log shipping?

No. Currently, it is not possible to script log shipping. The only supported means of setting up log shipping is through the wizard.

I am not sure if this is the question you are asking.  What are you trying to achieve?
0
 
SashPCommented:
0
 
xnmbAuthor Commented:
What i mean is, is log shipping capable of copying newly created or modified objects (e.g. change in table structure, new tables or SPs added, etc.) Is that possible?

Thanks.
0
 
SashPCommented:
Changes to the schema of tables sps etc are written to the sys tables within your db and as such these changes are capture in the transaction log.

So the answer to your question is YES.
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now