Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2004
    Posts
    55

    Unanswered: Question on Data/structure restore

    new to SQL Server 2000. We have an obsolete database that we need to
    save off for x number of years. DB2 has utilities (DB2Look/Export)
    that allows for the export of the data along with a schema and script
    that enables the future recreation of the structure of the databases
    and tables to include RI etc. You can save off the architecture and
    relationships of the tables as well as the data.

    Does SQL Server have anything similar?

    Failing that, our plan is to backup the data and logs then image the entire disk.

    Thanks in advance.

    Gerry

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Not exactly sure what you want.

    SQL Server 2000 of course has backup and restore capability, and the Enterprise Manager utility has the ability to script database objects and relationships.

    A lot depends upon why you are archiving the data and what its intended use is.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Mar 2004
    Posts
    55

    additonal info

    OK. If you had to save off a database...both the data and the 'structure' of the tables, relationships between tables etc.....for possible recreation years down the road....how would you do it?

  4. #4
    Join Date
    Jun 2004
    Location
    Philly
    Posts
    51
    sql server has a backup wizard, backup the DB to a BKF file and put it wherever, you can restore it just as easily with the wizard - table structures and all the data

    also, the design of the database should be documented in the technical specs in a word doc. so you could recreate the whole thing from documentation if necessary

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Look up BACKUP in Books online

    Do you have the SQL Server Client tools installed?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Quote Originally Posted by xarfox
    also, the design of the database should be documented in the technical specs in a word doc. so you could recreate the whole thing from documentation if necessary
    In a Word document?
    Just script the database ddl to a text file.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Mar 2004
    Posts
    55
    I believe the scipting of the ddl of the objects in addition to a backup AND a data export is a desired redundancy. I belive the scripting capabilties of SS should do the job. That's for all the interesting info .

    Gerry

  9. #9
    Join Date
    Mar 2004
    Posts
    55

    Thanks

    Should read 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
  •