Sql Solutions
  • Home
  • Sql

Monday, 24 October 2016

Reduce log file size in sql server

 Unknown     23:36     No comments   



Dear all these are the query to reduce 
size of log file in sql 

Query 1

ALTER DATABASE databasename
SET RECOVERY SIMPLE;
GO

Query 2

DBCC SHRINKFILE (nameoflogfile, 1)

Query 3

ALTER DATABASE databasename
SET RECOVERY FULL;


In this query

Step 1 go to property of database
Step 2 go to file option
Step 3 copy file name of log file
Step 4 replace that name in above query


And run query in given sequence



After it check the size of log file

*** be careful copy only log file name
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
Email ThisBlogThis!Share to XShare to Facebook
Older Post Home

0 comments:

Post a Comment

About Me

Unknown
View my complete profile

Popular Posts

  • How to use cursor in SQL Server
    Please Use  this in your procedures and functions    DECLARE  C21 CURSOR FOR  <Query to find Value on basis of ...>    OPEN C21  ...
  • Reduce log file size in sql server
    Dear all these are the query to reduce  size of log file in sql  Query 1 ALTER DATABASE databasename SET RECOVERY SIMP...
  • Shrink Database File
    By Using This query we can reduce database file Firstly we should get File Name by Using This with TblSpace as (     select       ...
  • Right Use of Transaction Using TRY catch
    This is right use of SQL transaction Using TRY Catch for  Avoid DeadLock Condition BEGIN TRANSACTION TransRavi BEGIN TRY <Do Y...
  • Calculate Age in SQL Server
    Please Pass your date of birth in "DD/MM/YYYY" format and get age ..... Create a Procedure... create Proc dbo.CalculateAge...
  • Remove Deadloack Condition in sql server
    Use this query to drop all kind of Transaction Deadlock in Sql Server ALTER DATABASE <DataBase Name> SET SINGLE_USER WITH ROLLBACK ...
  • Find text in whole database procedures
    For Finding particular text in stored procedures  please put your text on the place of <Text> and get result... SELECT  c.name...
  • Generate Script of a Table in Sql server (Using Query)
    Step 1. Please pass Your table Name in this Stored Procedure and get script Create Proc dbo.Ravi_Script_Table (@tablename varchar(50)) ...
  • Get Script of Stored Procedures and views
    Please Write this qurey and get
  • Kill Sleeping Threads in SQL to Remove DeadLock Condition
     Use This Process to Kill sleeping Threads in sql CREATE proc [dbo].[KillProcess]                as              begin      declare @ms...

Copyright © Sql Solutions | Powered by Blogger
Design by Ravi Budania