How to Restore and Backup MSSQL7 ?

[nutjugger]

---

Good Day!!!

I have a SQL server running and I want to build another SQL server on a separate computer (using it as for tests and experiments), How will I copy the database from the one pc to another?

Also, what are the ways of making SQL Backups?

----MSSQL version 7----

Thanks

[thec_wizard]

http://www.microsoft.com/technet/pro...ackuprest.mspx

[abloyboat]

enterprise manager. explore lang didto kung wala paka kahibalo. naa ray menu ngadto. right click lang.