Database mirroring Questions

1

Best practices of RAID configuration of StorEdge HDS 9960 and Oracle 10g R2
Hello, What are the best practices of RAID configuration of HDS 9960 storage and Oracle. Currently we are using now Mirroring RIAD 1+0 with 4 disks (2+2). will the second option of Mirroring 4+4 give us better performance than 2+2 disks? Thanks in advance. P.S. the Oracle instance is OLTP.

Answer Question   |  July 29, 2010  11:28 AM
Database mirroring, HDS 9960, OLTP in Oracle, Oracle 10g, RAID, RAID configuration
asked by:
5 pts.

Failover issues in a SQL Server 2005 mirrored database
I have a SQL Server 2005 mirrored database with a witness. Everything seems to be working OK but I am having problems in the instance a failover occurs. Once the primary server goes down, my access to the database continues normally once both servers are back up and running and the old mirror is left [...]

Answer Question   |  June 25, 2009  4:23 PM
Database mirroring, DSN, Failover, SQL Server 2005, SQL Server 2005 connectivity, SQL Server Database Mirroring
2,585 pts.

Do all versions of Microsoft SQL Server 2005 support database mirroring?
Do all versions of Microsoft SQL Server 2005 support database mirroring?

Answer Question   |  April 8, 2009  5:33 PM
Database mirroring, SQL Server 2005, SQL Server Database Mirroring
2,585 pts.

SQL Server 2005 database mirroring over a VPN router
Can SQL Server 2005 database mirroring work if the mirror server is to be in another building with the networks connected via VPN router?

Answer Question   |  February 27, 2009  3:34 PM
Database mirroring, SQL Server 2005, SQL Server database, SQL Server Database Mirroring, VPN routers
2,585 pts.

Database Mirror connection string in sql 2008
Hi All, I have three databases which i have configured mirror on sql server 2008 for all the databases. Manual Failover with one principal and mirror. (Witness planning in the future) Using Windows authentication (Since same login and pass, neither new endpoints are created and not certificate created) This is working smoothly. I have 7 [...]

Answer Question   |  February 13, 2009  7:30 PM
Database mirroring, SQL Server 2008, SQL Server Database Mirroring, SQL Server Mirroring
asked by:
GIG
240 pts.

SBS 2003, SQL Server 2005 and database mirroring
Hello! I m trying to get db mirroring to work between two sbs 2003 premium based sql (2005) servers. Am I just plain stupid or did I miss sth? And please dont tell me about traceflags becaouse they dont seem to have an effect on my … problem? Perhaps I came out as a bastard [...]

Answer Question   |  December 22, 2008  11:21 AM
Database mirroring, SBS, SBS 2003, SBS 2003 mirroring, Small Business Server 2003, SQL Server 2005, SQL Server 2005 mirroring
asked by:
30 pts.

Error message while implementing mirroring between two databases on separate servers
I’ve attempted to implement mirroring between two databases on separate servers. The database names are exactly the same but I’ve been receiving the following error: Alter failed for Database ‘databasename’. (Microsoft.SQLServer.Smo) An exception occurredwhile executing a Transact-SQL statement or batch. (Micrsoft.SqlServer.ConnectionInfo) The remote copy of database “databasename” does not exist. Check the database name and [...]

Answer Question   |  November 25, 2008  7:57 PM
Database mirroring, SQL Server databases, SQL Server errors
2,585 pts.

Accessing a mirror database without main database failover
How can I access my mirror database on a SQL Server without a main database failover?

Answer Question   |  November 25, 2008  7:53 PM
Database Failover, Database mirroring, Failover, Mirroring, SQL Server database
2,585 pts.

How to mirror two databases (PRD to DEV)?
HI, I am trying to mirror my DEV box data lib with Production box. Currently i am creating a save file and then i FTP it to DEV box and restore lib. Any other way to do this? FTP takes a lot of time to transfer so, any suggestions on fast transfers would also be [...]

Answer Question   |  October 3, 2008  3:26 AM
AS/400, AS/400 development, AS/400 FTP, Backup to Disk, Data mirroring, Database mirroring, iSeries
asked by:
385 pts.

Data mirroring
Hi Guys, Can any one tell me how can i keep two databases in sync? My problem : I have two boxes DEV and PROD and have a data library in each box. What i want is to keep my DEV data library in sync with the PROD real time. If real time is too [...]

Answer Question   |  October 3, 2008  5:58 AM
Database mirroring, Mirroring
asked by:
385 pts.

Moving SQL 2005 databases with no downtime between servers
We have 2 SQL 2005 servers and would like to move the database and the logins and passwords from server to server. I ran backup and restored the full database with no recovery mode which allow me to copy the transaction logs then I transfered the logons and ran sp_change_users_login to associate a server login [...]

Answer Question   |  September 11, 2008  10:14 PM
Database mirroring, Microsoft SQL Server Management Studio, SQL Server 2005, SSMS
asked by:
25 pts.

Lacking a FQDN during database mirroring on SQL Server 2005
I am trying to work with database mirroring on SQL Server 2005, and I keep receiving the error message, “One or more of the server network addresses lacks a fully qualified domain name (FQDN). Specify the FQDN for each server, and click Start Mirroring again.” I know that the syntax for a fully-qualified TCP address [...]

Answer Question   |  September 2, 2008  6:59 PM
Database mirroring, FQDN, SQL Server 2005, SQL Server errors, TCP
2,585 pts.

Error message during database mirroring on SQL Server 2005
I am trying to begin database mirroring in SQL Server 2005. I have Service Pack 2 installed, and I have three instances running. When I attempt to start mirroring, I receive the error message, “One or more of the server network addresses lacks a fully qualified domain name.” My network addresses are: TCP://Joe:5024 principal TCP://Joe:5025 [...]

Answer Question   |  September 3, 2008  5:47 PM
Database mirroring, SQL Server 2005, SQL Server errors
2,585 pts.

Creating Alert/Email when Automatic Failover Occurs In Sql-Server 2005
Hello All, I want to send email alert when aotomatic failover occurs in in Sql-Server 2005. I mirrored my database using High Safety with Automatic Failover option.

Answer Question   |  August 6, 2008  6:34 AM
Automatic failover, Database mirroring, High-Safety Mode, SQL Server 2005
asked by:
10 pts.

Creating Alert/Email when Automatic Failover Occurs
Hi All, I am novice database administrator. I mirrored the database successfully. Now i want to received an Alert/Email when the failover occurs On my principal server. I will be very helpful if you provide me explanation in very short way or step by step. Thanks in Advance Best Regards Prasanna S Chitale

Answer Question   |  August 1, 2008  8:19 AM
Database mirroring
asked by:
10 pts.

Is there a way to set up database mirroring in SQL Server 2005 to receive failover notification?
I’m setting up database mirroring in SQL Server 2005 Standard Edition and was wondering if there is a way for SQL Server to send me a notification of a failover and for it to automatically run a script when the mirror is brought online.

Answer Question   |  May 7, 2008  4:12 PM
Database mirroring, SQL Server 2005, SQL Server alerts
2,585 pts.

Problem occuring while performing Mirroring
Hi, I underwent the following Steps for creating a mirror in sql server 2005. 1. Downloaded and isntalled sp2 in principal,mirror as well as witness servers 2. Created a new database named it as FinalMirror 3. Right clicked on the database Tasks-backup-BackupType–Full–Ok created FinalMirror.bak 4. Right clicked on the database Tasks-backup-BackupType–Transactional Log–Ok created FinalMirror-Transaction Log [...]

Answer Question   |  April 18, 2008  11:46 AM
Database mirroring, SQL Server, SQL Server 2005
asked by:
5 pts.

Setting up database mirroring for disaster recovery in SQL Server
I am a SQL Server DBA and in the process of upgrading our SQL Server 2000 to SQL Server 2005. I’ll be using database mirroring for the disaster recovery in SQL Server. One question I have is once I failover to the mirror server and use it as a principal for a couple of days, [...]

Answer Question   |  March 12, 2008  10:04 PM
Database mirroring, Disaster Recovery, High Availability, SQL Server 2000, SQL Server 2005
2,585 pts.

1