Unanswered: SQL Server 2008 - Copy Database Bug, Looking for Resolution
I'm trying to use the Copy Database task that SQL Server provides, and it is failing because it's trying to create the views before it creates the tables. When the view looks to verify the table exists, it is failing because it hasn't been created yet.
I've seen this talked about in multiple places, but have not seen where anybody has posted a resolution...does anybody know if one exists?
Scott - I looked and did not see an option to choose what to copy in terms of "just tables", views, etc. It appears to be all or nothing -- I'm doing this using Microsoft SQL Server Management Studio 2008.
Engada - I couldn't do the detach/attach method because I was trying to do it in the middle of a work day...but I ended up doing a backup/restore as you suggested, and that worked like a charm.
Again, thanks to both of you for your suggestions!!