Skip to main content
added 1 character in body
Source Link

backup size (*.bak file) is around 190 GB, but it keeps showing an error that the log needs around 2 TB for restore

A backup file contains only the allocated pages in the database filefiles plus the log records that were created during the backup process, and may be compressed.

Restoring a backup, however, recreates the target database will all its files the same size they were on the source system.

backup size (*.bak file) is around 190 GB, but it keeps showing an error that the log needs around 2 TB for restore

A backup file contains only the allocated pages in the database file plus the log records that were created during the backup process, and may be compressed.

Restoring a backup, however, recreates the target database will all its files the same size they were on the source system.

backup size (*.bak file) is around 190 GB, but it keeps showing an error that the log needs around 2 TB for restore

A backup file contains only the allocated pages in the database files plus the log records that were created during the backup process, and may be compressed.

Restoring a backup, however, recreates the target database will all its files the same size they were on the source system.

Source Link

backup size (*.bak file) is around 190 GB, but it keeps showing an error that the log needs around 2 TB for restore

A backup file contains only the allocated pages in the database file plus the log records that were created during the backup process, and may be compressed.

Restoring a backup, however, recreates the target database will all its files the same size they were on the source system.