Restore from single data file to two data files

  • Have a backup of DB with 9GB data file (log file is not a problem). Need to restore to an environment with only multiple 8GB drives available. Can not come up with syntax for restoring with replace and/or move that allows me to do this. Any suggestions?

  • You have to restore as was originally. 9GB, then split it into smaller pieces, backup, then restore like you suggest. You cannot split the file during the restore.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply