Home > database >  Great god answer SQL
Great god answer SQL

Time:09-17


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%,
  • Related