Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Raid and Transaction log ?

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Joined
Jan 1, 1970
Messages
0
Im setting up a hardware raid 5 solution for one of our db servers. The data files will reside on the stripe. We dont realy want to raid more drives for the Transaction log if its not nessesary. If the drive with the log crashes is the data file for the database useless ?
 
Sort by date Sort by votes
Yes unfortunately if you lose your transaction log to a database then that database that the log belongs to can no longer be used.

Rick.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

TheBugSlayer
  • Locked
  • Question Question
Transaction with SELECT and UPDATE with XLOCK causing deadlocks
Replies
10
Views
1K
gmmastros
gmmastros
peac3
  • Locked
  • Question Question
Gaps and islands
Replies
8
Views
893
Chris Miller
Chris Miller
peac3
  • Locked
  • Question Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
889
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question Question
Adding Text to and XML Field
Replies
2
Views
430
grnzbra
grnzbra
Andrzejek
  • Locked
  • Question Question
Data types and sizes
Replies
18
Views
1K
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top