Viewing 9 posts - 271 through 280 (of 280 total)
watson_mike (9/12/2011)
Not a "Newbie" but definitely new to this issue. A year or so ago, a third party vendor set up a SQL 2005 2-node...
September 13, 2011 at 12:24 am
Yes. If you pull up the project properties for the SSRS project in BIDS, you can change the target server version from 2008 R2 to 2008.
September 12, 2011 at 11:18 pm
You're in the right place, this is just a topic that's difficult to conquer.
It is possible to configure, and you'll learn a ton about kerberos in the process.
There are a...
September 12, 2011 at 11:08 pm
So, you'd recommend configuring max memory to be 1-2 GB less than physical on the box it usually runs on? (23 GB and 13 GB?)
Would you recommend setting min memory...
September 12, 2011 at 9:44 pm
short answer:
DB1, min 6-7 GB, unlimited max
DB2, min 3-4 GB, unlimited max
as it is currently configured, you have 40 GB of ram and only 18 GB can be used...
September 7, 2011 at 11:00 pm
You may need to change your file cache settings. We've had similiar problems with large file copies causing paging.
check these two registry keys:
HKLM\System\CurrentControlSet\Services\LanmanServer\Parameters\Size
HKLM\System\CurrentControlSet\Control\Session Manager\Memory Management\LargeSystemCache
They should be equal...
August 4, 2011 at 6:21 am
My script is also based on the assumption you can have downtime on each database long enough to perform a backup and restore. if not, the method Alex mentioned...
July 25, 2011 at 2:15 am
(edited as I almost forgot the original poster)
general instructions here: http://support.microsoft.com/kb/314546
As for migrating 100 databases, this should get you on the right track. this is using the...
July 25, 2011 at 12:38 am
Unless I'm missing something big, there is no reason to replicate a windows page file as it's temporary storage. It would be like replicating the san volumes for tempdb....
July 24, 2011 at 11:46 pm
Viewing 9 posts - 271 through 280 (of 280 total)