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 |
|
drpkrupa
Yak Posting Veteran
74 Posts |
 Posted - 2005-06-17 : 17:01:10
|
| How can i store current transation log file at two place (Parallel mode). If i loose the one current log file then still i can able to retreive point of brake data by using other t-log file.Thanks, |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-17 : 17:04:13
|
| In order to use point in time recovery, you need to perform tlog backups. That's the only way to guarantee you can restore after a failure. And don't forget to test your backups regularly! Don't assume that they are valid files.Tara |
 |
|
|
drpkrupa
Yak Posting Veteran
74 Posts |
Posted - 2005-06-17 : 17:11:46
|
| Thanks for your help. My question is if my hard drive get crrupted then i am gonna losse my current t-log file. If i am stoting that current log file at two place then i can use the other file if one get broke. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-17 : 17:13:58
|
| That's exactly what transaction log backups are for. We run ours every 15 minutes due to the criticality of the data.For information about create a database with multiple files, see CREATE DATABASE in SQL Server Books Online. But it won't solve your issue of the hard drive becoming corrupted. Only backups will solve that.Tara |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2005-06-17 : 18:43:48
|
| Maybe you should put the TXLogs on a RAID 1 array. That's what we do. If one drive dies, then the other one automatically takes over.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-06-17 : 21:07:16
|
quote:
Originally posted by drpkrupa
How can i store current transation log file at two place (Parallel mode). If i loose the one current log file then still i can able to retreive point of brake data by using other t-log file.
You mean like Oracle mirroring. SQL Server does not support a feature like this. I have asked microsoft several times to implement this feature, but they won't for some reason. They keep pointing me to the database mirroring feature in SQL2K5, or tell me to hardware mirror my disks. It is like they don't understand the problem that Oracle mirroring solves.Anyway, short answer is that you cannot do this with SQL Server.-ec |
|
|
|
|
|
|
Current t-log file running two place parallel