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
- 7834 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 4nf in normalization form?
How to drop an existing user defined function in ms sql server?
What is normalization of database? What are its benefits?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is a transactions?
What is sql server query analyzer?
What is difference between aggregate and analytic function?
What is truncate table?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do
Can you type more than one query in the query editor screen at the same time?
What is data modification?
Explain how would you store your query in an SSRS report or a Database server?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
Which is better statement or preparedstatement?
What is transaction server distributed transaction?
