Thank you Leach....

but both softwares having a common issue..

i.e., "no support for creating user-defined filegroups.. they create only Primary and Log Files.."

I found...

The connection loss between the publisher and the subscriber causes this problem frequently... 

 there is an option in the Publication Properties dialog box

Subscriptions Never Expire

better check this...

Thank you Dinesh

The tool is better working with Schemas ,but If try to include data too in the package its taking lot of...

You have the schedule option in

Update DataOptimization Information Step

which performs the ReIndexing at specified schedule time

With This you can set the schedule when to ReIndexing which causes Transaction Log...

you can move the tables from one filegroup to other using Enterprise Manager

->RightClick on Table

->goto design table

->right click on any feild

->goto properties

-> change Table FileGropup 

->close

you can even get the...

try to execute the procedure from user login who created the table.. simply

exec sp_changeobjectowner '<TableName>,'dbo'

or else try to change the owner  using EnterPrisemanager

RightClick on Table ->goto design table->right click on any...

yes.. once we restore the database we cannot restore any logs unless we use WITH STANDBY option in RESTORE statement

or

we specify the "Leave database readonly and able to restre...

HI Uddin

  We did not have that AUTO SHRINK enabled...

yeahh..

any ideazz.. on the physical size reduction..

yes... because of it is being a Production database we haven't have any profiler running...

what are the traces you are talking about???

I am about the physical size only...

do not know why there was an increase or decrease in the physical size....

haiii.. I have similar issue like when I tried to start my SQL Server Agent it is getting stopped with the below error message in event log

"

SQLServerAgent could not be started...

Thank you Uddin..

I have one more issue plzzzzzz.....

one day our transaction Log size(physical size) grown to 2GB and a day after when I see...

The below resources might be useful..

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/rdbmspft.mspx

http://www.databasejournal.com/features/mssql/article.php/1439801