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
- 6948 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 are constraints in microsoft sql server?
How to Insert multiple rows with a single insert statement?
What is the purpose of indexing?
What stored by the tempdb ? : sql server database administration
Which language is supported by sql server?
How will you find out if there are expensive SQL statements running or not?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
What is the native system stored procedure to execute a command against all databases?
Explain triggers?
What is the difference between a primary key and a unique key? Are they the same?
How to access the deleted record of an event?
What are different types of database indexes?
What is the user of Primary key?
How to insert new line characters into strings?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
