This code is used to add a new log file to the database using the alter database command. Method 2-Recover Database from an Existing Backup If you fail to rebuild the corrupted Log files, then you can ...

In addition to your .MDF file, you will have an accompanying .LDF. The .LDF contains database log information, which SQL Server uses to maintain database integrity. If you have this file, make ...

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.

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 ...