Database refresh

5 pts.
Tags:
DBA
SSIS
SSIS database
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

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
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

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

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

REGISTER or login:

Forgot Password?
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

Thanks! We'll email you when relevant content is added and updated.

Following