Here it is,

this time i used maitenence wizard

thanx

Thanks Every body,

All the suggestion is fine and i could see that integration services is not insalled in that sever.

But the same is with other servers as well, but i...

Hi kyle,

thanks for the information. thats what we i was thinking.

many thanks

cheers

santhu

Please check the path of restore as file..and make use it is changed to the new file u have created

yes fraser,

u are rite. it is basically service broker database. now how u will know wat is occyping so much space.

thanks

santhu

Thanks Everybody.. i will try to do as said and get back with the results.

Many Thanks

Santhu

thanks manoj,

it is basically used as queue servce database..no user table/data resides here, as a result it is difficult to know how data would be there..moreover even i am not...

Hi all,

thanks for all your replys,

Database has set as unrestricted growth and every time increases by 50MB,

Full Backup is scheduled every night and Logfiles every 15 minutes

Recovery Mode is...

Thanks Kevin,

I did try it... and only after i removed storedprocedure it started working.

I also used the following script

"SELECT IDENTITY(INT,1,1) AS ROWNUMBER,*

INTO dbo.MyTraceTable

FROM ::fn_trace_gettable('C:\SqlTraces\MyTrace.trc', DEFAULT)"

even here it gives some error...