Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Database Refresh Expand / Collapse
Author
Message
Posted Tuesday, October 12, 2010 5:51 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 14, 2010 6:06 AM
Points: 76, Visits: 199

How to refresh the database, is it possible?


can any one please let me know...

Regards
Koteswar rao
Post #1002702
Posted Tuesday, October 12, 2010 5:55 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Saturday, March 15, 2014 4:31 AM
Points: 2,808, Visits: 7,173
what do you mean by refresh? do you mean restore?
Post #1002707
Posted Tuesday, October 12, 2010 6:39 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:59 AM
Points: 14,796, Visits: 27,270
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
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1002738
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse