How to add multiple data files on Created DB ?? with sql command line
ALTER DATABASE YourDB ADD FILE (NAME = YourDB_01, FILENAME = 'I:\DB\YourDB_01.NDF', SIZE = 8192MB, FILEGROWTH = 5MB ) ALTER DATABASE YourDB ADD FILE (NAME = YourDB_02, FILENAME = 'I:\DB\YourDB_02.NDF', SIZE = 8192MB, FILEGROWTH = 5MB ) ALTER DATABASE YourDB ADD FILE (NAME = YourDB_03, FILENAME = 'I:\DB\YourDB_03.NDF', SIZE = 8192MB, FILEGROWTH = 5MB ) ALTER DATABASE YourDB ADD FILE (NAME = YourDB_04, FILENAME = 'I:\DB\YourDB_04.NDF', SIZE = 8192MB, FILEGROWTH = 5MB ) ALTER DATABASE YourDB ADD FILE (NAME = YourDB_05, FILENAME = 'I:\DB\YourDB_05.NDF', SIZE = 8192MB, FILEGROWTH = 5MB ) ALTER DATABASE YourDB ADD FILE (NAME = YourDB_06, FILENAME = 'J:\DB\YourDB_06.NDF', SIZE = 8192MB, FILEGROWTH = 5MB ) ALTER DATABASE YourDB ADD FILE (NAME = YourDB_07, FILENAME = 'J:\DB\YourDB_07.NDF', SIZE = 8192MB, FILEGROWTH = 5MB ) ALTER DATABASE YourDB ADD FILE (NAME = YourDB_08, FILENAME = 'J:\DB\YourDB_08.NDF', SIZE = 8192MB, FILEGROWTH ...