I have two SQL servers - both on different domains. Both running SQL 2005.
I'm trying to export a database from the one server and then restore it to the other server. (Both servers are running the same database, but one is a test environment, a virtual machine, that's used for testing items in the database).
This is the error i'm getting when i try to restore the database. It shows up in SQL management studio as '**INCOMPLETE**'.
I've tried copying the file from the original SQL server over the network, i've tried even running the backup from server1 with management studio running on server2 (where i'm trying to get the backup restored to).
I'm running out of ideas. What can i do?