Viewing 15 posts - 31 through 45 (of 275 total)
In Win 2008r2 you can take the quorum offline and the cluster will stay up.
February 27, 2015 at 4:05 pm
We moved from emc to NetApp last week which involved migrating the data between SANs via some device. We had two options around DTC and quorum:
1. we could create...
February 26, 2015 at 4:02 pm
Joy Smith San (8/5/2014)
1. Login into Passive node
2. Run setup
3. Remove that node from cluster.
That sounds right. From memory, when you run the setup it looks a bit worrying...
August 6, 2014 at 4:21 am
Each instance in the cluster requires a distinct IP address to be entered at installation time and it gets checked by the install process - so you can't install two...
August 5, 2014 at 7:08 am
I think it depends on why you are doing it. You can pause a node so that no resources can be used on it (perhaps to perform maintenance on...
August 5, 2014 at 5:36 am
Do a test transfer of a large file in advance to gauge how long the 100gb databases will take to transfer across the network.
If the speed is slow...
August 3, 2014 at 1:19 am
See http://qa.sqlservercentral.com/articles/System+Tables/66335 - it might help
December 20, 2013 at 4:25 am
Double-click on the report in the Solution Explorer to open it. Click on one of the report objects in the Design tab, go to View - Report Data; the...
December 18, 2013 at 10:59 am
Does the following query show it's being backed up?
select bs.database_name, bs.backup_start_date, bs.description, bmf.physical_device_name
from msdb.dbo.backupset bs
join msdb.dbo.backupmediafamily bmf
on ...
December 18, 2013 at 10:41 am
One way to see the deadlocks in action is to run profiler against the database with the Deadlock graph, Lock:Deadlock Chain and Lock:Deadlock events selected. SQL Server will roll...
December 18, 2013 at 10:27 am
Might be easier to use Powershell. Create a database with a table containing all the database instance names that you want to connect to, use Powershell to...
December 17, 2013 at 8:00 am
If it's a huge database then the advantage may be that you save time as you just need to copy the data and log files rather than backing up, copying...
December 3, 2013 at 10:52 am
I had a similar issue on SQL 2008 R2 just recently when we lost the tempdb disk (well, actually, the drive letter changed). In our config we have 8...
November 26, 2013 at 4:33 am
In example 1, The principle server goes down and you have no witness so the mirrored databases remain in a restoring state. They can be put online if you...
July 9, 2013 at 12:54 pm
Can you show us the query you are running - is it using openquery?
June 26, 2013 at 11:21 pm
Viewing 15 posts - 31 through 45 (of 275 total)