Thank this author by sharing:
By Yousaf Khan,
Copy this script to sql query analyser and change db name and its location in the script and run it as mention in the steps pasted with the script.
Need Automated Script
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.