Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

When we are using this query to shrink the log file,what
exactly it will execute internally? Do we lose any data
when we run this script? which data it will truncate in the
log file and where it is saved. Please let me know...

USE DatabaseName
GO
DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 1)
GO

Question Posted / vamsimadineni


When we are using this query to shrink the log file,what exactly it will execute internally? Do we..

Answer / purushothaman

It will remove the uncommitted data

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Mention the different authentication modes in sql server.

0 Answers  

what is create database syntax? : Sql server database administration

0 Answers  

What is xdr?

0 Answers  

What are the different type of replication in sql server?

0 Answers  

What are the advantages of using stored procedures?

0 Answers  

What happens if the update subquery returns multiple rows in ms sql server?

0 Answers  

What is cte (common table expression)?

0 Answers  

What are the 2 types of classifications of constraints in the sql server?

0 Answers  

Explain about SQL server 2005?

0 Answers  

what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,

What is the difference between stored procedure and functions?

0 Answers   MCN Solutions,

What is sql server programming?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories