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

CREATE a table from another table

2 Answers  

How to get @@error and @@rowcount at the same time?

0 Answers  

what is a live lock? : Sql server database administration

0 Answers  

Explain syntax for dropping triggers?

0 Answers  

What is row_number () and partition by in sql server?

0 Answers  

What do you mean by normalisation?

0 Answers  

what are user defined datatypes and when you should go for them? : Sql server database administration

0 Answers  

Why I am getting this error when dropping a database in ms sql server?

0 Answers  

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

what is difference between Enterprise Manager and Query Analyer

6 Answers   CTS,

What are different backups available in sql server?

0 Answers  

Can we join two tables without primary key?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories