database copy

microsoft.public.sqlserver.server

16 Apr 2007 8:58 PM

Port Man

I'm a total newbie to sql server 2005 and need to copy a database from
a production server to a test server. Can someone tell me how to do
this? The servers are in two physically different locations and I
can't connect to them at the same time. So, I need to basically export
out the database and then import it.

Thank you for your help.

16 Apr 2007 9:56 PM

Plamen Ratchev

Probably the easiest way would be to use SQL Server Management Studio to
create a backup of the database on the production server, then transfer the
backup file to the test server, and restore it.

HTH,

Plamen Ratchev
http://www.SQLStudio.com

Are all your drivers up to date? click for free checkup

17 Apr 2007 12:35 AM

Bulent

On Apr 16, 2:58 pm, "Port Man" <m...@nospam.com> wrote:
> I'm a total newbie to sql server 2005 and need to copy a database from
> a production server to a test server. Can someone tell me how to do
> this? The servers are in two physically different locations and I
> can't connect to them at the same time. So, I need to basically export
> out the database and then import it.
>
> Thank you for your help.
>
> --

Here is what I would do. Backup the database, zip up the backup file
so it won't take too much time, once you copied the file unzip it and
restore to the server. It's easier to use Management Studio to backup
and restore database.

17 Apr 2007 3:07 PM

Port Man

Thank you all, I was able to get it copied!