Interested to Buy Any Domain ? << Click Here >> for more details...
can you any body tell me the how to decrease the logfile
- 4 Answers
- 6253 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 is sql profiler. What are the default templates with it? : sql server database administration
explain different types of backups avaialabe in sql server? : Sql server database administration
Which language rdl files made of?
What is the difference between a fill factor of 100 and 0?
Explain query editor regions
What is the difference between TRUNCATE and DROP?
How to create a user name in a database?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
How does clustered and non clustered index work?
What is the rdl file?
Explain trigger and its types?
Which is better statement or preparedstatement?
What are the new features are introduced in sql server 2012 reporting services?
Describe triggers features and limitations?
What is replication with database mirroring? : sql server database administration
