It is neither stopping nor disabling and giving error 22022

There are 20 status = 2 listed in dbcc loginfo().

On running checkpoint I am getting below in...

You are correct

There is Job 'TfsversionControlhourly' run in each hour.

tfs means team foundation server and this job is used for update stale statistics.

MSDB is in simple recovery mode,If I will stop the agent still in 2-3 days this problem will come.

1. Should I take the backup of MSDB right now while...

When change setting to Unrestricted Growth I am getting error:

TITLE: Microsoft SQL Server Management Studio

------------------------------

Shrink failed for LogFile 'MSDBLog'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0+((Katmai_PCU_Main).090329-1015+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Shrink+LogFile&LinkId=20476

------------------------------

ADDITIONAL INFORMATION:

An exception occurred...

Thanks,

Yes jobs are runned at 9:00 PM Daily.

Is Unrestricted growth a permanent solution?

Right now What should I do.

Sure...Thanks...

Yaa...I have got..

http://www.sql-server-performance.com/2007/gen-tips/

Thanks anthony,

For such idea...

Thanks Eliott,

I just want to know if I run a delete and trucate to remove a row from the table(Suppose table has only single row) then which one...

If I will feel the memory pressure and enable the /3gb switch for both instances.What will happen?

DEV I...

Guest is a login not a user...

Thanks...

Thanks:-)