Viewing 15 posts - 6,076 through 6,090 (of 9,244 total)
MarkThornton (1/12/2012)
My current theory is that this isn't working, due to the presence of an ntext field in...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 12, 2012 at 4:28 am
s_osborne2 (1/12/2012)
I let the installer configure with the defaults. Maybe that was my error! 😉Hope to be able to give this another go at some point later today.
I always prefer...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 12, 2012 at 4:04 am
Chris Shaw (1/11/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 12, 2012 at 1:18 am
@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
Viewing 15 posts - 6,076 through 6,090 (of 9,244 total)