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

Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?

3 Answers   Infosys,

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

0 Answers   Amazon,

what information is maintained within the msdb database? : Sql server administration

0 Answers  

What is database replication? What are the different types of replication you can set up in sql server?

0 Answers  

What is Online Index Rebuild Operation?

1 Answers  

Tell me the difference between clustered and non-clustered index?

0 Answers  

What are triggers in ms sql server?

0 Answers  

how to delete duplicate rows in sql server2005

7 Answers   Cisco, CTS, HCL, IBM,

How to insert new line characters into strings?

0 Answers  

Can a cursor be updated? If yes, how you can protect which columns are updated?

0 Answers  

what are the critical issues you have resloved in your company

0 Answers   Wipro,

what is isolation level at dead lock?

0 Answers   Verizon,

For more SQL Server Interview Questions Click Here
Categories