Interested to Buy Any Domain ? << Click Here >> for more details...
SQL stops working in every 15 days displaying message that
database log file is full. Log file size is 3.95 GB. It is
happening after shrinking the database also. What is
solution to overcome this problem. Please help me as it's
urgent.
- 5 Answers
- 8070 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajesh ranjan
In MS SQL Server 2005
select * from sys.database_files
Above Query will return .mdf , .ldf file & all other
details releted to these files of the database
After that you should run following DBCC Statement
DBCC Shrinkfile(Log_file_name.ldf,1,truncateonly)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of keyword with encryption.
What is the filtered index?
Tell me in brief how sql server enhances scalability of the database system?
Can you roll back the ddl statement in a trigger?
How to list all schemas in a database?
Tell me about normalization in DBMS.
What are the two modes of authentication in sql server?
What are triggers in ms sql server?
How are the exceptions handled in sql server programming?
Define left outer join in sql server joins?
What is the full form of ddl?
Mention a few common trace flags used with sql server?
What's the information that can be stored inside a bit column?
What is the use of sign function?
What is plan freezing?
