What is the use of data in .ldf
(log) file after restoring a full backup. I am planning to shrink the log files after restoring the full backup in my dev server.
Is there any side effect for this ?
backuprestoresql servertransaction-log
What is the use of data in .ldf
(log) file after restoring a full backup. I am planning to shrink the log files after restoring the full backup in my dev server.
Is there any side effect for this ?
Best Answer
No, not really. The worst thing that could happen is the log file grows again, given this is a dev server that's not a problem. Worst case is the log takes up all available space and your db goes into read-only... which is easily rectifiable and downtime is fine as it's a dev server.
Shrink away.