That restores the entire database to that point in time. If there are other transactions in other tables after the error that you still want, you'll have to take a few...

Yes, we're using Veritas SQL Agent for most of our backups, but haven't had any problems with restores, not that we've done that many. I am doing SQL backups to...

The only little problem with taking databases offline is if you have automated backups such as Veritas where you've checked off  "Backup all databases".  You'll get an error with the...

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...