Hello, I have two drives in a raid 1 (mirroring) array. Hardware raid using whatever is built into an Intel motherboard. (asus P5BE)
I'd like to remove one drive but keep the data in both (I want to put one of the drives into another machine).
Can I go into the raid configuration and remove the array and have the data remain?
You have two servers when you perform a SQL Server database mirroring
You have 1 primary database and 1 mirror database
Do you need to make any changes to web application to tell it that your using database mirroring? If not how does your web application know which database to use when the primary database fails?
You Want Videos? We Got Videos! I always enjoy getting the chance to catch up with author, consultant, and Microsoft Clustering MVP Allan Hirt . Allan and I recently presented two sessions covering an overview of high availability in Microsoft SQL Server and, the following week, a demo of how to implement several different kinds of high…
Recently our web-server crashed and we had to recover everything from a backup which took the whole day(totally unacceptable in our business).
So my question is, how can I create a complete mirror of the server that I can use (switch dns to) in case the same disaster happens in the future?
Our main server is on Amazon with Windows…
Hi all I'm having a problem configuring a WMI alert that I would like to use with database mirroring. I'm running on Windows 2008 Enterprise X64 with Server 2008 Enterprise X64 also SQL Server has SP1 installed. Basically I click on alert select WMI after that I typed the below SQL statement
SELECT *
FROM…
Hi all,
I want/need to start monitoring our network a bit better. Its an odd network in that it comprises 2 /22 public IPs and a slew of private admin IPs. I do have one point in the network where it all comes together and I can turn on port mirroring on the catalyst. From that port, I'd like to turn up…
I am trying to migrate my data on lvm to two new disks, and setup mirroring between the two. I have successfully migrated all of the data to the first of the two disks, leaving the second one completely available as a mirror. I verified this using pvdisplay -m /dev/sd{g,h}1
--- Physical volume ---
…
Hello
I am trying to put two monitors in mirror mode (Windows 7 Professional) with Ultramon 3.1.0.
The two monitors:
Main monitor: 24" Asus. 1680x1050 resolution (16/10).
Secondary monitor: 19" LG. 1280x1024 resolution.
The graphic card is a Nvidia GeForce 8600 GT.
I have installed the Ultramon…
There is a class of business and mission critical applications where downtime or data loss have substantial negative impact on revenue, customer service, reputation, cost, etc. Because the Oracle Database is used extensively to provide reliable performance and availability for this class of…
Allan Mitchell and myself are doing a double act, Allan is becoming one of the leading guys in the UK on StreamInsight and will give an introduction to this new exciting technology; on top of that I'll being talking about SQL Server Disk IO - well, "Disk" might not be relevant anymore…
I have assigned all three NICs IP addresses that are outside the DHCP pool. I have 2 NICs are connected to 1 switch and the 3rd to my second switch.
I want to assign one of the two NICs on the 1st switch to "normal" network activity (e.g. internet access, RDP, etc.)
The other two NICs I…
We have two network switches, a POE switch (SwitchA) to power our phones / users computers and a non-POE switch (SwitchB for the rest network.)
Each switch is setup to do port mirroring to support our VoIP recording system. SwitchA does port mirroring on specific ports if we need to…
Hi
I have about 200 sites each of which have 2 servers running MSSQL (2k5 at some sites, 2k8 at others)
One server is production and the other is primarily there as a backup.
We're rebuilding all of these servers this year and as part of that we will have to set up mirroring for…
I am attempting to use ntop to monitor traffic over a Cisco Catalyst switch.
I was assuming that in order to see any of the traffic, I'd have to use monitor, as described here: http://www.cisco.com/en/US/products/hw/switches/ps708/products_tech_note09186a008015c612.shtml.
Howver,…
Guys I'm rolling out a SQL database server that will be used to back Sharepoint 2007. Right now I need some advice on my disk layout. I have two Dell servers that are configured a little differently in terms of storage. The principle server will be using a combination of local…
If you use Windows 7 to mirror a volume across an SSD drive and a mechanical hard drive, will the read performance be similar to a single SSD drive?
I.e. is Windows smart enough to read from them both and use the data that comes back first?
Hi. I need to setup a Raid 1 in Dell Poweredge 2850 Server. It has 2 scsi 73 gb disks, i am trying with Dell Server asisstant but i can't see no disk utilities. any idea ?
I did something stupid. When my Dell Vostro 1000 laptop screen cracked and went all crazy and I couldn't see anything, I attached it to an external monitor and pressed Fn + F5 and it worked.
But then I did something in the control panel that made the external screen look…
In times immemorial, back in the day when men were men and blackberries still took AA batteries, we rolled them out to our users for our 100 person operation. At that time, there was no such thing as address list lookups, so we were forced to hack a bit. The ingenious hack…
I have to migrate MySQL server to a different data centre so I would like to create another MySQL slave server in new DC and then promote it to a master later on. I previously used LVM snapshots and Percona Xtrabackup for this purpose but this time I've optimized MySQL…
I have an svn repository and I'd like to have it duplicated over multiple machines for availability purpose. By now when my vps goes down, I'm unable to connect to repository and this is very annoying.
Easiest (and expansive) solution is to setup two identical machine…
So here is the deal, I have a server on switch A where port 3 is monitoring traffic for most of the ports on switch A. However I have other users on switch B that needs to have port 3 on switch A monitor as well. Is this possible? I have been reading about rspan but…
We have some data collection machines running WinXP. After a new file is written, we would like to immediately copy the new file to network storage (a NetApp CIFS share) automagically.
We need realtime or near realtime copies generated (copy upon filehandle close…
We have a SQL Server that has important databases for our clients, if the server goes down we want another server to be ready to be switched over (we would just change the IP). The question is, how can we automatically sync the primary SQL Server to the secondary…