No announcements
-
Sticky0VotesNew Top Support Solutions blog
Hello As part of our efforts to keep our communities informed about the most relevant content that address the top questions that we are getting in out forums and other support ...
-
Proposed0Votes
Database monitoring tools in Market
Hi, I are looking for a enterprise wide tool that monitor our sql server databases and other applicaitons and also the server that we those the applications ...3 Replies | 98 Views | Created by Nag1234 - Thursday, April 17, 2014 2:51 AM | Last reply by Uri Dimant - 12 hours 44 minutes ago -
Answered0Votes
SQL Server 2005: Monitoring Database Mirroring
Hi All, I use SQL Server 2005 with mirror enable. Are there anyway to check/monitor/verify whether all data at principal are transit to mirror serer ...6 Replies | 159 Views | Created by Pitou H - Wednesday, April 02, 2014 6:35 AM | Last reply by Shanky_621 - Wednesday, April 16, 2014 9:57 AM -
Unanswered0Votes
Expected Failover times, very slow
Hi, I have a 2014 SQL Mirror setup. The mirror is set up fine with a witness and auto failover. I am failing the database over and it is very quick, it appears as principal on the ...11 Replies | 158 Views | Created by Adam Cosby - Friday, April 04, 2014 12:25 AM | Last reply by Adam Cosby - Wednesday, April 16, 2014 6:28 AM -
Answered0Votes
Server Network Address on Clustered Instance
Hi, I am looking to configure database mirroring and as part of this need to specify the server network address. The primary instance is on a 2 node cluster and the mirror data base ...2 Replies | 254 Views | Created by AllyRussell - Sunday, April 13, 2014 8:47 PM | Last reply by AllyRussell - Monday, April 14, 2014 9:53 AM -
Answered0Votes
Index maintenance
How to create index maintenance jobs in DB mirroring, as it doesn't support bulk-recovery?4 Replies | 117 Views | Created by S.Vijay Kumar - Thursday, April 10, 2014 7:15 AM | Last reply by Prashanth Jayaram - Thursday, April 10, 2014 4:35 PM -
Proposed0Votes
The database is being closed before database mirroring is fully initialized
When I issue this command: ALTER DATABASE foo set PARTNER = 'TCP://10.3.3.1:1234' I get this error message: The ...8 Replies | 15398 Views | Created by MikeBlaszczak - Tuesday, June 12, 2007 12:30 AM | Last reply by Jackey Lin - Thursday, April 10, 2014 10:53 AM -
Answered1Votes
Existing SQL Cluster: Easiest Method to Move to new Datacenter
Although there are a few questions similar to mine, I didn't find anything with these special circumstances, so I'll try a new thread: We have an existing SQL 2008 Cluster with ...1 Replies | 81 Views | Created by VintageDon - Wednesday, April 09, 2014 5:38 PM | Last reply by Sofiya Li - Thursday, April 10, 2014 9:40 AM -
Unanswered0Votes
SqlServer high availability at instance level
We have a SqlServer 2008 R2 instance where application is able to create databases dynamically. I want to add the newly created databases into database mirroring/transaction log shipping ...4 Replies | 113 Views | Created by Akshay rawat - Wednesday, April 09, 2014 10:38 AM | Last reply by Uri Dimant - Wednesday, April 09, 2014 5:56 PM -
Answered1Votes
Steps to change SQL server service account in Mirroring setup
I want to change the service account of my both sql server services on which mirror is setup in live environment. What precautions & steps do i need to follow. please tell me in ...8 Replies | 331 Views | Created by Mayur-DEW - Monday, February 10, 2014 4:45 PM | Last reply by Shanky_621 - Monday, March 31, 2014 12:38 PM -
Answered0Votes
Change SQL server service account in live environment of Mirroring
I need to change sql server service account for both servers in live enviornment of database mirroring. please tell me what how to stop & start database mirroring as changing ...3 Replies | 181 Views | Created by Mayur-DEW - Friday, March 28, 2014 4:52 PM | Last reply by Shanky_621 - Friday, March 28, 2014 8:56 PM -
Answered0Votes
I tried when db_owner different but db chaining still work!
Hi experts, I got stuck on below strange situation: 1. On server01, I created DB_A, set its db_owner to 'sa', and turn its db_chaining ...1 Replies | 125 Views | Created by Edward Huang333 - Thursday, March 27, 2014 4:50 PM | Last reply by ABIGuy - Friday, March 28, 2014 6:17 AM -
Answered0Votes
SQL Server under Mirroring is not responding/throws timed out error
Guys, We have weird scenario after configuring DB Mirroring between two Servers. I have Primary with almost 300 databases with 32 GB RAM and Secondary with 64 GB ...5 Replies | 431 Views | Created by Sadankumar - Tuesday, March 25, 2014 7:48 AM | Last reply by Tracy Cai - Wednesday, March 26, 2014 4:54 AM -
Answered0Votes
Database Mirroring between two SQL Clusters
Hi i have two SQL Cluster each cluster consist from Two Node A and B Cluster one Node A and B Cluster Two Node A ...3 Replies | 250 Views | Created by x Ahmed Ali - Monday, March 24, 2014 7:14 AM | Last reply by Uri Dimant - Tuesday, March 25, 2014 5:58 AM -
Answered0Votes
Log_backup not cleared after backup
Hi, I have a 2008 SQL server, where the tlog kept on growing as there was no maintenance plan done. So, i took a full tlog backup so that the log size would reduce, but no ...3 Replies | 241 Views | Created by doineedanid - Sunday, March 23, 2014 8:25 PM | Last reply by RAJU RASAGOUNDER -- MSSQL DBA Consultant - Monday, March 24, 2014 12:38 AM -
Answered1Votes
unable to find Mirroring option in sql server 2008 R2 (SP1)
I have recently install 3 instances of SQL SERVER 2008 R2 and try to setup Mirroring but there is no mirroring option available on database property. I have then install SP1 as well. still ...17 Replies | 5831 Views | Created by Shamas Saeed - Wednesday, March 28, 2012 6:20 AM | Last reply by Akram DBA - Tuesday, March 18, 2014 11:41 PM -
Unanswered0Votes
Automatic failover doesn't failback to the first server if the second server is lost.
Hi Everybody, We use the database mirroring a lot in our product solutions and we have recently experienced a strange behaviour in our failover tests with ...8 Replies | 487 Views | Created by Sebastien Maindiaux - Friday, January 24, 2014 4:25 PM | Last reply by Sebastien Maindiaux - Tuesday, March 18, 2014 11:27 AM -
Answered0Votes
Database Mirroring from Windows Azure VM to On-premise Server
Hello, Is there any tutorial or step by step guide to implement Database Mirroring from Windows Azure VM to On-premise Server? I couldn't find it. I want to use database ...4 Replies | 312 Views | Created by tslin306 - Wednesday, March 12, 2014 4:42 AM | Last reply by tslin306 - Thursday, March 13, 2014 7:25 AM -
Answered0Votes
Do we get database mirroring impacted due to Day Light Saving?
Dear All, Do we get any impact on Database Mirroring or SQL agent job due to changes on day light saving time? Because, we configured database mirroring in our ...6 Replies | 418 Views | Created by mailatdinesh - Friday, March 07, 2014 5:42 AM | Last reply by Shanky_621 - Tuesday, March 11, 2014 9:14 PM -
Answered1Votes
Database Mirroring Login Accounts
I need to setup database mirroring between 2 separate SQL 2012 instances. The documentation states that if the 2 server instances are running under different user accounts then these need to be ...3 Replies | 183 Views | Created by AllyRussell - Monday, March 10, 2014 10:34 AM | Last reply by Shanky_621 - Monday, March 10, 2014 1:44 PM -
Answered0Votes
Moving mirror witness to pc on different domain
SqlServer.ConnectionInfo) The ALTER DATABASE command could not be sent to the remote server instance." Error 1456 I've tried using both ...1 Replies | 271 Views | Created by Mark150 - Friday, March 07, 2014 4:48 PM | Last reply by Tracy Cai - Monday, March 10, 2014 6:07 AM - Items 1 to 20 of 2135 Next ›
