system
16
I’m here at server side in which the size of .ldf file is about 3 GB !!!
I have to reduce the ldf size.
a) First of all, when you suggest me to backup the database does it mean backup both database and transaction log ?
b) What does exactly contain the transaction log files. How often does it need to be backed up ?
c) Is it possible to put the ldf files in another path instead of C:\Program Files\Microsoft SQL Server\MSSQL$AVAST\Data
i.e. another disk
d) What happen if a ldf file is deleted ?
Sergio