That is take a backup of database A and restore the .bak file to database B.
By far the easiest way is to do it in script:
restore database myDatabase from disk = 'C:\mybackup.bak' with replace
No more opening of SSMS (yawn), replacing file paths and remember to set a overwrite flag.
No comments:
Post a Comment