Above, we have discussed how to rebuild the SQL database with corrupted or deleted log file. To rebuild the database, you need to first detach the database or take it offline.

Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim Chapman discusses the perils of not handling SQL Server log growth ...

Using the Transact SQL ALTER DATABASE statement to shrink the transaction log file Open SQL Server Management Studio (SSMS) and click Query Analyzer to open the Query Analyzer window.

NetGenesis is running on a box and it's using SQL 7 as the database server.We're having problems with one of the databases. It's about 50GB and I want to move it to a different drive.The dba says ...

Yes you did. Sharepoint backend is SQL. Run full backup of SQL databases. Keep the backups! Then in the SQL Management Studio shrink the log file sizes. They won't shrink by themselves.