This video explains how to perform a database refresh in SQL server.
Follow the below steps
a. Backup the Source database
b. Make a note of target database properties
c. Script out the existing users roles in the target db
d. Restore the database using the source db backup file
e. Restore user roles/permissions and db properties.
For script, please check the comments section(pinned comment)
Download
0 formats
No download links available.
Steps to perform database refresh in SQL server | Ms SQL | NatokHD