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
- 8035 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
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
How sql server enhances scalability of the database system?
What do you understand by a view? What does the with check option clause for a view do?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
How do I determine how many instances of sql server are installed on a computer?
What is subquery? Explain the properties of a subquery?
List out the different types of locks available in sql server?
Explain isolation levels that sql server supports?
What do you understand by mirroring and mention the advantages of the mirroring?
what are isolation levels? : Sql server database administration
How and why use sql server?
How do you set a trace flag in sql server?
how to avoid cursors? : Sql server database administration
wat wil hapn if we give the both read and deny read permission to user?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
