Thanks for the help

It is a user database

My idea is to create the file on another LUN

I understand that using filegroups are the correct method but it is a propriety system that we have no control over.

Thanks for your help. I wish there was a way...

george sibbald (1/28/2010)

---

If you want to define which object goes to which file, specifying new filegroups is the only way.

If files are all part of the same filegroup SQL will...

That is the problem with native folder share. When you fail over the folder share and permissions does not carry over to the new node. That is why you have...

That's what I found as well. The only way is a new file with it's own filegroup and specify the filegroup when creating the index.

Thanks

I suggest you do not have your backup in a separate group. Add the Z drive to your sql group so that when SQL server fails over the backup drive...