How do I add new data or log files to a database?

Products

• Activator
• eTrust ALERT
• eTrust ALERT for CICS
• ALERT
• Archiver
• ASM/ARCHIVE VSE-ESA OPTION
• ASM/Archive
• AutoAction
• AutoSys Job Management Adapter for AutoXfer
• Process Automation Manager
• Portal
• ARCserve Backup Client
• CICSORT
• Clipper
• COBOLVISION Analyzer
• CTO Distributed
• Dart
• Datesolver/2000
• Distribulink
• EUREKA:Object
• EPIC VM
• Enterprise
• Endevor for Unix
• Archiver Disk Option
• EPIC Backup
• EPIC Access Option
• EPIC SUPER SYS
• EPIC for CMS System
• EPIC TAPE MANAGEMENT
• eTrust Antivirus Gateway for CVP
• eTrust Content Inspection Gateway
• eTrust Content Inspection Gateway Option for MSP/ISA EE
• eTrust Antivirus Gateway for Netscape
• eTrust VPN Enterprise Edition
• FAQS VM
• FAQS Automated Systems Operation
• Global Subsystem (GSS)
• ANDYNE
• MAINFRAME MISCELLANEOUS
• Inventory Discovery Server
• ARS Resource Management
• JARS Resource Management ACC Option
• JOBDOC
• JOBWATCH
• Look
• MAZDAMON
• Service Management Affiliate Technology Partner Fee
• Service Management Basic Technology Partner Fee
• Metanet
• MF - MISC OLD CODES
• Omniguard for CICS
• Omniguard
• Opera
• Connect
• PREVAIL
• Paramount XP CAM FOR DIST SYS
• Paramount FOR NAVIGRAPH/HOST
• Research Planmacs Unlimited
• Project Planner
• Remote Console PREVAIL/XP-AUTOMATION PHASE 1
• Remote Console PREVAIL/XP AUTOMATION-RDF/SSM
• Raps
• Research Raveler
• Generic Non Product
• SOLVE:EPS
• Unicenter NetMaster Network Management for SNA
• Alexandria
• Sort System
• SPOOLMAN
• Storage Mainframe
• SYSTEM/SCHEDULER
• SYSTEM/SCHEDULER VSE-ESA OPTION
• System/Manager
• Tape/Manager VSE-ESA OPTION
• Output Management Document Server
• TNG Network and Systems Management Agent for CA-Datacom
• DFSMShsm Workstation
• Network and Systems Management UNIX SMTP
• Unicenter Management for Microsoft Exchange SMTP Option
• UNICENTER II
• Unicenter Network and Systems Management Database Performance Monitor Option
• UNICENTER OSM
• Database Command Center Mnt
• VM:DBA
• VM:DB Admin
• VM:DB Center
• VM:DB Developer
• VM:DB Editor
• VM:DB Monitor
• VM:DB Reorganizer
• VM:DB Reporter
• VM:DB Restore
• VM:DB REXX
• VM:DB SQLMAP
• VM:DB Suite
• VM:Migrate
• VM:Monitor
• VM:Notekeeper
• V/Solver
• VM:Webserver for Officevision
• VM:Webserver Secure
• VM:Webgateway
• VM:Webserver
• XMENU for z/VM
• VISION:COMBO for TSO
• VISION:DAGER
• VISION:ELEVEN
• VISION:EIGHTY
• VISION:Online
• VISION:IQ for Informix
• Automate
• STORAGE RESOURCE MANAGEMENT SUITE

Issue/Introduction

Description

You can add data or log files to a database by using Object Explorer in SQL Server Management Studio.

Solution

To add data or log files to a database

1. Connect to an instance of the SQL Server 2005 Database Engine in the SQL Server Management Studio Object Explorer.

• Expand the instance.

• Expand Databases and select the database for which you add files.

• Right-click the database from which to add the files, and click Properties.

• Select the Files page in the Database Properties dialog.

• Click Add to add a data or transaction log file.

• Type a logical name for the file in the Database files grid.
  Note: The file name must be unique within the database.

• Select the file type, data or log.

• Select the filegroup in which the file should be included from the list for a data file. (Or) select <new filegroup> to create a new filegroup.
  Note: Transaction logs cannot be put in filegroups.

• Specify the initial size of the file.
  Make the data file as large as possible, based on the maximum amount of data you expect in the database.

• Click (...) in the Autogrowth column to specify how the file should grow. Select from the following options:
1. Select the Enable Autogrowth check box to allow for the currently selected file to grow as more data space is required. Select from the following options:
2. Select In Megabytes and specify a value to specify that the file should grow by fixed increments.
3. Select In Percent and specify a value to specify that the file should grow by a percentage of the current file size.

• Select from the following options to specify the maximum file size limit:
1. Select Restricted File Growth (MB) and specify a value to specify the maximum size the file should be able to grow to.
2. Select Unrestricted File Growth to allow for the file to grow as much as needed.
3. Clear the Enable Autogrowth check box to prevent the file from growing.
   The size of the file will not grow beyond the value specified in the Initial Size (MB) column.
   Note: The maximum database size is determined by the amount of disk space available and the licensing limits determined by the version of SQL Server that you are using.

• Specify the path for the file location. The specified path must exist before adding the file.
  Note: By default, the data and transaction logs are put on the same drive and path to accommodate single-disk systems, but may not be optimal for production environments.

• Click OK.

Environment

Release: BRMAPS20100-11.7-Storage Resource Manager-Application Server
Component: