Author |
Topic |
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2011-04-11 : 19:16:01
|
um... OPPS!okay, so i was running a dbcc dbreindex ([table])and now my disk drive is full from the logging... how can i setup a log on another disk so that every spills over to the second disk without running out of space in the db?Thanks! |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2011-04-11 : 19:22:02
|
sql 2k8.that's what i did. so sql's just smart enough to start using the new log file? |
 |
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2011-04-11 : 19:27:09
|
also, just for future ref, right now i have my log file sitting on a 4-disk stripe (10k rpm drives) and my data is partitioned out across 16 disks. should i have a log file for every disk or something? or is there a rule of thumb i can follow for the logging? Thanks!(btw, your probably gunna tell me to do tlog backups more often, but i'm already doing them every 15min, incase that changes your response. ) |
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
albertkohl
Aged Yak Warrior
740 Posts |
Posted - 2011-04-12 : 00:10:45
|
just always used that. what would you recommend to replace it? |
 |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
Jahanzaib
Posting Yak Master
115 Posts |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
Jahanzaib
Posting Yak Master
115 Posts |
Posted - 2011-04-18 : 00:55:49
|
Thanks for correctionRegards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBAMy Blogwww.aureus-salah.com |
 |
|
|