• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • 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 ?
  • 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.
apollo-13Author Commented:
that erase Database or only logs?
apollo-13Author Commented:
i do not want to erase database
apollo-13Author Commented:
In the Database files grid, select the file to delete and then click Remove.---no Remove
Raja Jegan RSQL Server DBA & ArchitectCommented:
In order to shrink log file of database, kindly use the script below:

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

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

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