Viewing 15 posts - 8,821 through 8,835 (of 9,208 total)
vyas (9/25/2008)
How can we administer the failure of log shipping? How can we know what the last log was shipped?
that is why you use a monitor server
September 30, 2008 at 3:15 pm
didn't i already answer this for you :unsure: .
The SP's and Functions are there so no reason why you couldn't perform a server side trace.
Check the following link for...
September 30, 2008 at 3:09 pm
Lynn Pettis (9/30/2008)
that will result in a cross join without a where clause.
and as explained will almost certainly produce more rows than you can shake a stick at 😉
September 30, 2008 at 3:02 pm
the EMC clones will almost definitely be homed on replicated LUNs, the SAN fabric will move data around a hell of a lot quicker than any disk to tape I\O....
September 30, 2008 at 2:54 pm
great minds think alike they say 😉
September 30, 2008 at 2:31 pm
TRACEY (9/29/2008)
plan what size you need your SAN or disks to be
curious, yulichka doesn't make any mention of a SAN at all :ermm:
September 30, 2008 at 2:28 pm
TBH i'm surprised it's only the apps that crashed.
September 30, 2008 at 2:24 pm
Matt Miller (9/30/2008)
September 30, 2008 at 2:20 pm
remove the /3GB switch from the boot.ini and reboot the server.
This switch is not required and indeed shouldn't be used for machines with 12GB RAM or more
September 30, 2008 at 2:10 pm
wow, sounds like it should do the job!
what disk config you going for?
how many\large databases do you anticipate?
how many user connections?
how many instances?
September 30, 2008 at 2:05 pm
Why have you specified
exec sp_trace_setfilter @TraceID, 10, 0, 7, N'SQL Profiler'
twice
September 30, 2008 at 7:14 am
ALZDBA (9/27/2008)
I think my little article regarding sqlserver and SOx can help out.http://www.sqlservercentral.com/articles/Security/3203/
its ok but i think he just wanted a quick and dirty guide on the usage of the...
September 30, 2008 at 6:48 am
roger this is the clue 😉
Roger Abram (9/30/2008)
Msg 19055, Level 16, State 1, Procedure sp_trace_setfilter, Line 1Filters with the same event column ID must be grouped together.
can you post the...
September 30, 2008 at 6:32 am
SanjayAttray (9/29/2008)
September 30, 2008 at 6:29 am
Carlton Leach (9/29/2008)
restore the MSDE DB's to 2005
that's exactly what you do
September 30, 2008 at 6:25 am
Viewing 15 posts - 8,821 through 8,835 (of 9,208 total)