Copy MS SQL DB Hello, I'm yet another green MS SQL user and I'm having some issues trying to copy a database at Jodo. Basically I want to copy a current DB, rename it and customize it for a duplicate use. Can I do this myself? I have SQL 2005 Developer Edition but I'm on MSSQL9 which I believe is 2000. I have downloaded a .BAK file using Jodo's backup tool at http://mssql9.xxx.com/mssql/. I used this to modify the file locally but I can't seem to restore it using Sequel Server Management Studio. I can however import the data but it looses the primary keys, triggers, etc in the DB at Jodo. I tried using Jodo's tool to restore the .BAK file but it fails and says it is a 2005 file. What is the best way to copy a DB? I tried the SMS copy function on MSSQL9 but it says it is only for copying to 2005. How do I and can I transfer my local DB in 2005 using SMS to MSSQL9? Any help is much appreciated!