Results 1 to 6 of 6

Thread: Backup/Restore

  1. #1
    Join Date
    Jul 2004
    Posts
    268

    Unanswered: Backup/Restore

    I have a db that has 1 data file. I backed it up and I have to restore another database from the backup and break 1 data file into 3 data files. Any ideas on how to do that?

    Thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Can't do that with backup/restore. You would have to create the three files on the restored copy, if you don't want to have the files on the original.

  3. #3
    Join Date
    Jul 2004
    Posts
    268
    Here is my problem. I have to move a dev db to prod and I dont' have enough space on a single drive for this db. What should I do?

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    1) Create the database as you want it to look on the production server
    2) Generate a script of all objects (minus foreign keys) of your development database
    3) run said script on production database to create the tables, views, stored procedures, and other stuff
    4) Use BCP, DTS, SSIS, or brute force to bring over the data
    5) Script out the foreign keys from the development database
    6) Run foreign key script on the production database.

  5. #5
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    You can backup DB to 3 files and restore with a "move".

  6. #6
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Yes, but the restored database will have the same number of files as the original database.

Posting Permissions

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