the database is in readonly mode .failed with the same error what i mentioned in the above

the job failed again what is the use of running the query which mentioned ?

thanks for ur reply can u bit clear on this

i found to install the Sp from microsoft site to resolve the issue apart of thsi is any reason for the failure of this job ?

The job failed. The Job was invoked by Schedule 20 (SharedServices1_DB_JobSchedule_DeleteExpiredSessions). The last step to run was step 1 (SharedServices1_DB_JobStep_DeleteExpiredSessions).

this the ouput of the failed job

thanks for ur reply yes can u suggest in general to approach

before shrinking can we take backup of the file ?

can we shrinkthe primary datafile i.e the mdf file

yes one of the step as update statistics failed due to

[SQLSTATE 42000] (Error 22029)

Message

Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

when i checked in the history i didnt fnd any reason step 2 failed as update statistics

can any one explain how to resolve this ?

this is theh query when i executed in sql 2000 SELECT name, physical_name AS physical_location

FROM sys.master_files

showing sys.master_files are not exist

any one sort it out .

thanks

this is theh query when i executed in sql 2000 SELECT name, physical_name AS physical_location

FROM sys.master_files

showing sys.master_files are not exist

any one sort it out .

thanks

this is theh query when i executed in sql 2000 SELECT name, physical_name AS physical_location

FROM sys.master_files

showing sys.master_files are not exist

any one sort it out .

thanks

in general what is the significant of those jobs , using 2000 and 2005.

appreciated for replies but when i executed the mentioned query showing Invalid object name 'sys.database_files' or . in sql 2000 can u sort it out .

Thanks