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

how do u do Performance tunning ?

1 Answers   Infodat Technologies, Satyam,

diffrence between Cluster Index and non Cluster Index

3 Answers   Wipro,

How to perfor If the table running time is taking 2hours and table is having 10 rows in it?

1 Answers  

How to use column default values in insert statements in ms sql server?

0 Answers  

can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)

1 Answers  

What are the High-Availability solutions in SQL Server and differentiate them briefly?

0 Answers  

What do you understand by a view? What does the with check option clause for a view do?

0 Answers  

Can we use max in where clause?

0 Answers  

How does stuff differ from the replace function?

0 Answers  

Can coalesce return null?

0 Answers  

How do I setup a sql server database?

0 Answers  

What are commonly used mssql functions in php?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories