Interested to Buy Any Domain ? << Click Here >> for more details...
can you any body tell me the how to decrease the logfile
- 4 Answers
- 6002 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 to bind a view to the schema of the underlying tables?
Write a sql query to delete duplicate records from a table called table1
How is SQL Azure different than SQL server?
How to create an index on a view?
Explain indexed views?
Why normalization is used?
What factors you will consider calculating the storage requirement for that view?
Describe and explain about SQL native client?
What is the difference between char, varchar and nvarchar?
Can you explain what is indexed view? How to create it?
Explain the database you used in your final year project?
What is the difference between a check constraint and a rule?
What is the purpose of forms?
How to Check if table exists in sql server?
What is co-related sub query?
