in model, properties, files.

increase the file initial size and also put hte autogrowth to 1% or 10 mb autogrowth unrestricted.

Regarding sql services , see the error logs

Regards,

Sushant

Is BIDS installed on that server.??

SSIS is a must for maintenance plans.

Regards,

Sushant

ok..

Thanks.

Regards,

Sushant

SQL 2000 or sql 2005?

Thanks Grant

I want to know how come profiler GUI can harm wen we run it on prod systems.

Regards,

run it in the master database

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Regards,

Sushant

He doesn't have the transaction logs too, how can he

recover back the tables from apex tool..

I dont think its possible,

Regards,

Sushant

profiler trace will trace from now, i mean i can start it wen i come to work,

but wat about the backups being done in night...

how to know who,when and wich...

I think some users got orphan.

exec sp_change_users_login 'REPORT'

--( run in every database to see which all logins got orphan)

Regards,

Sushant

i think you have not upgraded to SP3 ..

Do the upgrade and then let us know.

Regards,

Sushant

C drive has default all the sql server files, make sure that it has minimum 10-15% free space.

To check the domain account,

On hte remote server, go to administrative tools--> services...

does the user is already added in the particular db??

maintenance clean up task deletes the old backups according to specified time.

Regards,

Sushant

have you ssis installed on your system??

Regards,

Sushant

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

Also check , if the C2 trace is on by default agian.

Also in the sql server agent, properties-->

the...