Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-06-10 : 06:50:01
|
| Vikas writes "If my database log file is full then what I can do for performing operations on database. Or if their is loss of log file (may delete the log file). Can through query it is possible to checkout the database is full or may be going to full. Do not describe the fill factor." |
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2005-06-10 : 07:40:27
|
1.Back up the log file or you can change the recovery model to simple.Look up BACKUP & recovery models in BOL2.If you detach the database and delete the log file then re-attach the database a new log file will be created.3.DBCC SQLPERF (LOGSPACE) quote:
Do not describe the fill factor
OK i wontEdit:Only change your recovery model if you dont the ability to recover to point in time (Read BOL carefully before deciding on this action)Beauty is in the eyes of the beerholder  |
 |
|
|
|
|
|
log file