backup MESDP production db and restore to MESDP Dev db
We currently have a development environment that runs the default DB software. We would like to be able to backup the production db (MSSQL) and restore it to a new db file and connect our dev environment to that.
Is it possible? I was thinking of backing up the Prod db with SQL express tools and restoring to a new db name and point the MESDP dev server to that database. Can it be done this way?
Is it possible? I was thinking of backing up the Prod db with SQL express tools and restoring to a new db name and point the MESDP dev server to that database. Can it be done this way?