Home > database >  Use the SQL statement create Goods, customer order management database in the main file group to cre
Use the SQL statement create Goods, customer order management database in the main file group to cre

Time:09-18

1, use the SQL statement create Goods, customer order management database in the main file group to create master data file, the logical name for Goods_Data, physical file path for the D: \ database \ Goods_Data Mdf, initial size of 10 MB, the maximum capacity of 200 MB, growth of 5 MB. To create secondary file group of FG, secondary data file, create a logical name called Goods_Data1, physical file path for the D: \ database \ Goods_Data1 Mdf, initial size of 10 MB, the maximum capacity is 500 MB, growth rate of 10 MB; Create a transaction log file, called Goods_Log, physical file path to D: \ database \ Goods_Log LDF, initial size is 5 MB, the maximum capacity of 50 MB, growth rate of 10%,