• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 243
  • Last Modified:

ms sql 2008

I have a mssql server und test database. Test database write too many Logs.(148gb) database is 12gb.

How can i erase or change this Logs ?
0
apollo-13
Asked:
apollo-13
  • 3
2 Solutions
 
Vijay Pratap SinghCommented:
To delete data or log files from a database

    In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.

    Expand Databases, right-click the database from which to delete the file, and then click Properties.

    Select the Files page.

    In the Database files grid, select the file to delete and then click Remove.

    Click OK.
0
 
apollo-13Author Commented:
that erase Database or only logs?
0
 
apollo-13Author Commented:
i do not want to erase database
0
 
apollo-13Author Commented:
In the Database files grid, select the file to delete and then click Remove.---no Remove
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
In order to shrink log file of database, kindly use the script below:

http://blog.sqlauthority.com/2010/05/03/sql-server-shrinkfile-and-truncate-log-file-in-sql-server-2008/
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now