Recent IT Questions

1 - 17 of 17
<<PREVIOUS 1 NEXT>>

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...

View Answer   |  Jun 25 2009  4:23 PM GMT
SQL Server 2005 connectivity, Failover, DSN
asked by SQL Server Ask the Experts

  2420 pts.

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

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

asked by SQL Server Ask the Experts

  2420 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?

View Answer   |  Feb 27 2009  3:34 PM GMT
SQL Server 2005, Database mirroring, VPN routers
asked by SQL Server Ask the Experts

  2420 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...

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 but Im in a realy bad...

View Answer   |  Dec 14 2008  11:21 AM GMT
Database mirroring, SQL Server 2005, SBS
asked by Bljahvljah

  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...

asked by SQL Server Ask the Experts

  2420 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?

View Answer   |  Nov 24 2008  7:53 PM GMT
Failover, Mirroring, Database mirroring
asked by SQL Server Ask the Experts

  2420 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 helpful. thanks

View Answer   |  Oct 1 2008  3:26 AM GMT
AS/400, iSeries, Data mirroring
asked by Rockleadme

  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 difficult to achieve ......how about end of day?...

View Answer   |  Sep 11 2008  5:58 AM GMT
Mirroring, Database mirroring
asked by Rockleadme

  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...

View Answer   |  Sep 10 2008  10:14 PM GMT
Database mirroring, SQL Server 2005, SSMS
asked by Theitman

  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...

View Answer   |  Sep 2 2008  6:59 PM GMT
TCP, Database mirroring, SQL Server 2005
asked by SQL Server Ask the Experts

  2420 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...

View Answer   |  Sep 2 2008  5:47 PM GMT
Database mirroring, SQL Server 2005, SQL Server errors
asked by SQL Server Ask the Experts

  2420 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.

View Answer   |  Aug 5 2008  6:34 AM GMT
Database mirroring, SQL Server 2005, High-Safety Mode
asked by ITHULK

  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 ...

Answer Question   |  Aug 1 2008  8:19 AM GMT
Database mirroring
asked by ITHULK

  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.

View Answer   |  May 7 2008  4:12 PM GMT
Database mirroring, SQL Server 2005, SQL Server alerts
asked by SQL Server Ask the Experts

  2420 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...

View Answer   |  Apr 1 2008  11:46 AM GMT
SQL Server, Database mirroring, SQL Server 2005
asked by Cmrhema

  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, how do I make sure...

View Answer   |  Mar 11 2008  10:04 PM GMT
Disaster Recovery, SQL Server 2000, Database mirroring
asked by SQL Server Ask the Experts

  2420 pts.

1 - 17 of 17
<<PREVIOUS 1 NEXT>>