Yes, it is running now from 956 am

Event:

DCOM got error "The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. " attempting to start the service IISADMIN...

This is out file:

2011-02-08 09:56:57 - ? [100] Microsoft SQLServerAgent version 8.00.2039 (x86 unicode retail build) : Process ID

2011-02-08 09:56:57 - ? [100] Microsoft SQLServerAgent version 8.00.2039 (x86 unicode...

1.are sql server and sql agent both running under same account or not..

I checked agent properties connection it is a sa account and where do I check for SQL Server?

2.Also...

Thank you very much, 2 questions:

1.Can I do this for all db including system db

2. Why don't you use maintance plan for that?

2011-02-08 07:25:47.81 server Copyright (C) 1988-2002 Microsoft Corporation.

2011-02-08 07:25:47.81 server All rights reserved.

2011-02-08 07:25:47.81 server Server Process ID is 3696.

2011-02-08 07:25:47.81...

I went to Services

SQLServer agent

Startup type:Automatic

Status started

but not recovery no action

I rebooted sql services today and no trace running anymore,but SQL Server Agent services was not running again. What else should I check that causing this issue.

Thank you

I care about these database and data, it is a production data, so I will check database integrity with include indexes right? Any specific time I should run? I am...

Thank you for your help,

this is what I have:

DBCC SHRINKDATABASE(N'virtualDBA', 10, TRUNCATEONLY)

shrink database when it goes beyoung to 500mb

amount of free space to remain after shrink 10%

Return freed space...

Thank you

Thank you

How do you know that is running?

I don't have any one to check why it was checked,but I just disabeled, also when I run this statment:

select * from ::fn_trace_getinfo(default)

I get:

traceid property value

116

12D:\\audittrace_20110207135814

13200

14NULL

151

Is this...

Yes,

it checked, so if I disabeled it, it would stop my tracing right is anything else would be damaged?