Restore all MS SQL Server

[Normando]

Hi,

I'm a beginner with MS SQL Server and I need some help.

I have to restore all objects (databases (including systems databases), dts
packs, jobs, user, etc) from one MS SQL Server 7 (ServerA) to other MS SQL
Server 2000 (ServerB).

How can I do it?
the references about ServerA (in DTS packages for instance) will change automatically
?

thanks

[KC]

There are a few options you could consider:

1.You could generate a script for the entire database using Generate SQL
Script and run it on your 2nd Server. This would take care of all your
integrity constraints and keys (be sure you check them when generating
script). You could then do DTS to the 2nd Server.Im not sure if the jobs
would be copied.

2.You could attach the database as a whole to the 2nd Server. Using :

EXEC sp_attach_db @dbname = MyDatabase',
@filename1 = 'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\myDatabase.mdf',
@filename2 = 'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\myDatabase_log.ldf'

Copy the mdf and ldf files into the 2nd Server and attach the same.You could
do this will all the other databases.

The second option is better ... since it transfers all the data as well
along with the keys and other constraints.

KC


"Normando" <araujon@apci.com> wrote in message
news:3c3c6814$1@147.208.176.211...
>
>
> Hi,
>
> I'm a beginner with MS SQL Server and I need some help.
>
> I have to restore all objects (databases (including systems databases),
dts
> packs, jobs, user, etc) from one MS SQL Server 7 (ServerA) to other MS SQL
> Server 2000 (ServerB).
>
> How can I do it?
> the references about ServerA (in DTS packages for instance) will change
automatically
> ?
>
> thanks
>
>