October 12, 2010 at 5:51 am
How to refresh the database, is it possible?
can any one please let me know...
Regards
Koteswar rao
October 12, 2010 at 5:55 am
what do you mean by refresh? do you mean restore?
October 12, 2010 at 6:39 am
You do have to define refresh. For example, we do a regular "refresh" where in we move the production database down to our QA environment through a backup and restore. This is followed by a few scripts to clean up security and eliminate some sensitive production information. That's one method of "refresh." Another one that we do is build a development database from scratch, dropping the old one. We use Visual Studio Team System to do this, but it's also possible to do using tools like Red Gate SQL Compare. You can even build out the whole thing by hand, but that's really hard.
What are you looking for in particular?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply