To specify the maximum file size limit, select from the following options: To specify that the file should grow by a percentage of the current file size, select In Percent and specify a value. To specify that the file should grow by fixed increments, select In Megabytes and specify a value. To allow for the currently selected file to grow as more data space is required, select the Enable Autogrowth check box and then select from the following options: To specify how the file should grow, click (. Make the data file as large as possible, based on the maximum amount of data you expect in the database. Transaction logs cannot be put in filegroups. The file name must be unique within the database.įor a data file, select the filegroup in which the file should be included from the list, or select to create a new filegroup. In the Database files grid, enter a logical name for the file. To add a data or transaction log file, click Add. In the Database Properties dialog box, select the Files page. In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.Įxpand Databases, right-click the database from which to add the files, and then click Properties. Using SQL Server Management Studio To add data or log files to a database Requires ALTER permission on the database. You cannot add or remove a file while a BACKUP statement is running.Ī maximum of 32,767 files and 32,767 filegroups can be specified for each database. To add data or log files to a database, using:īefore You Begin Limitations and Restrictions
#Add database copy log files how to
This topic describes how to add data or log files to a database in SQL Server by using SQL Server Management Studio or Transact-SQL. Applies to: SQL Server (all supported versions)
0 kommentar(er)
