I have a database with the following mdf & log files
mdf: 410 GB (RESJunMaster.mdf)
log: 354 GB (RESJunMaster_log.ldf)
I would like to bring to your attention that the above database was build as a result of large insert statements. Millions of records at one time.
This database is static and is not expected to grow again in future. I have a large log file that is holding considerable amount of space.
Is there any way I can regain this space safely without causing any problem to the database. Considering this database will not have any other data inserted to the tables i.e., static.
Thank you for your response..