Viewing 15 posts - 6,076 through 6,090 (of 9,241 total)
@SQLRNNR exactly, although if you were to lose half the drives performance would suck in a big way. Your data is still intact though.
@steve-2 Jones that is, unfortunately...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 12, 2012 at 12:16 am
The big advantage of Raid 10 is you can lose up to half the disks as long as no mirrored pair fail and the array will still operate, albeit with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 5:10 pm
clare.xia (1/11/2012)
The server team plan to copy only the drive that has SQL installation...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 4:58 pm
Kenneth.Fisher (1/11/2012)
Just as an aside, we have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 4:55 pm
How did you install the instance, did you select configure later or to let installer configure
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 1:28 pm
Dhirju (1/11/2012)
tomorrow i'll do it and get back to u for the same.
Ensure all nodes are well connected and confirm.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 1:22 pm
Using fn_trace_gettable you'll need to supply the file and path and the number of files to read. As below
Load 10 files
select * into my_trace
from fn_trace_gettable('c:\mypath\mytrace.trc', 10)
Load all...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 1:19 pm
martin.kerr 34088 (1/11/2012)
I found this from googleing my problem and it worked!
Create database with same name as MDF file you have.
Stop SQL Server and swap MDF files. Make sure you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 6:55 am
Dhirju (1/11/2012)
windows firewall is disable on both servers.
ok simple test, on the principal server go into administrative tools and open data source administrator. Create a new system DSN pointing to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 6:50 am
Minaz Amin (1/11/2012)
Thanks Whittle. Always helped on time.let me note own this way
SQL server instances : 2 virtual names
MSDTC : one
Windows clustering : one
correct! Same for IP addresses too 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 5:24 am
Dhirju (1/11/2012)
1st one is primary server and
2nd server are two instances (Mirror and Witness)
both are running on two different ports, and both server in one...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 5:22 am
Dhirju (1/11/2012)
how can system can't reach to own.
what do you mean by this?
Are both instances on the same server?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 3:44 am
peter Vramby (1/11/2012)
I have a clustered (active-passive) SQL Server cluster running under version 10.0.4000.0 (SQL 2008 SP2 64-bit Enterprise Edition) where the syspolicy_purge_history job is failing.
When I try to run...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 3:26 am
Dhirju (1/11/2012)
yes i have specified FQDNs, please see attachment..
do you have any firewalls between the nodes (Windows or otherwise)
Try a telnet to the port from the partner node
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 3:24 am
Fully Qualified Domain Name, example below
my domain name is UKTrading.co.uk
my server name is SQLServer1
The FQDN for the server is SQLServer1.UKTrading.co.uk
To connect to this server in a mirror session using port...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 11, 2012 at 2:20 am
Viewing 15 posts - 6,076 through 6,090 (of 9,241 total)