Interested to Buy Any Domain ? << Click Here >> for more details...
can you any body tell me the how to decrease the logfile
- 4 Answers
- 6055 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
How do you migrate data from mssql server to azure?
Explain the collation?
What is cross join in sql server joins?
Explain the different types of joins?
How to recreate an existing index in ms sql server?
Explain difference between cross join and full outer join?
What is stored in the mssqlsystemresource database? : sql server database administration
Define candidate key, alternate key, and composite key.
What is the need for group functions in sql?
How to find index size for each index on table?
In what version of sql server were synonyms released?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
Define views.
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What is transaction server consistency?
