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       ...
  • Get Complete Dependency of A table in databse
    Please pass your table name in this query and  Get name of all object which are dependent on that SELECT distinct A.name FROM syscomme...
  • Replace Null values in sql server
    This Function is used in replacing null or blank value as 0 select coalesce(@param, 0) this gives result 0 when @param is null or blank...
  • 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 ...
  • Get Script of Stored Procedures and views
    Please Write this qurey and get
  • 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...
  • 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)) ...
  • Reset Identity Column in sql server
    Here is the query to reset identity column value DBCC CHECKIDENT( <TableName> , RESEED, <Values>) <Table Name> :- Ta...

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