Viewing 15 posts - 2,431 through 2,445 (of 9,244 total)
Hadrian (2/3/2015)
So in conclusion without password we cannot restore our encrypted database?Thanks very much,
Hadrian
Take a new backup of the certificate on the ServerA giving it a password you know.
Then...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2015 at 8:44 am
if you only have 2 nodes then you need to add a witness whether it be a disk or file share witness.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2015 at 8:39 am
SQL!$@w$0ME (2/1/2015)
We have a 2 node clustered instance(SQL 2014) with 26 databases and we would like to enable alwayson for one of the databases for reporting (only one secondary...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2015 at 8:38 am
HookSqlDba7 (2/2/2015)
1 TB Log File.
Wow
HookSqlDba7 (2/2/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 3, 2015 at 8:23 am
j.snowden (1/30/2015)
My...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2015 at 7:37 am
would help if you posted it in the correct forum location 😉
What version\edition of SQL Server are you using?
How many databases are in the availability group?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2015 at 7:31 am
you cannot convert a standalone instance into a clustered instance, you will need to form a cluster on the 2 nodes and install new clustered instances and then migrate any...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2015 at 7:25 am
RamoneThePoolGuy (1/31/2015)
So my main question is: given that we are in a VMWare HA environment, is clustering necessary?
A windows cluster on VMware has restrictions, you can't easily migrate the cluster...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2015 at 7:20 am
is this database in an Availability group?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2015 at 7:10 am
Are you saying your filling the database in an attempt to failover the AO group??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 1, 2015 at 7:07 am
seems to be different between 2008R2 documention and 2012 documentation,
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 30, 2015 at 5:57 am
no, your original post which i read said you broke the mirror session in this scenario a differential may be used to bridge any LSN gap, seems i had mis...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 30, 2015 at 5:24 am
if you're replicating between 2 nodes they both cant be primary. One will be primary one will be secondary, it seems you are after either database mirroring or AlwaysOn Availability...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 30, 2015 at 5:21 am
Br. Kenneth Igiri (1/29/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 30, 2015 at 5:19 am
you're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 30, 2015 at 5:17 am
Viewing 15 posts - 2,431 through 2,445 (of 9,244 total)