Backup and restore database between computers

What is the way(s) to backup a database from a Server and restore it to
another?
Thanks for replying...
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200608/1One way is to do a backup in SQL, then restore it on another server -
however, you have to worry about whether the servers are running the same
version of SQL. If not you need to be aware of what the differences are
and what to do about them.
You can detach, copy the db and attach it on the new server - again see
above about version diffrences.
pedestrian via SQLMonster.com wrote:
> What is the way(s) to backup a database from a Server and restore it to
> another?
> Thanks for replying...
>
--
Brett I. Holcomb
brettholcomb@.R777bellsouth.net
Remove R777 to email|||Thanks for the answer, Brett.
Brett I. Holcomb wrote:
>One way is to do a backup in SQL, then restore it on another server ...
--
Message posted via http://www.sqlmonster.com