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.
"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