Viewing 15 posts - 5,926 through 5,940 (of 9,244 total)
gmcrouch (3/3/2012)
rows are between 113 and 153 Rowsthats not to many right?
That's still excessive, what size are each of the log files physically?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2012 at 5:38 pm
run DBCC LOGINFO against each database and check the number of rows returned for each, post back here if you can.
It would also be advisable to check the configuration of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2012 at 11:52 am
sqlfriends (3/1/2012)
What is the beter route for me?
1. On the new box, install SQL server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2012 at 11:48 am
Sapen (3/2/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2012 at 11:40 am
sankar276 (3/3/2012)
Hi,Can anyone tell me why we cannot put transaction log file in a FileGroup?
A short trip to SQL Server Books Online would have enlightened you as follows;
SQL Server Books...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 3, 2012 at 11:06 am
Any changes to tempdb should be followed by a service restart. When you add files they will take affect immediately but you need to restart to force the proportionate fill...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2012 at 11:46 pm
which hypervisor are you using?
ESX, HyperV,etc
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2012 at 4:26 pm
sqlfriends (3/2/2012)
I am the server box admininstrator, why I cannot delete it?
being an administrator on the server does not necessarily give you full access, if the folder\file ACLs have been...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2012 at 4:18 pm
sqlfriends (3/2/2012)
Thanks.Is there also a way to change in SSMS, like I said in earlier post it won't save it.
Thanks
you've been told twice already so, third time lucky
you will need...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2012 at 4:12 pm
durai nagarajan (3/2/2012)
can you elobrate what is the effects of AWE and is there any negative impact?.
will server restart or service restart is needed?.
i have rough idea as...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2012 at 10:03 am
The backup of the certificate will be encrypted so this should afford some protection, but as Steve said careful here who you provide access to!
anand_vanam (3/1/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 2, 2012 at 12:00 am
Can you post the script
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2012 at 10:56 am
yes, you're starting the service thats why. I prefer to run the exe directly by changing to the Bin path for the instance i wish to start and then executing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 1, 2012 at 3:40 am
durai nagarajan (2/29/2012)
same no of processors and RAM
how many cpus how much RAM?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 29, 2012 at 4:43 pm
yes you can upgrade individual instances, if you run the GUI version of the service pack you will see the appropriate checkboxes for each instance. If patching from the command...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 29, 2012 at 4:29 pm
Viewing 15 posts - 5,926 through 5,940 (of 9,244 total)