If this post is not in the correct forum, please let me know which forum it should be in and I will repost.
Here is my issue. I need to make a Backup of a Full Recovery Model Db and Restore that Backup to a Copy Db that is being used for Development. The Copy database has a Simple Recovery Model. The Copy Db should "truncate" the log file to recover hard disk space.
Currently, the Full Recovery Model DB has a .mdf size of 51.5 GB and its .ldf is 57.5 GB.
The end result would be for the Simple Recovery Model Copy Db to have a .mdf of 51.5 GB and a .ldf as small as possible (a couple of MB?).
Using SSMS (ver 15.0.18369.0 but I will use whatever version you might suggest), how do I make a backup up of a full recovery model Db and restore it to a Copy Db with a reduced Log file? How much free hard disc space should there be before I begin this process?
MS SQL Version 10.50.4042.0