It might be more useful to generate reports for your boss that show that things are getting done. For instance, run some queries that display backup history for your databases...

Depending on the scope of the number of objects in training you want to keep, you can script out those that you want to keep, then apply the scripts after...

I second dharper's idea.  That's the simplest way.

The maint plan shown above will create individual .BAK files, one for each of the 7 days specified, then the oldest one will get deleted. There's no "appending" going on....

I think our situation is somewhat simpler than yours, so I went through a learning curve, but haven't had much problem since. I'm no expert, I've just managed to get...

Phil seems like a pretty helpful guy ...  I know I wouldn't turn down his assistance.

Phils first post here was quite appropriate.  Posting about "TopicA" in a forum about "TopicB"...

Is it a SQL Scheduled JOb, or a Windows Scheduled task ?

If it's a SQL job, you should be able to right-click, "Stop Job".  If it's a Windows task, you...

Lumigent and a few other products can do this, assuming your database is full recovery and you have log backups or active log file from the time of the corruption.

" ....... I have tried at least 5 times to split the tables into the last two years records ...... "

Does this mean you only need the last 2 years...

Are both servers in the same domain ?

How many tables are you replicating ?  What type of replication are you doing ??  Transactional I assume. What are your business requirements for your subscriber DB in terms of up-time...

You can create a SQL job to be scheduled, then either paste the script into a job step, or build a stored procedure from your script, and execute the stored...

You can paste SQL scripts into QA and run them there.  Is that what you're asking ?

James, what type of failures & design problems are you having ?

Raj, I think the idea is that it's best to use the "supported" methods because if you have any "unsupported" coding in stored procedures or jobs, when that code is...