[MS SQL Server] Which system tables save permissions and SQL server configuration |
| Which system tables save permissions and SQL server configuration Posted: 23 Sep 2013 04:44 AM PDT I need to add rights and permissions data to SQL source control. Which system tables from master/model/msdb do I need to link to source control in SQL Server 2008 and 2012.I also want to save data related to SQL server configuration like Cost Threshold for parallelism and Max Degree of Parallelism in SQL source control, so that I can track changes. Which tables do I need to link to source control.Thank You. |
| Posted: 22 Sep 2013 08:09 PM PDT Hi, This is Damodar. My question is on Log Shipping, I have to reverse the log shipping from DR to Production during DR Test. How can i do that without taking full backup on DR and apply it on Production. Because, taking full backup, moving to Production Server will take lot of time. So, inorder to reduce, is there any alternative to reverse log shipping without any more backups (Full or Differential). Please share if you have knowledge on this. Thanks. |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment