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...


You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

What is statement level trigger?

0 Answers  


Which command displays the SQL command in the SQL buffer, and then executes it?

3 Answers   TCS,


What are clustered and non-clustered index?

0 Answers  


How many types of triggers are there?

0 Answers  


Do you know what is a with(nolock)?

0 Answers  


Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  


What is the difference between deallocate cursor and close cursor?

0 Answers  


How can you check the level of fragmentation on a table?

0 Answers  


How to use group functions in the select clause in ms sql server?

0 Answers  


How the data stores in a page?

1 Answers  


What is difference between aggregate and analytic function?

0 Answers  


How do I find the transaction log size in sql server?

0 Answers  


Categories