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 |
|
cosy
Starting Member
22 Posts |
 Posted - 2008-06-11 : 03:26:59
|
| HI All, Is this is a good idea or not? If i attached my SQL Server to SAN only for DATA and LOG (Ldf) drivesthrough the FC. then we put *.bak and *.trn on to local disk RAID 1 drive?Any performance isues? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-11 : 03:53:36
|
| The only performance degradation you could get is if you do not set your LUNs up properly for your SAN (seen it happen). That's without going into the bus speed on the server itself.Otherwise no problems. |
 |
|
|
cosy
Starting Member
22 Posts |
Posted - 2008-06-11 : 19:17:36
|
| Hi Rick, I mean Putting bak &trn files on Server Local Disk? Not on SAN |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-12 : 01:27:19
|
| As these are only backup files, you can put them wherever you like. As long as you move them off the machine on a regular basis(otherwise, what is the point of having a backup?!?), then there is not a problem. |
|
|
|
|
|
|
Transaction Logs and LDF