Log File Crash

[manohars]

Data files and log files are kept in separate disks of my database. If the disk which contains log files crashes, will it stop the database. What can be done in this situation to continue using the database.

Thanks in Advance,
Manohar

 

[JayKusch]

In most cases it will cause an issue w/ SQL Server. You could put the DB in Simple mode until the log issue is resolved. Then you would perform a full backup of the DB and turn Simple mode back to Full.

Thanks

J. Kusch

 

[SQLBill]

It will cause major problems. The Transaction Log is used to keep track of all transactions that happen so that SQL Server can rollback any that are interrupted.

Even in SIMPLE recovery mode the transaction log is used. It's just that checkpoints are issued more often and the log file is automatically truncated. But you still need to have it.

-SQLBill

 

[manohars]

In that case, is it possible to create a new log file and make this database point to that log file.

Thanks,
Manohar

 

[SQLBill]

Yes. You need to use the ALTER DATABASE command with the MODIFY FILE option.

Refer to the BOL for more information on that command and option.

-SQLBill

BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine

Posting advice: FAQ481-4875