SQL Server 2012 High Availability and Disaster Recovery (Pre-Release) announcement
-
Link
Welcome to the SQL Server "Denali" AlwaysOn forum for high availability and disaster recovery. The SQL Server product team actively monitors and responds to this forum.
To report any bugs or provide suggestions, please vote on or file items through Microsft Connect: https://connect.microsoft.com/sqlserver
See the SQL Server "Denali" AlwaysOn Resource Center for more information: http://msdn.microsoft.com/en-us/sqlserver/gg490638(en-us,MSDN.10)
Found 46 threads
-
0 VotesAdd artilce in replication
How to add article or table in publication? How to snapshot the only one particular article?Proposed | 2 Replies | 10346 Views | Created by johnny201186 - Sunday, November 13, 2011 6:28 PM | Last reply by Brandon Williams - Tuesday, December 27, 2011 4:21 AM
-
1 Votes
SQL server 2012 configuration tools on servercore ?
Hi I succesfully installed SQL 2012 RC on Windows 2008 R2 server core. How can I configure the SQL-server configuration tools on a ...Answered | 2 Replies | 11128 Views | Created by David De Vos - Wednesday, December 7, 2011 8:41 AM | Last reply by David De Vos - Thursday, December 8, 2011 1:21 PM -
0 Votes
Keep seeing 'AG currently does not allow read only connections'
sqlcmd -S SQL11FC1 -K ReadOnly -d AdventureWorks2008R2 -q "SELECT ...Answered | 2 Replies | 10305 Views | Created by xlegend1024 - Monday, December 5, 2011 2:00 PM | Last reply by xlegend1024 - Wednesday, December 7, 2011 8:33 AM -
1 Votes
SQL Server Denali and FileStream
Does the FileStream in SQL Server Denali support mirroring. Also, there is another new word these days called "Always on" .... so does the FileStream object support ...Answered | 1 Replies | 11667 Views | Created by MSDN Student - Tuesday, November 22, 2011 2:45 PM | Last reply by PrinceLucifer - Wednesday, November 23, 2011 7:19 AM -
0 Votes
Readonly Routing List is not working in AlwaysOn feature
Hi All, We are exlploring off loading the Readonly operations on AlwaysOn setup. We currently have a AlwaysOn set up on 1 Primary(AlwaysOn1Serv1) & 2 active ...Proposed | 12 Replies | 18909 Views | Created by Gnreddy - Thursday, November 10, 2011 7:10 AM | Last reply by Goden Yao[MSFT] - Wednesday, November 16, 2011 5:58 PM -
0 Votes
Backup Priority On AlwaysOn Feature
Hi All, I have the below set up. Availability Group Name: AlwaysOnAVG Databases: AlwaysOnDB1 & ...Answered | 4 Replies | 11571 Views | Created by Gnreddy - Friday, November 11, 2011 9:32 AM | Last reply by Gnreddy - Tuesday, November 15, 2011 2:20 AM -
0 Votes
Logshipping network shared folder chainged
Hi, I have one doubt. 1)While running Logshipping can we chainge the network folder one disk to another disk? 2)Is it any effect of logshipping ...Unanswered | 1 Replies | 10124 Views | Created by johnny201186 - Sunday, November 13, 2011 6:23 PM | Last reply by PrinceLucifer - Monday, November 14, 2011 6:23 AM -
0 Votes
how to move the user databases to another disk
How to move system databases and user databases one disk to another disk?Unanswered | 1 Replies | 10211 Views | Created by johnny201186 - Sunday, November 13, 2011 6:31 PM | Last reply by PrinceLucifer - Monday, November 14, 2011 6:20 AM -
0 Votes
Can we log ship or mirror user databases between SQL08R2 and Denali, and recover them for reporting every so often?
I doubt this is an option as it would have to upgrade them on recovery/ standby, but I'd like a Denali DR and reporting DB of a SQL08R2 production database, and wondered if there were any known ...Unanswered | 4 Replies | 10767 Views | Created by Rob DBA Firth - Wednesday, November 2, 2011 4:33 PM | Last reply by Justin Erickson - Wednesday, November 2, 2011 9:30 PM -
0 Votes
Service live migration
Hi all, I wonder if in this new realise SQL Server, when is a clustered resource, can migrate between hosts without disruption of service. A sort of "live migration" as ...Answered | 1 Replies | 11859 Views | Created by Andrea Caldarone - Tuesday, October 11, 2011 12:29 PM | Last reply by Justin Erickson - Monday, October 31, 2011 9:08 PM -
0 Votes
TCP Connection gets disconnected after the replica failover
I'm working on setting up the AwlaysOn feature using Availablity Group. I have setup 3 nodes in WFC and setup three standalone SQL server instances and setup Availablity Group for two databases with ...Proposed | 1 Replies | 12602 Views | Created by DevB - Wednesday, October 12, 2011 5:34 PM | Last reply by PrinceLucifer - Monday, October 31, 2011 6:28 AM -
0 Votes
SQL Architecture
Hi all, I am new to the forums. I just setup denali in are laptop and I see it still uses MCS and Shared disks. This is not very helpful if you plan on using cloud computing. Denali's documentation ...Proposed | 2 Replies | 11921 Views | Created by j_man8046 - Tuesday, October 18, 2011 1:14 PM | Last reply by Allan Hirt - Sunday, October 30, 2011 10:29 PM -
0 Votes
Always On: our minimum config for us would be: one primary + 2 secondary readable...but how many servers to add to achive HA & DR at db level
Hi, Background: One server will host all db's for read/write for the apps. We need 1 SR for DW load and 1SR to service our external customer query data (will be a subset of 2 ...Proposed | 1 Replies | 11282 Views | Created by harald bach-gansmo - Thursday, October 20, 2011 3:47 PM | Last reply by Allan Hirt - Sunday, October 30, 2011 10:24 PM -
0 Votes
Why database has to be in Full recovery mode to be part of availability group?
Why database has to be in Full recovery mode to be part of availability group? Simple recovery mode is fine, because it does not have log backup, but what about database with bulk recovery model?Discussion | 1 Replies | 12337 Views | Created by Invinsible - Thursday, October 13, 2011 8:26 PM | Last reply by Szyper - Wednesday, October 19, 2011 9:57 PM -
0 Votes
SQL Server Denali Always ON (HADR) - Read Intent vs Read access
Hi, I have tested the SQL server Always ON feature from CTP3 download. everything working fine as excepted. now i need the detailed answer for the below ...Answered | 1 Replies | 16670 Views | Created by universal_beginner - Monday, September 19, 2011 10:29 AM | Last reply by Goden Yao[MSFT] - Tuesday, October 4, 2011 12:09 AM -
2 Votes
Setting up availability group
availability replicas is showing down. A dumb question, does the secondary instance need to have a DB in recovery mode just like when we create mirroring, for HADR to ...Answered | 7 Replies | 14899 Views | Created by weedsupport - Wednesday, August 31, 2011 9:50 PM | Last reply by weedsupport - Wednesday, September 7, 2011 1:27 PM -
2 Votes
Can you mix AlwaysOn Failover Cluster with AlwaysOn Availability Groups?
My goal is to have a standard 2-node, AlwaysOn Failover Cluster (shared storage) and then use Database Mirroring to replicate to a 3rd server (outside the cluster) and hopefully use the 3rd server as ...Answered | 5 Replies | 15254 Views | Created by David Bermingham - Sunday, August 28, 2011 10:09 PM | Last reply by Goden Yao[MSFT] - Monday, August 29, 2011 5:37 PM -
1 Votes
Setup isn't recognizing the Windows Server Cluster when creating Availibility Groups
Hi, I have a different problem with Availibility groups than the tread below: We have 2 VM's with Win Server 2008R2 and Denali. The 2 VM's are combined as one ...Answered | 2 Replies | 13469 Views | Created by Philipp.Rouaiha - Sunday, August 14, 2011 8:38 AM | Last reply by Philipp.Rouaiha - Thursday, August 18, 2011 9:01 AM -
0 Votes
Denali HADR read-only mirror while compatibility level is 100
Can I set up a HADR read-only mirror for a database that has its compatibility level set to 100?Answered | 2 Replies | 13199 Views | Created by WebStrands - Saturday, August 6, 2011 2:55 AM | Last reply by Goden Yao[MSFT] - Wednesday, August 10, 2011 2:13 AM -
1 Votes
Native Client 11.0 does not support connections to SQL Server2000 or earlier versions.
SQL Server “Denali” CTP3 Native Client 11.0 does not support connections to SQL Server2000 or earlier versions. Note: CTP3 downloaded on July 20th, ...Discussion | 2 Replies | 20772 Views | Created by Jay Marni - Wednesday, July 27, 2011 4:03 AM | Last reply by Jay Marni - Wednesday, August 3, 2011 3:58 AM
SQL Server 2012 High Availability and Disaster Recovery (Pre-Release) announcement
-
Link
Welcome to the SQL Server "Denali" AlwaysOn forum for high availability and disaster recovery. The SQL Server product team actively monitors and responds to this forum.
To report any bugs or provide suggestions, please vote on or file items through Microsft Connect: https://connect.microsoft.com/sqlserver
See the SQL Server "Denali" AlwaysOn Resource Center for more information: http://msdn.microsoft.com/en-us/sqlserver/gg490638(en-us,MSDN.10)
