Error when restoring up a database backup: Cannot find file ID 1 on device
Your code is for Restoring a database not to create a backup file. you have to use the following code:

BACKUP DATABASE METERIAL_MANAGEMENT_2 
TO DISK = 'D:\DB_Backup\MMS.BAK'


Read more about Creating a full backup using T-SQL in the following TechNet article