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? : Sql server administration


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

Post New Answer

More SQL Server Interview Questions

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

0 Answers   MCN Solutions,


Can we take the full database backup in log shipping?

0 Answers  


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

0 Answers  


What do you understand by integration services in sql server?

0 Answers  


How do I start sql server?

0 Answers  






What is plan freezing?

0 Answers  


How do I start and stop sql server?

0 Answers  


In join, which clause in not used?

4 Answers   HCL, NIIT, TCS,


What are the 10 characteristics of data quality?

0 Answers  


How to recompile stored procedure at run time?

0 Answers  


How to add a new dsn with the odbc driver for sql server?

0 Answers  


What is the difference between local and global temporary tables?

0 Answers  


Categories