Mani (12/18/2008)

---

Hi Gail,

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...

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...

if you're not sure what it does why use it. What version is your OS and SQL instance?

phew, not a pork chop in sight LOL

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 =...

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?

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...

see below for how to check this

kestak (12/18/2008)

---

1 - How do I create the right way a secondary zone for...

Jobs are fairly portable its the DTS packages if you have any that give the real headaches

this is the SQL2005 forum you have posted into

what version is your SQL instance?

VDI backwards compatibilty has a known issue with VLDB's and SQLVDI errors

what was the attach command you used?

you have ceated a primary zone and not a secondary?

As both name servers are DC's set them to AD integrated too

you stated DC2 is a virtual server, just for clarification what hypervisor are you using to render this VM?

:blush: doh log backup missed that one

our maint jobs dont perform log backups on system db's either. Incidentally Jeff that error is from the SQL log by the looks of...