Restore mssql database without the log perhaps?

[LeovanDoorn]

Have a backup and one PC (i.e. cut off the log, and perform other manipulation is not possible). Is it possible from the. bak file when restoring to pull only the database without the log (for the last there is no place)...

 

[sbpromania]

Short answer: you can not restore just the .mdf and exclude de .ldf
My suggestion is that you do a regular backup/restore, and then shrink the log files once you have restored the database and set the recovery mode to simple. A tip is to add WITH COPY_ONLY to the BACKUP command. That prevents the backup from being recorded as a "real" backup.

 

[TimothyCarr]

Technically it is possible. Could make a restoration option with truncation of not used space in the file. Try when working with low free disk space on the test server when you turn the database in there manually, truncate the transaction log on the productions. and only then take a full backup for deploy to a test server. Still here look information http://www.filerepairforum.com/foru...l-server/1914-restore-the-sql-server-database

 

[LeovanDoorn]

Thank you all for your advice! The issue has been resolved.