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.
Answers were Sorted based on User's Feedback
Answer / nixo
You will have to backup the Transaction Log. You may
schedule a job which backs up the log every night.
Backup the log before shrinking the database.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sujay kumar
You should schedule the job for shrinking the database log.
Sometime, it looks impossible to shrink the Truncated Log
file. Following code always shrinks the Truncated Log File
to minimum size possible.
USE DatabaseName
GO
DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
DBCC SHRINKFILE(<TransactionLogName>, 1)
GO
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / rajkumar
You should schedule the job for shrinking the database log.
or you have to minimize the growth of the log file.
Is This Answer Correct ? | 0 Yes | 0 No |
What is difference between createstatement and preparedstatement?
What are the advantages of partitioning?
What are the tool windows in sql server management studio? : sql server management studio
What is a partitioned view?
How important do you consider cursors or while loops for a transactional database?
What are the components of dbms?
What is outer join in sql server joins?
What do you understand by the data quality services in sql server?
Write a query for primary key constraint with identity key word?
How many non clustered indexes there can be on table ?
What do you understand by replication in sql server?
When do we use the UPDATE_STATISTICS command?
4 Answers Deutsche Telekom AG,