I too face the same problem. In both servers sp3 is applied. and both windows versions are same. This problem occurs when I use the pull subscription(no idea abt push)....

you cant take backup of filegroup or files in EM. you will have to do that in query analyzer. like this

backup database <DBName> FILE = 'your logi filename',

   FILEGROUP =...

try lumigent log explorer.

Hi ajaac,

you have same trigger for insert,update. so, during update operation check for the existence by using the IF EXISTS() clause and do the update operation.

so far your trigger, irrespective...

Hi sumit,

before taking the backup remember to run the command dbcc checkdb dbname.  this is first step assurance that your db is in shape and u can take the backup....

Hi Pool, even though you used to sp_resetstatus, before that you have to update the status column. I too faced this problem and search...

look your organisation table does not have the cluase on delete cascade. that is why u get the error when u try to delete the master record.

See there are child records available in the User_Organization table. and u have the relationship with the User table. So naturally when you delete a row in the User table...

I have been doing this dettach and attach, from development to Production environment.

I did not faced anyproblem. This is  a handy procedure it reduces your file size. no need...

Due to performance issue, I want to achieve this one with out using a trigger.

And for all tables I need to create trigger and validate.

Is there any other way...