can you any body tell me the how to decrease the logfile
Answer Posted / vani
The log files must be backed up, so that the inactive log
records are truncated after every checkpoint thus freeing
up the logspace to be reused.
Schrink your database (Database-All task-Schrink database)
leave 10% free and the size of the log will schrink
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Define normalisation?
How can we check the sql server version?
Mention what are the different types of ssrs reports?
What is an entity-relationship diagram (erd)?
What is encryption key?
How to change parameter value inside the report?
Describe how to use the linked server?
what are isolation levels? : Sql server database administration
What is tabulation?
What are different types of schemas?
What is the datatype of rowid?
How to find Duplicate Records In table?
Do you know what are the properties of the relational tables?
What are the differences between char and nchar in ms sql server?
Explain indexes disadvantages?