250+ SQL Queries Interview Question A...

250+ SQL Queries Interview Question Answers - SQL Interview Queries Question / Questions Answers This is a never end... http://ping.fm/Uy2Kq

HOW SQL Experience Resume looks like ...

HOW SQL Experience Resume looks like ? - A sample SQL Experience Resume, who has 5 years of experience.   Recen... http://ping.fm/NIL7B

Deadlock Analysis ? READ Deadlock fro...

Deadlock Analysis – READ Deadlock from SQL ERRORLOG - How to read DEADLOCK Information in SQL Server ERRORLOG ? In o... http://ping.fm/3lLzN

Example of Deadlock | SQL Server Dead...

Example of Deadlock | SQL Server Deadlock Script - IS there a way I can stimulate a deadlock in SQL Server, so that ... http://ping.fm/00qFq

How to backup SQL table ? - Backup SQ...

How to backup SQL table ? - Backup SQL table, have you ever tried to backup a single SQL table inside a database? DO... http://ping.fm/wmHvQ

SQL for Android operating System - Do...

SQL for Android operating System - Do we have SQL Server Android, My business objective for this question is Can I... http://ping.fm/kclrT

Is sql server an operating system ? -...

Is sql server an operating system ? - Recently in an interview, Interviewer asked me a question, "Is sql server... http://ping.fm/cRRmA

SQL Server copy data from one databas...

SQL Server copy data from one database to another - I need to copy the data from one database to another another, is... http://ping.fm/6eLc2

What is ACT Database Software ? - Wha...

What is ACT Database Software ? - What is ACT Database Software ? http://ping.fm/HHCYu

PUBS and Northwind Database for SQL S...

PUBS and Northwind Database for SQL Server 2012 - I am looking for some sample database to test some new features of... http://ping.fm/e4Eiv

SHRINK LOG File SQL

SQL Server Database Log File has grown exponentially over a period of time and now causing DISK space issue, how to reduce | Shrink Log file (.ldf) size?

Steps to truncating log files and shrinking your database

1. Get logical / physical name of your database log file (LDF)
2. Truncate LOG File
3. Shrink LOG File

Let's see how we SHRINK LOG File using TSQL

STEP 1 - Get logical / physical name of your database log file

use <[your database name]>
exec sp_helpfile

STEP 2 - Truncate LOG File

-- replace <[your database logical log filename]> with Logical file name, which we get in STEP 1
USE <[your database name]>
GO
BACKUP LOG <[your database logical log filename]> WITH TRUNCATE_ONLY
GO

STEP 3 - Shrink LOG File

-- replace <[your database logical log filename]> with Logical file name, which we get in STEP 1
USE <[your database name]>
GO
DBCC SHRINKFILE (<[your database logical log filename]>, 1) 
GO

Let's see how we

SHRINK LOG File using SQL Server Management Studio (SSMS)

50 Database Optimization TIPS - Datab...

50 Database Optimization TIPS - Database Optimization helps any system to perform work efficiently and quickly. SQL ... http://ping.fm/JvPJK

How can i check all the jobs schedule...

How can i check all the jobs scheduled time and next run time. http://ping.fm/RUHN7

What is Contained Database in SQL Ser...

What is Contained Database in SQL Server ? - What is Contained Database ? Why Contained Databases feature was Requir... http://ping.fm/oMshl

Sample SQL Server database for 2012 A...

Sample SQL Server database for 2012 Adventure Works Download http://ping.fm/BxW6f

USE Database Recovery Advisory | TIME...

USE Database Recovery Advisory | TIMELINE Restore SQL Server http://ping.fm/w5oRL

SQL Server Error 2 ? Microsoft Soluti...

SQL Server Error 2 – Microsoft Solution - Microsoft SQL Server Error 2 Error when attempting to log into SQL Server ... http://ping.fm/9knv8

SQL Server Version List - How to chec...

SQL Server Version List - How to check SQL Server Version ? SQL Server Version can be checked by running the followi... http://ping.fm/wV5HE

How to Monitor SQL Server Backups ? -...

How to Monitor SQL Server Backups ? - In my last post, “10 SQL Server Disaster Recovery Solutions”  I discussed... http://ping.fm/kQmmd

10 SQL Server Disaster Recovery Solut...

10 SQL Server Disaster Recovery Solutions - What is SQL Server Disaster? Disaster is an event that makes continuatio... http://ping.fm/Akdpr

Install SQL Server 2012 Step by Step ...

Install SQL Server 2012 Step by Step Screen Shot - Today, my Evaluation edition expired and need to rebuilt my virtu... http://ping.fm/fd8mO

SQL Server Recovery Model affect Perf...

SQL Server Recovery Model affect Performance ? http://ping.fm/qcsiY

10 Difference between SIMPLE vs FULL ...

10 Difference between SIMPLE vs FULL recovery model http://ping.fm/3WIO0