No announcements
-
3 VotesWelcome to the SQL Server Disaster Recovery and Availability Forum
(Edited 8/14/2009 to correct links - Paul) Hello everyone and welcome to the SQL Server Disaster Recovery and Availability forum. The goal of this Forum is to offer a gathering ...Sticky | 6 Replies | 44467 Views | Created by Paul Randal - Saturday, June 3, 2006 4:25 PM | Last reply by seemaawashthi10 - Friday, November 7, 2014 11:33 AM
Found 6170 threads
-
0 Votes
SQL Server 2014 AG + Clustered Shared Volume
I am testing this scenario in a lab environment: Node 1 + Node 2 = Failover Instance Node 3 = Secondary Availability ...Unanswered | 2 Replies | 365 Views | Created by TikDBA - Monday, November 17, 2014 6:21 PM | Last reply by TikDBA - Wednesday, November 19, 2014 3:35 AM -
0 Votes
Setting Backups in Secondary Replica of AlwaysOn
As per the AlwaysOn functionality of Offloading backups, I have recently implemented AlwaysOn in our environemnt. In Secondary Server it supports only for COPY_ONLY. In this situation how can I ...Unanswered | 11 Replies | 418 Views | Created by E Prasad - Tuesday, November 18, 2014 3:48 PM | Last reply by E Prasad - Wednesday, November 19, 2014 2:45 AM -
1 Votes
Keep getting 1418 when attempting to mirror 2 databases
We have a server at one datacenter with Server 2012 standard and SQL Standard 2012 We have another server a a different datacenter with Server 2012 standard and SQL Standard ...Answered | 2 Replies | 739 Views | Created by juicejug1016 - Tuesday, November 18, 2014 10:28 PM | Last reply by juicejug1016 - Tuesday, November 18, 2014 11:39 PM -
0 Votes
SQL cluster and AlwaysOn availability group
Hi all, I have an interesting scenario. I run a 2 node cluster (Windows 2012) with SQL 2012 SP1, which uses a SAN. I need to create an availability group to have a set ...Answered | 4 Replies | 837 Views | Created by shageman0304 - Monday, June 2, 2014 5:26 PM | Last reply by aspnerd - Tuesday, November 18, 2014 7:37 PM -
0 Votes
Always On - How to use same drive letters on AG replicas?
I've read in a MS best practice that when setting up Always On Availability groups, the replicas should use the same database drive letters as the primary server. Given that replicas are required to ...Answered | 1 Replies | 440 Views | Created by chuckh1958 - Tuesday, November 18, 2014 6:22 PM | Last reply by davidbaxterbrowne - Tuesday, November 18, 2014 6:39 PM -
0 Votes
Moving SQL Servers to another network
Anyone know if I can easily move my sql servers and their replica's to another network with a different ip class? I will need to change the ip addresses of the machines and the listener. How ...Unanswered | 1 Replies | 368 Views | Created by jpro1000 - Tuesday, November 18, 2014 5:15 PM | Last reply by Sean Gallardy - Tuesday, November 18, 2014 5:43 PM -
0 Votes
SQL Server 2012 High Availability Storage Requirement For SCOM 2012 R2
First of all i have to tell u guys my scenario first of all I have two nodes of SQL server 2012 with windows server 2012 R2 with the new feature of Always On High Availability feature and the storage ...Unanswered | 1 Replies | 357 Views | Created by Syed Tauseef Ahmed - Tuesday, November 18, 2014 4:39 PM | Last reply by Sean Gallardy - Tuesday, November 18, 2014 5:39 PM -
0 Votes
Services configuration for sql server 2008r2 in a Windows Cluster
Hello, We have a Windows Server 2008 Cluster with Sql Server 2008r2 installed on node 2; when node 2 fails (we don't still know why, it's a 'bluescreen' long history), the service ...Answered | 1 Replies | 400 Views | Created by Roger Tranchez - Tuesday, November 18, 2014 4:28 PM | Last reply by davidbaxterbrowne - Tuesday, November 18, 2014 4:33 PM -
0 Votes
SQL Server 2012 failover cluster issue
Hello, I have setup SQL Server 2012 SE cluster environment on Windows Server 2008 R2 EE for our production. This is an Active Passive setup with just one instance. The environment ...Unanswered | 5 Replies | 413 Views | Created by SQLSPUser - Tuesday, November 18, 2014 2:34 AM | Last reply by SQLSPUser - Tuesday, November 18, 2014 4:32 PM -
1 Votes
Availability Group Database( secondary) went to Suspect mode. What is the solution?
Hi Folks, database went suspect mode in secondary server. ( sql 2012 SP1) 1. How to bring online,Is it possible withuot breaking primary. 2. ...Unanswered | 6 Replies | 440 Views | Created by vijay_1234 - Thursday, November 13, 2014 9:55 AM | Last reply by Thiruppathi thiru - Tuesday, November 18, 2014 10:24 AM -
0 Votes
Where to check failover history of Sql server in Cluster
Hello Experts. Where can I check history of failover of any of sql server instance in a cluster and how to know whether the failover happened was manual or automatic. To ...Unanswered | 3 Replies | 538 Views | Created by Prasant Pardesh - Monday, November 17, 2014 9:31 PM | Last reply by Donghui Li - Tuesday, November 18, 2014 10:03 AM -
0 Votes
DB mail not working in sql server 2005
Hi, from today i get following error on sql server 2005 Exception Type: ...Answered | 4 Replies | 458 Views | Created by AK9841 - Tuesday, November 11, 2014 2:56 PM | Last reply by Markwillium - Tuesday, November 18, 2014 3:41 AM -
0 Votes
SQL Server Cluster
We are trying to create a SQL Server Cluster for High Availability. We have 2 HP BL460c server with 8GB with Window Server 2012 R2 Datacenter Edition. I would be glad if someone can provide us with ...Proposed | 5 Replies | 389 Views | Created by Fazal Ur Rehman - Monday, November 17, 2014 11:12 AM | Last reply by Ashwin Menon - Monday, November 17, 2014 4:02 PM -
0 Votes
Always On Security
Is there a way to grant a SQL Server Login access to a listener while not granting access to the underlying nodes of the Availability Group? We have an 2-node (Synchronous) ...Proposed | 1 Replies | 400 Views | Created by rob_morrone - Monday, November 17, 2014 1:54 PM | Last reply by davidbaxterbrowne - Monday, November 17, 2014 2:01 PM -
0 Votes
Place Management Data Warehouse in an Availability Group
Is it possible to place the SQL Server Management Datawarehouse in an Availability Group in order to have high availability? If so, what happens during failover? Is there any extra ...Unanswered | 1 Replies | 399 Views | Created by NiborTrassam - Friday, November 14, 2014 12:55 PM | Last reply by Lydia Zhang - Monday, November 17, 2014 12:16 PM -
0 Votes
Installing SP3 at SQL Server 2008R2 Active-Passive Cluster (2 node)
Hi, I have 2 node SQLServer 2008R2 cluster where two separate instances ERP & APPS is running on each node separately. Every other node is passive to the node having the active ...Unanswered | 2 Replies | 453 Views | Created by Nadeem DBA - Monday, November 17, 2014 10:58 AM | Last reply by Nadeem DBA - Monday, November 17, 2014 12:07 PM -
0 Votes
Unable to Find SQL Agent
Hi There, We are using SQL Server 2012 and we would like to do create schedule for the SQL Backup. As I know, the backup is performed by the SQL Agent. However, ...Unanswered | 20 Replies | 553 Views | Created by Henry2050 - Friday, November 14, 2014 8:11 AM | Last reply by TiborK - Sunday, November 16, 2014 4:46 PM -
0 Votes
Rename SQL Instance
Is it possible to rename the SQL instance (Default/Named) in sql 2000/2005/2008/2008R2/2012?Proposed | 1 Replies | 400 Views | Created by S.Vijay Kumar - Sunday, November 16, 2014 2:11 AM | Last reply by Uri Dimant - Sunday, November 16, 2014 6:26 AM -
0 Votes
Is AlwaysOn Not Supported on SQL server 2012 Standard & Windows 2012 R2 Standard.
Guys, I was trying to enable AlwaysOn present in SQL Server Configuration Manager Prop. Software Details: SQL server 2012 Standard and OS is ...Proposed | 3 Replies | 396 Views | Created by Sadankumar - Saturday, November 15, 2014 7:37 AM | Last reply by RAJU RASAGOUNDER NZ - Saturday, November 15, 2014 10:15 AM -
0 Votes
Create High Availability Group - Validation failed
I encountered 'Checking Shared network location' error while working on the 'SQL Server 2012 AlwaysOn Availability Group' provided by the TechNet Virtual Labs. The error happened on Exercise 4, task ...Answered | 8 Replies | 4268 Views | Created by Pei Wai - Friday, May 3, 2013 12:10 PM | Last reply by Pratap Bontha - Saturday, November 15, 2014 4:03 AM - Items 1 to 20 of 6170 Next ›
No announcements
