Interested to Buy Any Domain ? << Click Here >> for more details...
can you any body tell me the how to decrease the logfile
- 4 Answers
- 6140 Views
- I also Faced
- E-Mail Answers
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
What are different types of schemas?
What do you mean by data integrity?
When would you use sql joins?
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What is model database? : SQL Server Architecture
How to delete existing triggers using "drop trigger"?
Mention the differences between having and where clause.
Why is replication required on the sql server?
Why do we use non clustered index?
What is the recommended total size of your memory optimized tables?
What do you mean by cardinality?
What are the purposes of floor and sign functions?
what are isolation levels? : Sql server database administration
Explain the rules for designing files and file groups in sql server?
Can you create a logon trigger in sql server 2005 express edition?
