Hey sqlfriends,
yeah, a backup and restore process may prove to be significantly faster than the SSIS package. I find myself itching to delve into that process and figure out why it might be so slow. :pinch:
Anyways, I have always found a backup/restore operations to offer even more use. Once I restore the database to the target location, I will execute a DBCC CheckDB command against it to ensure nothing was corrupt and I know that my backup has been tested and verified!
Good luck and let us know how it turns out. 🙂
~Steve