• aaron.reese - Wednesday, August 16, 2017 2:24 AM

    I am trying to create a 2nd copy of my database which is 200GB so that I can do Log Shipping (but on the same server).

    The drive allocated for the data files has 385BG of free space and the log drive has 120GB. After doing the backup the data drive now only has 185GB - not enough for a restore 🙁

    Is there a way to restore the single file so that half of it is on DATA and half on LOG (this is a temporary UAT environment so will not make it to production)

    Alternatively can I split the backup across DATA and LOG and then restore both files to DATA

    The database files can only be worked on in their entirety as of now. Best option as others too have suggested , is to use external disk for the backup.