Hello, I am trying to split the Storage Group files on different volume locations and here in my question: Do the SG system files are stored on the same location as the transaction logs file?? I will locate Storage group database files on a different volume. Thanks in advance for your help. Edmundo
On Tue, 24 Jun 2008 10:00:02 -0700, Edmundog9 wrote: >Hello, > >I am trying to split the Storage Group files on different volume locations >and here in my question: >Do the SG system files are stored on the same location as the transaction >logs file?? >I will locate Storage group database files on a different volume. > >Thanks in advance for your help. > >Edmundo > Keep the first two together as they are required at the same time in the event you need to roll logs forward. and yes, the actual database (the jolly big file) does indeed go on separate spindles. make sure they are on different disks, not just in a different partition or whatever.
Thank you for your prompt response. I was not sure about the correct location but your answer gives me the assurance that I am doing it right. Thanks Edmundo "Mark Arnold [MVP]" wrote: > On Tue, 24 Jun 2008 10:00:02 -0700, Edmundog9 > wrote: > > >Hello, > > > >I am trying to split the Storage Group files on different volume locations > >and here in my question: > >Do the SG system files are stored on the same location as the transaction > >logs file?? > >I will locate Storage group database files on a different volume. > > > >Thanks in advance for your help. > > > >Edmundo > > > Keep the first two together as they are required at the same time in > the event you need to roll logs forward. > > and yes, the actual database (the jolly big file) does indeed go on > separate spindles. make sure they are on different disks, not just in > a different partition or whatever. >
