HEXAQ : A friendly question - answer site for IT professionals

SQL Server - How to truncate log file in SQL Server 2008?


Our intranet website is used by all team members. Since last 2 years we are using the same SQL database.

I have noticed the speed is decreased for page loading.

Query execution is also taking long time.

In database server I have seen the Database file (.dbf) size is about 600MB but the Transaction Log File (.ldf) is bigger than 7GB.

Is there any way I can back my data and reduce the file size to increase performace?


≡ Total 0 Answer

Enter your reply here
Answer Preview: