Viewing 15 posts - 3,766 through 3,780 (of 9,244 total)
PearlJammer1 (1/15/2014)
I have sized my 2 tempdb files at 20Gb each because I saw sql monitor returning a lot of sort warning and hash warning alerts - so I figured...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 4:54 am
download the cum13 update and extract it to disk, then run the msi from the extracted folder
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 4:12 am
ramana3327 (1/14/2014)
Hi,I am planning to do clustering in my personal laptop.
See my 3 part guide on this site at the following links
Create virtual cluster Part1[/url]
Create virtual cluster Part2[/url]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 4:01 am
smallmoney (1/14/2014)
Is it true that you can only have mdf files in the Primary Group?
No, that's complete twaddle :Whistling:
smallmoney (1/14/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 3:43 am
jamessdba (1/15/2014)
i was told to send the restore DB log report .
i know we can fetch this through MSDB(sysdb)..RestoreHistory table.
Where can we check the log for backup or restore...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 3:31 am
Ted, don't forget about the new Dynamic weight quroum configuration in Windows 2012, this can help to maintain quorum during node shutdowns but on a catastrophic would likely be ineffective,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 3:23 am
Ted Zatopek (1/14/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 15, 2014 at 3:13 am
Doesnt look good for that table, as Gail said do you have a clean backup and unbroken log chain. If not, why not 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 14, 2014 at 2:27 pm
GilaMonster (1/14/2014)
Moving TempDB is easy. The other three, not so much.
+1
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 14, 2014 at 1:54 pm
On many occasions I've been asked by clients to reconfigure a sql server and move the system databases, mainly because a vendor has deployed a server with mal configured local...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 14, 2014 at 1:52 pm
I would look at getting the vendor to populate the LS tables on their system if possible. Have you asked them if they are willing to do this?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 14, 2014 at 1:43 pm
Nadrek (1/14/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 14, 2014 at 12:07 pm
PearlJammer1 (1/14/2014)
We have a requirement to de-sensitize some of the data in our tables after we do a restore to our test\dev environment. We need to replace the data...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 14, 2014 at 10:59 am
SQLLogship.exe relies upon the metadata for the primary and secondary IDs for the log shipping partners. If this is not present then it has nothing to work with.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 14, 2014 at 10:57 am
SQL_Bob (1/14/2014)
Actually I busted out Process Monitor yesterday to see how it was scanning the log files in the directory and found out that file names do matter...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 14, 2014 at 9:56 am
Viewing 15 posts - 3,766 through 3,780 (of 9,244 total)