[SQL 2012] SQL Server 2012 HA on Server 2008 R2 vs. Server 2012

---

• SQL Server 2012 HA on Server 2008 R2 vs. Server 2012
• Audit the Audit settings changes
• Question regarding staging tables and fact tables for a Data Warehouse in a sql server 2012 database
• Shall I Stop the jobs when SQL in recovery Mode?
• sql 2012 hosting
• SQL Server 2012 installatione woes

SQL Server 2012 HA on Server 2008 R2 vs. Server 2012 Posted: 16 May 2013 03:10 AM PDT I am planning for the update from SQL Server 2008 R2 to SQL Server 2012. I've read some accounts of differences between running Always On and WSFC on the older version of the OS vs. the newer. NB: I *am* trying to get a comment on this directly from Microsoft, but they're not being responsive so far. I am alo taking a Microsoft training course that purports to cover HA, but the references are superficial re this question.The concerns revolve around updates to the database(s) on the servers in an Always On Availability Group. Are there substantial differences between the steps to patch SQL Server 2012 running on multiple machines supporting multiple DB's when it's running on Server 2008 vs. Server 2012? Our primary enterprise application, which would *definitely* be in an Availability Group, gets 4 business critical updates a year. Two of those are often taken under operating season pressures such that I don't want to add complexity that could be avoided. Are there substantial differences between the steps required to install and promulgate a new DB version under different versions of the server OS? Note that, in all cases, the Availability Group will host at least two databases, but that only one of them will require major updates.Does anyone have enough hands on experience with AlWays On and WSFC to venture ideas? Any suggestions on where (official Microsoft?) sites/blogs/????) I might try for an authoritative answer?

Audit the Audit settings changes Posted: 16 May 2013 01:48 AM PDT I have a requirement from my customer to enable auditing, few at the server level and few at the database level.I have been successful in enabling the audit.Now, I have a question of we can audit the changes in the auditing configuration itself?For example..If someone deletes a particular setting in the audit properties, I want that to get logged too.Is it possible.

Question regarding staging tables and fact tables for a Data Warehouse in a sql server 2012 database Posted: 15 May 2013 04:27 AM PDT So I have a staging customer table that holds combined customer information for several different databases. All our customer information across different platforms is combined and standardized in this staging table. Based on this data - we normalize it and then either update the customer information in our Fact table if that customer already exists - or we insert a new customer record if that customer doesn't exist. Our current Fact table has 10+ million records in it. Our staging customer table has millions in it as well. I know these numbers aren't exactly big - but I am also planning for the future as well. So - my question is are there any 3rd party tools on the market that can help with the update and the inserts? Or is my only option scripting it all out in either a stored procedure or an SSIS package. I looked at Red gate's SQL compare - but it looks like it works better if you run it ad hoc. I am looking for something to create and then schedule it so it runs automatically. Any suggestions is greatly appreciated.

Shall I Stop the jobs when SQL in recovery Mode? Posted: 15 May 2013 05:29 PM PDT hi,i ran a job which is updating almost 300 GB database.now i see that the Db is in recovery mode. I know that I should wait till it recovers. [code="sql"]EXEC dbo.sp_stop_job N'jobname'[/code]says the job is not running, but the [code="sql"]SELECT *FROM msdb.dbo.sysjobs AS SJ INNER JOIN msdb.dbo.sysjobactivity AS SJA ON SJ.job_id = SJA.job_idWHERE SJ.enabled = 1 AND NOT SJA.start_execution_date IS NULL AND SJA.stop_execution_date IS NULL[/code]gives two records...[code="sql"]DBCC CHECKDB[/code] says, deffered transactions are there.Any help would be highly appreciated...Thanks,Regards,Ami

sql 2012 hosting Posted: 15 May 2013 01:47 PM PDT Can anyone provide links for hosting of a small sql 2012 (Business Intelligence - Tabular mode) server of 2GB memory, 1GB of HHD space and medium CPU power? Any hosts around the asia-pacific area is recommended, who are the names you can trust these days? Thanks.

SQL Server 2012 installatione woes Posted: 15 May 2013 07:10 AM PDT Ok the following features are having issues when I do the installation (SQL Server 2012 dev on Windows 8 Pro)Reporting Services NativeDatabase Engine ServiceDQSFull Text and Semantic Extraction for SearchSQL Server ReplicationListed the message for database engine below. On the way through the installation there was an error message that said"Wait on database engine recovery handle failed. Check the SQL Server error log for potential causes.Action required:Use the following information to resolve the error, uninstall this feature, and then run the setup process again.Feature failure reason:An error occurred during the setup process of the feature.Error details:§ Error installing SQL Server Database Engine Services Instance FeaturesWait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.Error code: 0x851A001AVisit http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=11.0.3128.0&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026&EvtType=0xD15B4EB2%400x4BDAF9BA%401306%4026 to get help on troubleshooting.Any suggestions gratefully received. This is like the hundredth time I have tried to install SQL Server.Oh and I have disabled the firewall.CheersE:sick:

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