yes that's the plans and i don't know how to do it and any script would be helpful

i don't know the reason but, i cant delete the tables , is there any script i can use

thank you Gail Shaw

but the requirement demands only truncate not delete, what should be the work around

i want to remove constraint and add it back after i upload the data

i know my version of answers and looking for what others can offer (their point of view or in their experiences)

I know that a weird requirement and I want to use primary key for that

yes I created additional file groups

thank you and I will try

yes you are right, want to insert any new rows from source, or update those with new source data.

thank you for the reply ,

I have more questions like---this is the actual code to create the table and want to use in a ssis package, is the best practice...

----

hi thank you for this

''You are using $ share which will be accessible by administrators, so make sure your service account is added to Local administrators group of both...

I tried that and this is the error message if it helps

Date10/10/2013 2:14:01 PM

LogJob History (LSCopy_SQLTEST_TCB_LOAD)

Step ID1

ServerSQLTEST2

Job NameLSCopy_SQLTEST_TCB_LOAD

Step NameLog shipping copy job step.

Duration00:00:01

Sql Severity0

Sql Message ID0

Operator Emailed

Operator Net sent

Operator Paged

Retries...

I copied the backed up log file to the B server folder and run the restore job and it worked it, so only copy job is not working

the folders are in place

both are running under sql server agent services account