In a SQL Server 2005 database that is replicated using log shipping, will changes to the following be automatically reflected in the replicated database?
- Tables
- Stored Procedures
- Views
- Fun开发者_如何转开发ctions
- Object-level permissions
- Database roles
With log shipping you end up with two identical databases, down to the last bit. Everything declared in the database gets shipped to the log shipping partner.
精彩评论