Viewing 15 posts - 8,626 through 8,640 (of 9,253 total)
just a small gotcha for this. If the OS is pressured and cant free memory it could bring the server to a halt. I prefer to start low and work...
December 19, 2008 at 6:30 am
open the DNS snap in and add each of the DNS servers in then check the zone configs
December 19, 2008 at 6:24 am
open the DNS snap in and add each of the DNS servers in then check the zone configs
December 19, 2008 at 6:24 am
Mani
i would start with 11GB RAM for SQL and the rest for the OS. Monitor the server and check the memory usage\requirements, adjust as necessary
December 19, 2008 at 2:40 am
firstly have you removed DNS from the terminal server?
have you installed DNS on DC2?
December 18, 2008 at 5:15 pm
Mani (12/18/2008)
We have windows 2003 EE R2 x64 with SP2 and SQL Server 2005 EE x64 with SP2.
We have 16GB RAM.In Our SQL Server instance sharepoint Application databases are...
December 18, 2008 at 5:11 pm
well, depending on where you read. MSDN states that AWE is only available for 32bit Ent and Dev sql2005. Technet states AWE available for Std, Ent and Dev. This has...
December 18, 2008 at 5:09 pm
if you're not sure what it does why use it. What version is your OS and SQL instance?
December 18, 2008 at 2:18 pm
set up a server side trace using the following
SP_TRACE_CREATE
SP_TRACE_SETEVENT
SP_TRACE_SETFILTER
SP_TRACE_SETSTATUS
also the functions
fn_trace_gettable
fn_trace_getinfo
to generate a trace definition use the following syntax
declare @traceidout int
declare @maxfilesize bigint
declare @on bit
set @on = 1
set @maxfilesize =...
December 18, 2008 at 10:32 am
bit difficult to understand when i dont see what you see, are you able to send a screenshot of what you see in DNS MMC?
December 18, 2008 at 6:07 am
which user have you logged on as on the other machine. Access denied is the key message here
Your code really wants to be expanded as you are only checking for...
December 18, 2008 at 4:26 am
kestak (12/18/2008)
I do not even know if DC1 is integrated
see below for how to check this
kestak (12/18/2008)
December 18, 2008 at 4:21 am
Jobs are fairly portable its the DTS packages if you have any that give the real headaches
December 17, 2008 at 3:49 pm
jayesh_kherwadi (12/17/2008)
Hi Guys,The database is on SQL server 2000
this is the SQL2005 forum you have posted into
December 17, 2008 at 11:27 am
Viewing 15 posts - 8,626 through 8,640 (of 9,253 total)