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

What do you think of this implementation? Can this be implemented better?

0 Answers  

How to test odbc dsn connection settings?

0 Answers  

How to select top 5 coloumn from a table without using coloumn name

5 Answers  

What is conditional split?

0 Answers  

If we delete pack Spec what will be the status of pack Body ?

0 Answers   Nagarro,

What is sparse columns of sql server 2008?

0 Answers  

How to use “drop” keyword in sql server and give an example?

0 Answers  

Explain the difference between primary keys and foreign keys?

0 Answers  

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

0 Answers  

What are the different types of subquery?

0 Answers  

what is cursor?why we will go to cursor?advantages &disadvantages of cursors?

1 Answers  

Can coalesce return null?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories