Viewing 15 posts - 1,891 through 1,905 (of 9,244 total)
DBA on Route (7/17/2015)
I'm a DBA in training and this is my second post here on SQL Server Central.
--========================================================
Sadly I don't have a spare server to mess about with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2015 at 6:54 am
Joy Smith San (7/15/2015)
As per https://technet.microsoft.com/en-us/library/ms187798(v=sql.105).aspx] , expiration is not enforced when the certificate is used for encryption.
Yes, that is correct an expired cert will not hinder the backup restore...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 15, 2015 at 3:52 am
Yuri55 (7/14/2015)
What I am looking for- how to configure cluster (e.g. via quorum, etc) to force both instances failed together?
Quorum does not provide what you are seeking, quorum is an...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2015 at 11:20 pm
the chances of them starting at exactly the same time are going to be rare to be frank, whichever process gets the resource first will win the other will wait
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2015 at 9:25 am
Arjun SreeVastsva (7/13/2015)
i have table in database having the 60 % fragmentation when i am checking the fragmentation .i have rebuild the indexes on that table.after that i have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2015 at 6:12 am
Joy Smith San (7/13/2015)
Since you said older backups are useless
They'll be useless if you don't have passwords to restore them and take new backups is what I said 😉
Joy Smith...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2015 at 6:03 am
jitendra.padhiyar (7/14/2015)
Current cluster is with SQL server 2008 Enterprise Edition with latest service pack, OS is Windows server 2008.
Now we want to install SQL server 2014 on the same...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2015 at 5:57 am
Arjun SreeVastsva (7/13/2015)
i have 4 node cluster Active Passive Cluster is there.1 is active and 7 is passive.i want to fail over the cluster.for which passive node i need...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 14, 2015 at 1:13 am
jitendra.padhiyar (7/13/2015)
We have one running SQL server 2008 Cluster, Is it possible to install SQL 2014 on the same cluster ? Would windows cluster will accept two different SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 13, 2015 at 10:55 am
curious_sqldba (7/11/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2015 at 9:38 am
MotivateMan1394 (7/7/2015)
The only difference Between HA And DR (to my mind) is the type of connection : connection...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 12, 2015 at 9:35 am
Database admin(DBA) (7/10/2015)
I hope everyone is doing well,
Im facing difficult issue in my Prod environment.
we observed the status of few databases in suspended on Principal and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 11, 2015 at 10:58 am
Joy Smith San (7/9/2015)
Thanks Gila and Perry.
you're welcome
Joy Smith San (7/9/2015)
I can see following files saved in a folder.master_key.dat
tdeCert
tdeCert_key
pvtkey.bak
tdecert.bak
Note: you do not need the database master key backup when restoring...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2015 at 8:35 am
kathy.plamann (7/10/2015)
Your response was very clear and concise. I greatly appreciate your input. I'm so sorry that I did not respond correctly.
While I am learning, I make mistakes...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2015 at 8:20 am
have you fully digested the links I posted regarding stats on a readable secondary
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2015 at 6:34 am
Viewing 15 posts - 1,891 through 1,905 (of 9,244 total)