I am trying to shrink my log file which is huge in SQL. I am going to use the following to complete the task
USE <db_name>--find and copy/save the logical name of log file using command below; --the first column is the logical file nameEXEC sp_helpfileALTER DATABASE <db_name> SET RECOVERY SIMPLEDBCC SHRINKFILE ( 2 )ALTER DATABASE <db_name> MODIFY FILE ( NAME = <logical_file_name_for_log_file>, SIZE = 100MB, FILEGROWTH = 20MB )
There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.
I think the second option down the list is the file data, sorry I'm not at a computer at present.