adam kurtz (7/24/2012)
Lynn Pettis (7/24/2012)
Not that hard to automate a backup/restore process. There may actually be scripts on this site that can help with this.
Yes - I know, but was just wondering what tihs utility is all about, looks like it's mainly used for upgrading....I will pursue backup\restore....Thanks everyone....
I absolutely don’t want to push for copy database option but it could be a better option in some case (detach attach method) on same server.
There is absolutely no harm in playing with it if you haven’t tried it yet. Be careful; please don’t try it on PROD server if you are unsure of its side effects and pre-requisites (SQL Agent).