Both copying to another database and copying databases containing views is possible and should succeed as you describe you are doing it,
aside from "Database Rename" (I asssume you mean your're copying to a database with a different name)
What RDBMS release is installed on both source and target systems?
What version of Arcmain?
as well as the above...
1) probably need to turn on more verbosity to see what is going on ie. set the arcmain enable time parameter VB3 and then looking at the arcmain log/output
2) as the COPY operation requires more access rights than the RESTORE operation does the account being used will require the various CREATE rights ie. does this account have CREATE VIEWS rights?