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

How do you start single user mode in clustered installations?

0 Answers  


Does a specific recovery model need to be used for a replicated database? : sql server replication

0 Answers  


What are the Advantages of using CTE in sql server?

0 Answers   Winsol Solutions,


What is meant by referential integrity?

0 Answers   Blue Star,


What are the requirements on sql server network connections?

0 Answers  






SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES

1 Answers   Microsoft,


Define candidate key, alternate key, composite key.

13 Answers   Infosys, Software India,


How to replace null values in expressions using isnull()?

0 Answers  


When would you use a before or after trigger?

0 Answers  


How to create Clustered Primary Key to table?

2 Answers  


How can you list all the table constraints in a database?

0 Answers  


How to Debug a Stored Procedure?

5 Answers   Allianz,


Categories