Skip to main content
Cleaned up grammar and flow of the answer to make it easier to follow.
Source Link

Please verify the log file size on the production server. Probable itIt is probably 2TB, maybe. Maybe at some point it has grown sogrew. So, even if it is empty bow because of log backup, it’s still a 2TB file on disk, and you will need to have that space available for the physical file on the new server.

If your test server is VM, you could add large disk and restrestore the log file there and shrink it after restore,. Then move the log to a smaller disk and remove the large onedisk.

Other option is to shrink log file before full backup, if you areyou’re sure that it dodoes not need whileto be 2TB.

Please verify the log file size on the production server. Probable it is 2TB, maybe at some point it has grown so even if it is empty because of log backup you will need to have space for the physical file.

If your test server is VM you could add large disk and rest log file there and shrink it after restore, move to smaller disk and remove the large one.

Other option is to shrink log file before full backup if you are sure that it do not need while 2TB

Please verify the log file size on the production server. It is probably 2TB. Maybe at some point it grew. So, even if it is empty bow because of log backup, it’s still a 2TB file on disk, and you will need to have that space available for the physical file on the new server.

If your test server is VM, you could add large disk and restore the log file there and shrink it after restore. Then move the log to a smaller disk and remove the large disk.

Other option is to shrink log file before full backup, if you’re sure that it does not need to be 2TB.

Source Link
Marcin
  • 164
  • 1
  • 6

Please verify the log file size on the production server. Probable it is 2TB, maybe at some point it has grown so even if it is empty because of log backup you will need to have space for the physical file.

If your test server is VM you could add large disk and rest log file there and shrink it after restore, move to smaller disk and remove the large one.

Other option is to shrink log file before full backup if you are sure that it do not need while 2TB