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 happens if null values are involved in string operations?

0 Answers  


Explain the working of sql privileges?

0 Answers  


What is amo? : sql server analysis services, ssas

0 Answers  


What are built in functions?

0 Answers  


what are the new features introduced in sql server 2000? : Sql server database administration

0 Answers  






Explain what are the database objects? : SQL Server Architecture

0 Answers  


What is the difference between DataRow.Delete() and DataRow.Remove()?

0 Answers  


What is perspective, have you ever created perspective? : sql server analysis services, ssas

0 Answers  


What does REVERT do in SQL Server 2005?

0 Answers   HCL,


What are the system database in sql server 2008?

0 Answers  


Why use sub query in sql server and list out types of sub queries?

0 Answers  


Plz tell about backup&recovery?

3 Answers  


Categories