Either the files G:\data_prod\rd_prod1.mdf, G:\index\rd_prod1_1.ndf' and G:\logs\rd_prod1_log.ldf don't exist or SQL doesn't have access to them (or, if this is a cluster, the G drive is not properly configured in the cluster)