SQLTeam.com | Weblogs | Forums

Database partition SQL server edition

sql2014

#1

Can we do database partitioning (not table/view partition) on SQL server 2014 Standard Edition?
By doing database partitioning, i want to place files on different physical drives.

If not possible, please share link from site like Microsoft etc. mentioning that Standard Edition is not supported. kindly reply as soon as possible.


#2

Do you mean Files and File Groups? If so I think they've been available in all versions of SQL for as far back as I can remember!


#3

Thanks Kristen. If possible, can you share me link which mention this.


#4

Here is the DOC page for ALTER DATABASE for File Groups - assuming that is the right piece of SQL syntax that you are after the DOCs say that was introduced in SQL2008

https://msdn.microsoft.com/en-us/library/bb522469.aspx