Viewing 15 posts - 1,891 through 1,905 (of 9,253 total)
DBA on Route (7/17/2015)
Short version: Learning.
Ok, its ideal for that
DBA on Route (7/17/2015)
July 18, 2015 at 6:56 am
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...
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...
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...
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
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...
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...
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...
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...
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...
July 13, 2015 at 10:55 am
curious_sqldba (7/11/2015)
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...
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...
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...
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...
July 10, 2015 at 8:20 am
Viewing 15 posts - 1,891 through 1,905 (of 9,253 total)