0

I have a big database about 4.5Tb. Is it possible to partition it and move the half of it to another raid?

Thanks Arman.

PS.
I use Windows Server 2008 Standard with Microsoft SQL Server 2008.

Arman
  • 4,566
  • 10
  • 45
  • 66

1 Answers1

3

You can set up multiple secondary files with in enterprise manager, if you machine can see multiple logical disks you can provide storage space on a number of disks See

Once you have created filegroups you can assign tables to specific filegroups. File groups can be made up of files from different disks(or different RAID clusters). So you can spread your database and individual tables over multiple logical disk.

As this question is tagged with Sql-server I am assuming we are talking about Microsoft SQL Server.

Some more reading

Community
  • 1
  • 1
David Waters
  • 11,979
  • 7
  • 41
  • 76
  • It turns out that the standard edition does not support partitioning – Arman Mar 12 '11 at 13:44
  • @Arman, just for the next person looking at this could you please be more specific. Are you meaning partitioning of tables, or having multiple secondary files, or having multiple secondary files on different drives? – David Waters Mar 14 '11 at 10:21
  • @David, the standard edition does not support Table and Index Partitioning: for more details see: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx in the Scalability & Performance section. – Arman Mar 14 '11 at 13:57
  • @Arman so you can put different tables on different filegroups, just not split any given table up. – David Waters Mar 16 '11 at 14:41
  • @David: Yes we did that last week, We got at least Indexes to build and backup was established. Before it was impossible. – Arman Mar 16 '11 at 16:02