INFOTEC

CREANDO BASE DE DATOS EN SQL SERVER 2008 R2 -- CREAR BASE DE DATOS COLEGIO CREATE DATABASE Colegio on Primary (Name='Colegio01',FileName='D:\Sistema\Colegio01.mdf'), (Name='Colegio02',FileName='D:\Sistema\Colegio02.ndf'), FileGroup Finanzas (Name='Colegio03',FileName='D:\Sistema\Colegio03.ndf'), (Name='Colegio04',FileName='D:\Sistema\Colegio04.ndf'), FileGroup Personal (Name='Colegio05',FileName='D:\Sistema\Colegio05.ndf'), (Name='Colegio06',FileName='D:\Sistema\Colegio06.ndf') Log on (Name='ColegioLog01',FileName='D:\Sistema\ColegioLog01.ldf') GO ------------------------------------------------------------------------------- USE Colegio GO -------------------------------------------------------------------------------- /*Modificar BD Agregar / Modificar / Eliminar arcihvos ndf add file / Modify file / Remove File A