Thank this author by sharing:
By Sourav Mukherjee,
Copy and Paste the script to the SSMS query window. Navigate to the database and execute.
You can use the script in the job step also which you can use to refresh the database for repeated refresh of database requests.
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands
of articles and SQL scripts, a library of free eBooks, a weekly database news roundup,
a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals
that makes it such a success.