Viewing 15 posts - 8,626 through 8,640 (of 9,244 total)
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 =...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 18, 2008 at 4:21 am
Jobs are fairly portable its the DTS packages if you have any that give the real headaches
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
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
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 17, 2008 at 11:27 am
what version is your SQL instance?
VDI backwards compatibilty has a known issue with VLDB's and SQLVDI errors
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 17, 2008 at 4:57 am
what was the attach command you used?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 16, 2008 at 3:37 pm
kestak (12/16/2008)
Greetings,Seconday DNs installed and running on DC1.
you have ceated a primary zone and not a secondary?
As both name servers are DC's set them to AD integrated too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 16, 2008 at 3:35 pm
you stated DC2 is a virtual server, just for clarification what hypervisor are you using to render this VM?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 16, 2008 at 2:45 pm
: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...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 16, 2008 at 10:33 am
Jeff
can you post the actual error from the Redgate Backup log file on the server. It defaults to
c:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\instancename
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 16, 2008 at 9:56 am
K. Brian Kelley (12/15/2008)
True. On start-up it likely will, but after that it should keep its own time. We've had that problem.
this is only true for MS VS2005, under VMware...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 16, 2008 at 2:56 am
set up column filters for the databasename (containing the object) and Textdata columns.
assuming you were catching a table called "Blobdata" set the filter on textdata to
Like %Blobdata%
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 15, 2008 at 4:15 pm
install a new instance and migrate the objects then remove the old instance afterwards
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 15, 2008 at 4:06 pm
Viewing 15 posts - 8,626 through 8,640 (of 9,244 total)