Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2003
    Location
    mexico city
    Posts
    4

    Unanswered: Data Device too big Sql6.5

    I receive a Backupdevice size=30 Mbytes as full database backup

    i create the database with "fromload option"

    the execute the restore procedure send the error because the original databse device size is 2500 Mbytes but the database is not too big

    who i can restore the database with a samller database device?

  2. #2
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    The database has to be restored with files the same size as the database that was backed up.

  3. #3
    Join Date
    Sep 2003
    Location
    mexico city
    Posts
    4
    Certainly but this file has a size 1000 times bigger than the needed size and it does not fit in my server.

    The question its: if exist some procedure to restore the database in a Database device smaller, but sufficiently.

  4. #4
    Join Date
    Sep 2003
    Location
    mexico city
    Posts
    4
    its impossible?

  5. #5
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Use the following command to get some information on the original database:

    load headeronly from (device)

    This may give you some ideas on how the original was laid out. Also, pay attention to the details of the error you get back from the load database command. This is where it should tell you how big and how many devices there were on the original.

  6. #6
    Join Date
    Sep 2003
    Posts
    8
    On 6.5 there is a procedure called sp_help_revedatabase. Unlike 2000, on SQL 6.5 you need to have an existing database, that has been built the same way as the original database. Run the procedure on the original server, and take its output, paste it in a query window to create the new database on the new server... After which, the restore should be a snap. This is off the top of my head, so you may want to look it up on BOL, or a search engine for the exact process.

    This is assuming you have access to the original server that the database was dumped. If not, sorry.
    Last edited by pinion; 09-30-03 at 20:59.

  7. #7
    Join Date
    Sep 2003
    Location
    mexico city
    Posts
    4
    thanks i´ll try it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •