Perhaps the OP means that in addition to the "best practice" backup strategy they are following, they would like to...

What error do you get ?

You could set up a server side trace on that database ?

Solution found. Posting it in the off chance anyone cares.

This didn't really end up being relevant to SQL, but I needed a "/b" in the COPY to prevent an end...

I don't know why, but my 2 thoughts are:

1) Job 1 can be configured to start job 2 as the last step, to eliminate timing issues.

2) Why do you keep...

Quite right. I have been guilty of this in the...

I would try letting replication handle the deletes. If your replication job runs frequently, maybe it won't have a negative impact.

Anamika (10/17/2010)

Before going for a live data base what are the things we need to consider and steps should be taken as a vibrant intuitive DBA?

On memory utilization, space, Performance...

Do you want the deletes to happen at the subscribe too ? If you stop replication, and want the subscriber to be deleted too, then you'll have to reinitialize the...

Make sure you have frequent transaction log backups running, or your .LDF will grow quite big.

I do a similar process to those mentioned above. You can use a loop with...

Backup Device ?

Sorry, I haven't used OUTPUT so I don't quite follow how that would help. (reading up on it now)

I should clarify, that TableA that data is being selected from is...

Don't forget Feb has variable month ends: 28 and 29. So the 28th is not a month end during leap years.

Sounds doable. You've already go the steps in place for all 3 databases. Make additional steps and handle just 1 database in each step.

Perhaps scripting the change to a job, instead of SSMS would work.