Home > IT Answers > Database > Database refresh
BOKAMD81
5 pts.
0
Q:
Database refresh
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.
ASKED: Oct 22 2008  6:04 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
47070 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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.
Last Answered: Oct 23 2008  11:24 PM GMT by Mrdenny   47070 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Mrdenny   47070 pts.  |   Oct 23 2008  11:25PM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 
0