"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\Data" 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" <kickerb***@gmail.com> wrote in message
news:7FC3D068-4F9D-40E1-B41A-B8F019693320@microsoft.com...
>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\Data" 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.
>>
>>
>>