Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    18

    Question Unanswered: Restoring to another server issue with data file sizes

    I'm using SQL Server 2000 and need to restore a large database onto a different node. The problem is the original database has a 74 gb first datafile and the node where I need to restore it doesn't have a single drive that big. I'm trying to use a backup of the original database and restore it into an existing database on another node and am using the move options to put the files in the right places.

    Is there a way I run the restore to split the 74 gb datafile across drives on my target node?

    Thanks for any help.

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by pellet

    Is there a way I run the restore to split the 74 gb datafile across drives on my target node?
    I don't think so; you would have to do this first on the source database and then edit the file paths when restoring to the backup database.

    Regards,

    hmscott
    Have you hugged your backup today?

Posting Permissions

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