MS SQL Db restore from a database backup
So what would happen if I were to take a backup of the production database and restore it over the test database using SQL tools and not the restoreDB.bat on the server? Would that be bad?
I know I CAN just take a backup of production using the backupdb.bat, copy it over to test, then run the restoredb.bat. But would a DB to DB nuke everything?
Just curious.
Thanks
David