Monday, March 12, 2012

Primary FilesGroup change path

I want modify the path Files of 'Primary' FilesGroup when DataBase is create.

The smo create a default 'primary' FilesGroup when DataBase.Create().

After database is create the path 'primary' FilesGroup' was not change.

Thats possible?

Dim srv as new Server ("SQL instance")

Dim db as new DataBase (srv,"DataBaseTest")

--> how code for modify the FilesGroup 'primary' and the files path?

db.create()

Thanks,

Marsenne

This code below sucessfuly. Create a DataBase in another path (files)

- create a path first (D:\SqlBancos\Teste) with 'primaryroot' databases base.

Dim srv As New Server(Me.cmbSqlServer.Text)

Dim db As New Database(srv, "Teste")

db.DatabaseOptions.AutoShrink = True

db.FileGroups.Add(New FileGroup(db, "PRIMARY"))

db.FileGroups(0).Files.Add(New DataFile(db.FileGroups(0), "TestName", "D:\SqlBancos\Teste\Teste1.mdf"))

db.Create()

db.Alter()

Marsenne Negreiros


No comments:

Post a Comment