I tried server machine also. i am facing same error.

Thank You . I am getting same error. but time being i am solved to change the server STATE . but i will do that certificate .

Any Problem in SERVER...

No Brother ,,,Its secrity related Question only....

I am using follwing trigger

GO

/****** Object: Trigger [dbo].[Audit_updateAuthor_Locking_Details] Script Date: 06/22/2012 12:43:41 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

Alter Trigger [dbo].[Audit_updateAuthor_Locking_Details] ON [dbo].[Author_Locking_Details] FOR UPDATE AS ...

Its returned this result

DBCC SHRINKDATABASE(iedb, NOTRUNCATE);

19 1 17579232 128 ...

i done index rebuilding and then shrinking also. but still size not changesd.

ok thank you i will try

File Size in MB

MDF File : 137337.75

Log File : 22867.38

Space Used in MB

MDF File : 15225.63

Log File...

Thanks for ur reply

No i am not taken compressed backup.just i took normal backup.