• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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