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 is denormalization? : Sql server database administration

0 Answers  

How will oyu test the stored procedure taking two parameters namely first name and last name returning full name?

3 Answers  

explain how to create a new schema in a database? : Sql server database administration

0 Answers  

What is the purpose of forms?

0 Answers  

What are the two virtual tables SQL Server maintains for triggers?

3 Answers  

What are the advantages of having an index on the sql server?

0 Answers  

How to create a store procedure with encryption?

0 Answers  

Explain sp_configure commands, set commands?

3 Answers  

What happens if null values are involved in boolean operations?

0 Answers  

Explain the different index configurations a table can have?

0 Answers  

Let us say master db itself has no backup. Now you have to rebuild the db so what kind of action do you take?

1 Answers  

What are the advantages of user-defined functions over stored procedures in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories