Copy database from an Sql server to another

How to copy a database from one server to another?
Regards
Pedestrian
Message posted via http://www.webservertalk.comThe easiest way is just to do a backup of the database, copy the file
created by the backup to the other server, and restore the database in the
second server.
Ben Nevarez, MCDBA, OCP
Database Administrator
"pedestrian via webservertalk.com" wrote:

> How to copy a database from one server to another?
> Regards
> Pedestrian
> --
> Message posted via http://www.webservertalk.com
>|||How to move databases between computers that are running SQL Server
http://support.microsoft.com/defaul...kb;en-us;314546
How to move SQL Server databases to a new location by using Detach and
Attach functions in SQL Server
http://support.microsoft.com/defaul...kb;en-us;224071
AMB
"pedestrian via webservertalk.com" wrote:

> How to copy a database from one server to another?
> Regards
> Pedestrian
> --
> Message posted via http://www.webservertalk.com
>|||Some options:
1. Backup the database on server1 and restore it on Server2
2. Detach the database from server1 then attach it on Server2
3. In SQL Server 2000 Enterprise Manager Go to the Tools menu -> Wizards->
Management-> Copy database Wizard
Nathan H. Omukwenyi
"pedestrian via webservertalk.com" <u16758@.uwe> wrote in message
news:60c0a605d490f@.uwe...
> How to copy a database from one server to another?
> Regards
> Pedestrian
> --
> Message posted via http://www.webservertalk.com|||Database backups from one SQL Server (server1) could be used to create
a copy of the database on another SQL Server (server2). But you do need
to take into account the existing user logins as the login mappings
from server1 are not restored correctly even if same logins exists on
server2. This article will help you to migrate those logins:
http://www.databasejournal.com/feat...cle.php/2228611
Regards, Alejandro Navia C=E1rdenas|||Thanks for all replies... I got the ideas...
Regards,
Pedestrian
alejo wrote:
>Database backups from one SQL Server (server1) could be used to create
>a copy of the database on another SQL Server (server2). But you do need
>to take into account the existing user logins as the login mappings
>from server1 are not restored correctly even if same logins exists on
>server2. This article will help you to migrate those logins:
>http://www.databasejournal.com/feat...cle.php/2228611
>Regards, Alejandro Navia Crdenas
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200605/1