June 21, 2005 at 3:03 pm
I'm trying to create a Database with data1.mdf in the primary and data2.ndf, data3.ndf in userdefined filegroup in vb.net. the SQL Statements are as follows:
CREATE DATABASE MyDB
ON PRIMARY
( NAME='MyDB_Primary',
FILENAME=
'c:\Program Files\Microsoft SQL Server\MSSQL\data\data1.mdf',
SIZE=4,
MAXSIZE=10,
FILEGROWTH=1),
FILEGROUP MyDB_FG1
( NAME = 'MyDB_FG1_Dat1',
FILENAME =
'c:\Program Files\Microsoft SQL Server\MSSQL\data\data2.ndf',
SIZE = 1MB,
MAXSIZE=10,
FILEGROWTH=1),
( NAME = 'MyDB_FG1_Dat2',
FILENAME =
'c:\Program Files\Microsoft SQL Server\MSSQL\data\data3.ndf',
SIZE = 1MB,
MAXSIZE=10,
FILEGROWTH=1)
LOG ON
( NAME='MyDB_log',
FILENAME =
'c:\Program Files\Microsoft SQL Server\MSSQL\data\data1.ldf',
SIZE=1,
MAXSIZE=10,
FILEGROWTH=1)
GO
Have anybody tried to create using SQL-DMO in VB.Net before, plz help me out.
Binu Pappachan
June 22, 2005 at 7:28 am
Sure. It's not hard. You create the database without the NDF files or the file group, just the basic MDF & LDF file. Then you add the filegroup and files to the database you created. Like this (c#):
oIndexFile.Name = txtDbName.Text + "_Data_2";
oIndexFile.PhysicalName = txtPath.Text + "\\" + txtDbName.Text + "_Data_2.ndf";
oIndexFile.PrimaryFile =
false;
oIndexFile.Size = 2;
oIndexFile.FileGrowthType = SQLDMO_GROWTH_TYPE.SQLDMOGrowth_MB;
oIndexFile.FileGrowth = 50;
oIndexGroup.Name = "INDEX_GROUP";
oDb.FileGroups.Add(oIndexGroup);
oDb.FileGroups.Item("INDEX_GROUP").DBFiles.Add(oIndexFile);
I think that's what you mean.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply