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
- 8223 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 merge join?
What do you understand by a view?
Tell me what are the essential components of sql server service broker?
How many servers can we create in a single subscription?
What is best institute to Learn DotNET And SQL in chennai?
What is a Join and explain its types?
What are user-defined functions (udfs) in sql server?
How do you delete a data source?
What are the steps to process a single select statement?
What is the tcp/ip port on which sql server runs?
What is store procedure? How do they work?
Name some of the open source software that you can use in alternative to SSR?
How to connect ms access to sql servers through odbc?
How to select some specific columns from a table in a query in ms sql server?
What is update_statistics command?
