Viewing 15 posts - 1,891 through 1,905 (of 9,241 total)
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
in fact without details of the schema it's going to be fairly difficult, there are some hints to possible missing indexes, whilst these should be taken with a pinch of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2015 at 4:24 am
you're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2015 at 4:19 am
got a backup of the database?
if not, why not?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 10, 2015 at 4:18 am
Viewing 15 posts - 1,891 through 1,905 (of 9,241 total)