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 indexed view?

0 Answers  


Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,


If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

0 Answers  


What are the character string functions supported by sql server 2005?

0 Answers  


What is normalization in Database ?

4 Answers  






Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  


What does the on delete cascade option do?

0 Answers  


how to find out the repeated value from table using groupby function?

4 Answers  


WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?

8 Answers  


What can be used instead of trigger?

0 Answers   ADITI,


how to insert the values in 5 table at a time Using any single statement ?

6 Answers   Infosys, Value Labs,


What is an identity column in insert statements?

0 Answers  


Categories