Database refresh

i want to refresh the database for every week from a cluster environment.
could you please suggest a feasible option not back and recovery.
I tried the following ways:
1. through SSIS database transfer task-but it failed
2. through copy database wizard-not working
please tell us how to work through these options.

Answer Wiki

The correct solution to refresh your database is a backup and restore solution. Why do you not want to use this solution?

The Copy Database Wizard and the SSIS Database Transfer task are the same thing. The wizard simply runs the Database Transfer task. These options are only good for fairly simple databases. Once the databases get complex enough the SSIS task can’t get all the object drops and creations done in the correct order.

The only way to guarantee an exact copy of the source database is to backup and restore the database.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your response...

Discuss This Question: 1 &nbspReply

There was an error processing your information. Please try again later.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy