MS SQL Server - NEWBIE QUESTION: Database Move to Alternate Server

Author

NEWBIE QUESTION: Database Move to Alternate Server

Orbital

2006-03-15, 3:23 am

Hi All,

I'm transferring some SQL 2000 databases to an SQL 2000 server and am
wondering if someone could advise on the correct transact command lines?
I've had a look at MS articles 221465 and 304692, but I was hoping for a
little more detail! Could someone advise on the correct syntax for moving
from " E:\SQLdata\MSSQL\Dat
a" on SERVERA to "G:\Program Files\Microsoft SQL
Server\MSSQL\Data" on SERVERB?

Also, can anyone advise on whether I have to move any, or all, of the
master, model or msdb databases for this to be successful?

Thanks People,
Orb.

Cube

2006-03-15, 7:27 am

I would suggest using a DTS task which copies users from one server to
another, detach the current DB from ServerA copy it to ServerB in the new
location and attach the database again.

If you have any scheduled jobs on ServerA you should script out the jobs and
recreate them on ServerB or backup and Restore the database, you do not need
to worry about model.

This would be quickest method in moving your databases.

--
http://www.sqlserver.co.za

"Orbital" wrote:

> Hi All,
>
> I'm transferring some SQL 2000 databases to an SQL 2000 server and am
> wondering if someone could advise on the correct transact command lines?
> I've had a look at MS articles 221465 and 304692, but I was hoping for a
> little more detail! Could someone advise on the correct syntax for moving
> from " E:\SQLdata\MSSQL\Dat
a" on SERVERA to "G:\Program Files\Microsoft SQL
> Server\MSSQL\Data" on SERVERB?
>
> Also, can anyone advise on whether I have to move any, or all, of the
> master, model or msdb databases for this to be successful?
>
>
> Thanks People,
> Orb.
>
>
>

Orbital

2006-03-15, 7:29 am

Cube, thanks for your reply, I'll get to work. :o)

Thanks again,
Orb.

"Cube" <kickerbutt@gmail.com> wrote in message
news:7FC3D068-4F9D-40E1-B41A- B8F019693320@microso
ft.com...[color=darkred]
>I would suggest using a DTS task which copies users from one server to
> another, detach the current DB from ServerA copy it to ServerB in the new
> location and attach the database again.
>
> If you have any scheduled jobs on ServerA you should script out the jobs
> and
> recreate them on ServerB or backup and Restore the database, you do not
> need
> to worry about model.
>
> This would be quickest method in moving your databases.
>
> --
> http://www.sqlserver.co.za
>
>
> "Orbital" wrote:
>

Sponsored Links