No announcements
Filter
:
All threads
All threads
Answered
Unanswered
Proposed answers
General discussion
No replies
Helpful
Has code
All languages
-
Unanswered0Votes
Database Mirroring in suspended mode
Hi, I am using sql server 2005 (Enterprise Edition, 64 bit) with sp4 and i have configured Database mirroring for 10 databases on a sql server instance. One of my ...4 Replies | 107 Views | Created by Neeraj Bhandari - Friday, July 19, 2013 3:33 PM | Last reply PrinceLucifer - 15 hours 35 minutes ago -
Proposed1Votes
database mirroing internal
please explain actual (internal) process in sql server for database mirroring.6 Replies | 129 Views | Created by viru1501 - Thursday, July 18, 2013 4:11 PM | Last reply Uri Dimant - Sunday, July 21, 2013 8:43 AM -
Answered0Votes
Will the mirroring will be able to work properly if restricted growth or change the setting of max size of database
I have a mirror database. they are set to unrestricted growth. As per company policy the database should be in restricted growth. should I change it to ...8 Replies | 203 Views | Created by Ajay.G - Friday, July 12, 2013 3:44 PM | Last reply PrinceLucifer - Friday, July 19, 2013 4:25 PM -
Answered0Votes
Creating backups in a mirror configuration
Good afternoon! Forgive me if I don't have the correct terminology; I'm quite new and I'll try my best! I currently have two SQL servers ("SQL1" and "SQL2"). ...2 Replies | 148 Views | Created by Catherine Lam - Friday, July 12, 2013 5:26 PM | Last reply Catherine Lam - Thursday, July 18, 2013 1:37 PM -
Answered1Votes
restoreing database for mirroring
i have 123Gig of database, i am trying to setup mirroring for it. we take full backup every week and diff backup every ...4 Replies | 146 Views | Created by '''HuuM''' - Monday, July 15, 2013 12:52 AM | Last reply '''HuuM''' - Monday, July 15, 2013 1:55 PM -
Unanswered1Votes
status disconnected
Hi, The sql 2008 R2 sp2 high performance mirroring became disconnected. It seems was caused by mirror server restarted. The mirroring settings was on port 5022. ...6 Replies | 541 Views | Created by hommer - Wednesday, June 05, 2013 9:46 PM | Last reply Pradeep_DBA - Monday, July 15, 2013 12:02 PM -
Answered1Votes
¿Cuál es la diferencia entre Mirroring y Replicacion en SQL Server 2008?
Hola buenas tardes, mi duda es cual es la diferencia entre esos dos tipos de replicacion hablando de alta disponibilidad y cual recomendarian y porque, tambien si es posible alguien pueda proporcionar ...1 Replies | 132 Views | Created by carlosadrr - Thursday, July 11, 2013 4:47 PM | Last reply Ahearn_Fernando - Friday, July 12, 2013 3:57 PM -
Answered1Votes
Log Shipping Not Working
I have been trying to setup Log Shipping between two servers in our domain. I have followed the steps in the documentation, but the final step of restoring the transaction logs on the Secondary Server ...3 Replies | 164 Views | Created by jonsuns7 - Wednesday, July 10, 2013 12:12 AM | Last reply Neha Mahajan DBA - Wednesday, July 10, 2013 12:53 PM -
Answered0Votes
Mirroring from NYC to LA?
Can you mirror a database from NYC to LA? What kind of communications setup? Thanks. Kalman Toth Database & OLAP Architect ...5 Replies | 170 Views | Created by Kalman Toth - Tuesday, July 09, 2013 4:53 PM | Last reply Tom Phillips - Tuesday, July 09, 2013 7:39 PM -
Answered1Votes
Database Mirrroring in MS 2000 server
Just want to know whether Database mirroring available in SQL server 2000. I am sure it is available from 2005.3 Replies | 175 Views | Created by kccrga - Monday, July 08, 2013 11:58 PM | Last reply Srinivasan Ram - Tuesday, July 09, 2013 6:41 AM -
Proposed0Votes
Issue with mirroring error 845, status 1, severity 17
I have high performance(asynchronous) mirroring setup. The principal database went to (Primary, Suspended) Mode. The SQL Server Build is 10.0.4266. The error I got in the principal server ...2 Replies | 231 Views | Created by Shanoof Basheer - Tuesday, July 02, 2013 1:33 PM | Last reply Devashish_Salgaonkar - Friday, July 05, 2013 7:26 AM -
Answered0Votes
TCP Ports Required between Servers for SQL Copy Database Wizard
I want to copy a database from a server running SQL 2005 to a different server running SQL 2012 using the SQL Copy Database Wizard. The servers are on different networks separated by firewalls. ...2 Replies | 191 Views | Created by mteigman - Wednesday, July 03, 2013 6:57 PM | Last reply Uri Dimant - Thursday, July 04, 2013 5:12 AM -
Answered1Votes
Database Mirroring - Witness or No Witness
Hi, I'm using SQL Server 2008 r2 mirroring in our SharePoint 2010 environment. I'm trying to weigh up the benefits of whether I should use a witness server or not. We ...6 Replies | 269 Views | Created by Cammie Watson - Friday, June 28, 2013 10:02 AM | Last reply SQL24 - Tuesday, July 02, 2013 2:10 PM -
Answered0Votes
Resources on Principal and Mirror servers
Hi, Could we assign less RAM resources to Mirror server instance then to Principal server instance? We are using High Availability mode without Witness. Also we only need ...3 Replies | 239 Views | Created by pikul - Saturday, June 29, 2013 7:56 AM | Last reply Uri Dimant - Monday, July 01, 2013 5:05 AM -
Answered1Votes
what are the critical issues in your career in log shiping, backups, clustering , how can you resolved ?
Hi frnds... Greetings.! in advance. what are the common issues in fail over clustering . i went today ...1 Replies | 225 Views | Created by vijay_1234 - Friday, June 28, 2013 2:20 PM | Last reply Uri Dimant - Sunday, June 30, 2013 5:46 AM -
Answered0Votes
Can I shrink the database for database mirroring
Hi All, Currently I am having a database with size 130GB and mirroring had been set. There are some tables which would like to be deleted and can I know whether I can free up ...7 Replies | 308 Views | Created by Harn - Monday, June 24, 2013 11:49 PM | Last reply Harn - Wednesday, June 26, 2013 11:41 PM -
Answered0Votes
SQL SERVER 2008 Standard Edition Asynchronous mirroring happening
Hi I am having MS SQL 2008 R2 SP2 (10.50.4000) of standard edition installed on MS Windows 2008R2 Standard OS. I am implementing Mirroring. Mirroring ...7 Replies | 290 Views | Created by Tushar Nemade - Monday, June 24, 2013 9:33 AM | Last reply Tushar Nemade - Tuesday, June 25, 2013 7:41 AM -
Answered1Votes
Unable to connect to Witness after hardware failure (SQL 2005)
Hi All, I do have 4 production servers for mirroring and 1 witness server as information below and all are working fine :- (Principal : SQL2 , Mirror ...4 Replies | 294 Views | Created by Harn - Wednesday, June 19, 2013 12:07 AM | Last reply Harn - Monday, June 24, 2013 11:44 PM -
Answered0Votes
An error occured while starting mirroring
An error occurred while starting mirroring. Additional information: Alter failed for Database "besmgmt" (Microsoft.sqlserver.smo) An ...2 Replies | 290 Views | Created by N Anil Kumar [MCITP] - Sunday, June 23, 2013 2:51 AM | Last reply N Anil Kumar [MCITP] - Monday, June 24, 2013 11:17 AM -
Answered4Votes
Recommended process for patching windows server when using SQL Server mirroring
We are setting up 3 nodes with 2008 R2 SQL Server instances - one is a principal instance, one is a mirror, and one is a witness. We wish to use this configuration to increase ...5 Replies | 327 Views | Created by pellet88 - Thursday, June 20, 2013 11:19 AM | Last reply Neha Mahajan DBA - Saturday, June 22, 2013 9:12 AM - Items 1 to 20 of 1962 Next ›