Restore all MS SQL Server


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Restore all MS SQL Server

  1. #1
    Normando Guest

    Restore all MS SQL Server



    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



  2. #2
    KC Guest

    Re: Restore all MS SQL Server

    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
    >
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center