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
What is statement level trigger?
Which command displays the SQL command in the SQL buffer, and then executes it?
What are clustered and non-clustered index?
How many types of triggers are there?
Do you know what is a with(nolock)?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is the difference between deallocate cursor and close cursor?
How can you check the level of fragmentation on a table?
How to use group functions in the select clause in ms sql server?
How the data stores in a page?
What is difference between aggregate and analytic function?
How do I find the transaction log size in sql server?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)