[SQL 2012] Always on Secondry database backup plan & Recovering. |
| Always on Secondry database backup plan & Recovering. Posted: 08 Mar 2013 11:14 PM PST Hi All,Can any one suggest me one good backup plan for Always on secondaries server... ?Currently i am planning to doOne Full copy only backup--- Every 24 hour :Every 30 min Log backup.I am looking for the solution for recovering the database using this backup strategy. |
| How to dynamically determine which partitions to process? Posted: 08 Mar 2013 06:40 AM PST Hello,I have a Tabular model with a partitioned fact table based on date field. I have data in there from jan 1 to jan 10 partitioned daily..thus 10 partitions.I now want to process the cube because I have new data for the 11th coming in.My questions are;1) How do I dynamically ask SSAS to create a fresh partition for day 11?2) How do I ask SSAS to process partition 11 ONLY.Thanks |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General 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