Posts

Showing posts from November, 2009

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 ...

Create DB with multiple Data Files

CREATE DATABASE YourDb_LIVE ON PRIMARY ( NAME = YourDB_01, FILENAME = 'I:\DB\YourDB_01.mdf', SIZE = 8192, FILEGROWTH = 5 ), ( NAME = YourDB_02, FILENAME = 'I:\DB\YourDB_02.ndf', SIZE = 8192, FILEGROWTH = 5 ), ( NAME = YourDB_03, FILENAME = 'I:\DB\YourDB_03.ndf', SIZE = 8192, FILEGROWTH = 5 ), ( NAME = YourDB_04, FILENAME = 'I:\DB\YourDB_04.ndf', SIZE = 8192, FILEGROWTH = 5 ), ( NAME = YourDB_05, FILENAME = 'I:\DB\YourDB_05.ndf', SIZE = 8192, FILEGROWTH = 5 ), ( NAME = YourDB_06, FILENAME = 'I:\DB\YourDB_06.ndf', SIZE = 8192, FILEGROWTH = 5 ), ( NAME = YourDB_07, FILENAME = 'J:\DB\YourDB_07.ndf', SIZE = 8192, FILEGROWTH = 5 ), ( NAME = YourDB_08, FILENAME = 'J:\DB\YourDB_08.ndf', SIZE = 8192, FILEGROWTH = 5 ), ( NAME = YourDB_09, FILENAME = 'J:\DB\YourDB_09.ndf', SIZE = 8192, FILEGROWTH = 5 ), ( NAME = YourDB_10, FILENAME = 'J:\DB\YourDB_10.ndf', SIZE = 8192, FILEGROW...