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 |
|
RobertsT
Starting Member
1 Post |
 Posted - 2007-02-02 : 11:47:30
|
| What feature of SQL Server would we use to keep two business unit's data/indexes separate? They will share SQL Server box but want their data and indexes keep in different physical locations. Using Oracle now and have data/indexes in different tablespaces. |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-02-02 : 11:55:32
|
| Probably create two separate databases, but you could also create everything in one database with two separate filegroups. Filegroups are the logical unit of space allocation and each filegroup can have one or more physical database files (from different or the same drives) allocated to it. |
 |
|
|
|
|
|
Keeping two business units Data/Indexes separate