Grant Fritchey (10/23/2014)
vincyf1 (10/23/2014)
jamessdba (10/22/2014)
Hi please clarify .Please explain
what is the difference between database refresh (when we go for refresh)& Restore
Please clarify
Database Restore - When a DB Backup is restored onto an Existing Database or New Database. Typically, this would restore all Data and DB objects to that recorded in the backup file.
Database Refresh - This is performed on an Existing Database only and No New Database is created. This would purge all the data from the database keeping the DB objects intact. This is performed on a regular basis in a Testing Environment where dirty data would be purged often to test for various test conditions.
Just to be clear, that's your personal, and/or your company's, definition of Database Refresh. It's not one I would use, nor is it defined as such by Microsoft or any other standards I'm aware of.
True, this is not documented as a Standard anywhere. It is used as a general parlance in the industry at many of the places I have worked for. Database Refresh will mostly come in to picture where we have the Development, Testing and DBA team working together in a Project\Company. Otherwise, they both would mean the same.