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
- 7869 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
How to see the event list of an existing trigger using sys.trigger_events?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
How to create new databases with "create database" statements?
What do you need to connect php to sql server?
How to generate create function script on an existing function?
Explain few examples of RDBMS?
Explain the disadvantages of cursors?
Explain contrast amongst grouped and non-bunched records?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
In which tcp/ip port does sql server run? Can it be changed?
What is a non equi join?
What method is used by the Command classes to execute SQL statements that return single values?
Explain relational data?
Can another user execute your local temporary stored procedures?
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
