September 1, 2015 at 9:05 pm
Hi Folks,
I've a requirement from new team to setup their development in our server, and I want to give them a table space with 1GB space, so they can do whatever they want in that particular space.
In Oracle, we have tablespaces concepts, how can we achieve this in SQL SERVER 2014 ?
September 1, 2015 at 9:39 pm
Filegroup is in some sense closest to Oracle table space. you can create a file group, assign the space. There is no direct means of assigning permission to just the filegroup.
Regards,
Raj
September 1, 2015 at 9:45 pm
Hi, Would like to ask your opinion, if I create a database for this new team as below, is that mean any database objects created for that database will go to below specific location ?
CREATE DATABASE Chemicals
ON
( NAME = Chemicals_dat,
FILENAME = 'D:\SQL FILES\Chemicals\Data\Chemicalsdat.mdf',
SIZE = 10MB,
MAXSIZE = 50MB,
FILEGROWTH = 5 )
LOG ON
( NAME = Chemicals_log,
FILENAME = 'D:\SQL FILES\Chemicals\Log\Chemicalslog.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB ) ;
GO
September 1, 2015 at 10:02 pm
Yes for sure.
Regards,
Raj
September 1, 2015 at 10:14 pm
Thanks for the replied. Is that mean filegroups only useful if I've multiples data files ? For instance sales data files can group to filegroup sales, marketing data files go to filegroup marketing.
September 1, 2015 at 10:31 pm
in a sense true, if you want to logically segregate your tables into files or groups of files.
Regards,
Raj
September 2, 2015 at 2:47 am
sqlbaby2 (9/1/2015)
Thanks for the replied. Is that mean filegroups only useful if I've multiples data files ? For instance sales data files can group to filegroup sales, marketing data files go to filegroup marketing.
Well, yes. A filegroup is a group of files (1 or more). You have one filegroup when you create a database (PRIMARY). You can create additional filegroups, but without files in them, it would be kinda pointless.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply