but is there a way that i can user restore procedure to restore database from back up file on different database server. is there a command that i can user...

thanks every one but one thing needed to be done that needed to run sp_repldone so all the pending replicated trasaction flush so the log gets clear.

But thanks for the...

hi it is 5 GB and the data file is 3 GB. Acually it doesn't give me any error when i run dbcc command or it doesn't timeout either!!

thanks

yeah i tried that but it stays the same size so don't know what to do now! but please tell me what is the other way i can do that!

Thanks

the recovery mode is set to full, and i do log back up as well but still it stays the same all the time now!!

Thanks

no i am doing it from job scheduling on backup. I am doing it on disk. also if i manualy go and do backup it still gives me same error...