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 to maintain a fill factor in existing indexes?

0 Answers  

How to enter date and time literals in ms sql server?

0 Answers  

What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Credit Suisse, GCU, Symphony, TCS,

What will happen if a column containing char type data is changed to the nchar data type?

0 Answers  

Explain magic tables in sql server?

0 Answers  

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

0 Answers  

What is Report Server,Report Manager and Report Builder in SSRS 2005?

1 Answers  

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

0 Answers  

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 Answers  

What are indexes in ms sql server?

0 Answers  

How to run sql server 2005 books online on your local system?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories