Hello (if the question is more appropriate for RackOverflow please let me know) I've setup SQL server mirroring, using 2 SQL server 2005 standard editions. When the application is being stressed, response times increase 10-fold. I've pinpointed this to the mirror, because pausing the mirror shows acceptable response times. What option...
We have a SQL 2005 database server which uses high safety (synchronous, no automatic failover, no witness) mirroring to keep our disaster recovery site in a sort of warm standby. I was about to make some changes to the principle DB the other night preparatory to a new version of the app which uses it when I noticed that the mirroring had...
I have a SQL Server database (2008) within which I have some CLR DLLs that SQL uses for various things. Are these DLLs mirrored when I use SQL Mirroring? Our DBA says not, but I find this crazy and cannot find much info on it online. Is it possible to mirror the CLR DLLs? ...
Trying to mirror a local intranet site and have found previous questions using 'wget'. It works great with sites that are anonymous, but I have not been able to use it against a site that is expecting username\password (IIS with Integrated Windows Authentication). Here is what I pass in: wget -c --http-user='domain\user' --http-pas...
I need to install an eclipse plugin to a machine not connected to the Internet and I cannot find a dist to use for a local install. Is there a tool for downloading a plugin from an update site and create a local installation archive (or a local update site)? Rumors says you can do this with eclipse, but I cant find any info on how to do...
I have a mirrored database and I need to make some changes to it. Mainly, adding a view and some stored procedures. Now I know that if you make schema changes you are supposed to remove mirroring and the mirror database, make your changes to the principal, then backup-restore the principal and restore mirroring. Is this the case for s...
Hello Everyone, I currently have mirroring setup between three computers, principle, mirror, and witness. During the day, all these systems are fine; they failover with the failover command, and the failover when unplugging any of the stations. My problem is at night I lose Quorum between the three stations, and the only way to get it b...
We had a consultant onsite who setup the production DB to mirror to a DR site SQL instance. Asynchronous mirroring set to mirror every minute. It has been synching to these DR site so far. I am picking up these tasks from the guy but ofcourse no knowledge transfer. So, i would like to perform certain tasks and have questions about them; ...
We have a client that currently has a large busy database that they back up using database mirroring. As part of a reporting requirement we need to use some of the data stored in the database to run reports against but we cannot access the data directly. Is it possible for us to run transaction replication on that server to get our d...
I have a bunch of SQL servers which I periodically performs maintainance on (Windows Update patches etc.). Now I want to the database online 24/7 and need to implement one of the high-availability solutions for SQL server. The solutions needs to be cheap and simple to use. I have no problems tweaking the connection strings for the clien...
I've been tasked with mirroring a site onto a new server. The old site has a few Perl scripts that, as far as I can see internally (i know nothing about Perl, though I have a pretty good understanding of coding generally, and specifically PHP/js/etc) aren't reliant on the old server. That said, when I try to run this script, which looks ...
Hello, people. I hope you can help me. In our development process we have a unix based file server with SFTP access (let’s call it A). This server store a large numer of xslt files we are working on. The thing is that these files aren’t under version control system. So you can imagine this nightmare. We can’t setup repository on this...
Hi, Is it possible to mirror 3 databases on 2 servers, ie. On server 1 database1, database2, database3 On server 2 mirrored database1, database2, database3 My admin claims due to endpoints its not possible to mirror 3 dbs from 1 server to another and one must use 3 servers each with 1 db... Any help appreciated, also links ...
I have a large set of files (50GB) and they're on two hosts a long distance away and I want to put them in several Git repositories so that each one is a mirror repo of the repo on the other side. But I don't want to transfer the files over the network because it will take a long time (50-60 hours) and it's unnecessary since the files ar...
Hi all, I have an account on a web page that is now "full" (ie I have used up all my allocated space) and I would like to make a mirror of that site. wget seems like the thing to use. The problem is that I would only like to mirror the sites the lie within this directory http://user.domain.com/room/2324343/transcript/ (and sub-director...
Is there a T-SQL script to determine a database is currently mirroring or not? Is there a way to determine its partner? Thank you very much. ...
Hi, I have a connectionstring as below... DRIVER=SQL NATIVE CLIENT;SERVER=TCP:NYAVDEVINTDCDB1,5550; FAILOVER_PARTNER=TCP:NYAVDEVINTDCDB2,5550;DATABASE=DMINTDC; TRUSTED_CONNECTION=YES;POOLING=TRUE; Do SQL Native Clients using this cxn String have to perform a reconnect when the NYAVDEVINTDCDB1 server gets completely disconnected/ loses...
We have set of web projects, which has a lot of shared html resources - .aspx, ascx files. We already made split them in project folder structure and I know, which folders must be same for all 4 projects, and which are specific. It should be a way in svn how to do this, right? In worst case, maybe someone can recommend good tool to co...
Here's what I'm trying to do: I have a GitHub repository, a portion of which I'd like to make web viewable. Right now I've cloned the repository on my own server and it works well, but in order to keep it up to date, I have to manually login and pull the latest changes. I'm not sure if this is the best idea (or the best approach), but ...
How can I connect to a principal database when a failover occurs in SQL server 2005 using TSQL.....after failover a pricipal database becomes mirror but still how can i connect to the new pricipal using SQL command ...