Viewing 15 posts - 6,001 through 6,015 (of 9,241 total)
Ok, which ports are you using for principal, mirror, witness?
what did this mean below
saidapurs (2/7/2012)
3):I am able to do telnet 5022 but “telnet SQLServerName 5023? not happening.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2012 at 12:35 am
Let's start with basics
do the SQL server services on each instance run under the same domain account or a different domain user account?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 8, 2012 at 1:03 pm
sql2k8 (2/7/2012)
you have to check for stripe unit size/ file allocation unit size and partition offset/stripe unit sizeif these values are not integer then the disks are not aligned
Could you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2012 at 1:04 pm
sql2k8 (2/7/2012)
when i format the disks the data will be gone from the disks .
Backup the data first??? 😉
sql2k8 (2/7/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2012 at 12:07 pm
sql2k8 (2/7/2012)
with the minimal impact on the current running cluster
There is no minimal impact. To change these you must delete and re create the partitions, period.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2012 at 10:01 am
hayden_jones (2/7/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2012 at 8:33 am
ssa2010 (2/7/2012)
If any problems when restore sql 2000 db in sql 2005
and
...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2012 at 6:28 am
You're pretty much limited with your current config. SQL Server 2008 R2 Express edition may be one way of overcoming this. There's no log shipping or mirroring but you'll certainly...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2012 at 6:22 am
saidapurs (2/7/2012)
Hi Perry,I am getting same error...
Thanks & Regards
Satish Saidapur
You're getting an error running the following against your witness instance?????
select * from sys.database_mirroring_endpoints[/Code]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2012 at 4:26 am
saidapurs (2/7/2012)
Hi,All updates from PRIMARY instance......
Thanks & Regards
Satish
Execute the query you were given against the witness instance and post back the results
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2012 at 3:27 am
saidapurs (2/7/2012)
5): Mirroring655362642TCP4 DATABASE_MIRRORING0STARTED03ALL13NEGOTIATE01RC4.
Which instance is this result set from?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2012 at 1:34 am
Have you created and configured the mirroring endpoint on the witness instance?
How are you adding the witness, via the GUI or T-SQL?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2012 at 12:06 am
sqlfriends (2/6/2012)
I got it, thanks all
Great, set the max memory and post back if you need any further help
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 6, 2012 at 3:20 pm
sqlfriends (2/6/2012)
Does it mean SQL server itself (buffer pool) has not enough memory, or it means OS doesnot have enough memory?
No it doesn't
sqlfriends (2/6/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 6, 2012 at 2:47 pm
sqlfriends (2/6/2012)
[The first thing that you need to do is set the max server memory to a sensible value that will ensure SQL does not try to starve the OS....
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 6, 2012 at 1:34 pm
Viewing 15 posts - 6,001 through 6,015 (of 9,241 total)