Viewing 15 posts - 6,001 through 6,015 (of 9,244 total)
sqldba4u (2/10/2012)
Is there any way or t-sql to find database name with corresponding certificate name in sql server 2008? I am referring with respect to TDE mechanism.Thanks.
Here you go
USE [YourDB]
selectdb_name(dek.database_id)...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 10, 2012 at 10:10 am
Yes, fail all instances to one node.
Go into VCS cluster console and for all cluster groups place them into Freeze-Temporary
Once this is done reboot all passive nodes and then run...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2012 at 1:04 pm
kellithompson (2/7/2012)
Nevermind. I finally got it working. Because of the failover cluster, I want to use high safety w/o auto failover (synchronous), right?
Offhand i'm not entirely certain, what...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 9, 2012 at 8:11 am
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
Viewing 15 posts - 6,001 through 6,015 (of 9,244 total)