I am having troubles with shrinking a database log file when I run the following command:
ALTER DATABASE RiskMan_PRD_TST SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE ('RiskMan_PRD_TST_log', 100)
ALTER DATABASE RiskMan_PRD_TST SET RECOVERY FULL WITH NO_WAIT
Could not locate file 'RiskMan_PRD_TST_log' for database 'master' in sys.database_files. The file either does not exist or was dropped.
The only issue is that these are what is listed when I run the following command, see screenshot.
I am doing some wrong how do I proceed?
Any assistance is welcome.