CODEWITHSUNDEEP
sql-serversql-server-2012
dev4life
dev4life

Reputation: 11394

How to ignore log file from sql server bak file

I have a 4GB bak file that I am trying to restore. In the Restore window in SQL Server Enterprise Edition I can see the bak is composed of two files: a row data type of file and a log data type of file.

Because SQL Server is asking for 50GB free space and given that I do not have that much space in my hard drive, is it possible to instruct SQL Server to only restore the row data file and ignore the log file?

Upvotes: 1

Views: 658

Answers (2)

Keith
Keith

Reputation: 21264

If you don't need the log then you can shrink it before you create the backup.

Shrinking the Transaction Log

Upvotes: 0

dean
dean

Reputation: 10098

In short: no, it isn't.

Content of the log file is needed for the initial recovery. Without the log the transactional consistency cannot be guaranteed, because the updates are written first to log and only afterwards to a data file.

Upvotes: 3

Related Questions