Post reply

Reset the initial space allocated for TRN file in Restore?

  • June 6, 2005 at 4:49 pm

    #86900

    Is it possible to reset the initial space allocated to the transaction log file in a Restore Database statement? The backup file the database is restored from includes a TRN file with the minimum initial space allocated as 2GB. I am unable to reconfigure the source database properties.

  • June 6, 2005 at 5:23 pm

    #563361

    I don't think you can do it during a restore operation but you can use dbcc shrinkfile after the restore to reduce the log size.

    And then again, I might be wrong ...
    David Webb

  • June 6, 2005 at 6:51 pm

    #563370

    Restored TRN file is basically empty but because the source database is configured with a 2GB minimum size allocation, shrink file won't do the trick. I could restore the databases, detach it then reattach with sp_attach_single_file_db but I would lose any transactions that were actually in the backup file.

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

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