How can I increase the size of the database used for Web Reporter?
book
Article ID: 53906
calendar_today
Updated On:
Products
ActivatoreTrust ALERTeTrust ALERT for CICSALERTArchiverASM/ARCHIVE VSE-ESA OPTIONASM/ArchiveAutoActionAutoSys Job Management Adapter for AutoXferProcess Automation ManagerPortalARCserve Backup ClientCICSORTClipperCOBOLVISION AnalyzerCTO DistributedDartDatesolver/2000DistribulinkEUREKA:ObjectEPIC VMEnterpriseEndevor for UnixArchiver Disk OptionEPIC BackupEPIC Access OptionEPIC SUPER SYSEPIC for CMS SystemEPIC TAPE MANAGEMENTeTrust Antivirus Gateway for CVPeTrust Content Inspection GatewayeTrust Content Inspection Gateway Option for MSP/ISA EEeTrust Antivirus Gateway for NetscapeeTrust VPN Enterprise EditionFAQS VMFAQS Automated Systems OperationGlobal Subsystem (GSS)ANDYNEMAINFRAME MISCELLANEOUSInventory Discovery ServerARS Resource ManagementJARS Resource Management ACC OptionJOBDOCJOBWATCHLookMAZDAMONService Management Affiliate Technology Partner FeeService Management Basic Technology Partner FeeMetanetMF - MISC OLD CODESOmniguard for CICSOmniguardOperaConnectPREVAILParamount XP CAM FOR DIST SYSParamount FOR NAVIGRAPH/HOSTResearch Planmacs UnlimitedProject PlannerRemote Console PREVAIL/XP-AUTOMATION PHASE 1Remote Console PREVAIL/XP AUTOMATION-RDF/SSMRapsResearch RavelerGeneric Non ProductSOLVE:EPSUnicenter NetMaster Network Management for SNAAlexandriaSort SystemSPOOLMANStorage MainframeSYSTEM/SCHEDULERSYSTEM/SCHEDULER VSE-ESA OPTIONSystem/ManagerTape/Manager VSE-ESA OPTIONOutput Management Document ServerTNG Network and Systems Management Agent for CA-DatacomDFSMShsm WorkstationNetwork and Systems Management UNIX SMTPUnicenter Management for Microsoft Exchange SMTP OptionUNICENTER IIUnicenter Network and Systems Management Database Performance Monitor OptionUNICENTER OSMDatabase Command Center MntVM:DBAVM:DB AdminVM:DB CenterVM:DB DeveloperVM:DB EditorVM:DB MonitorVM:DB ReorganizerVM:DB ReporterVM:DB RestoreVM:DB REXXVM:DB SQLMAPVM:DB SuiteVM:MigrateVM:MonitorVM:NotekeeperV/SolverVM:Webserver for OfficevisionVM:Webserver SecureVM:WebgatewayVM:WebserverXMENU for z/VMVISION:COMBO for TSOVISION:DAGERVISION:ELEVENVISION:EIGHTYVISION:OnlineVISION:IQ for InformixAutomateSTORAGE RESOURCE MANAGEMENT SUITE
Issue/Introduction
Description
You can increase the size of a database by using Object Explorer in SQL Server Management Studio. The database is expanded by either increasing the size of an existing data or log file or by adding a new file to the database.
Solution
To increase the size of a database
Connect to an instance of the SQL Server Database Engine in the SQL Server Management Studio Object Explorer.
Expand the instance.
Expand Databases and select the database that you want to increase the size.
Right-click the database to increase, and click Properties.
Select the Files page in Database Properties.
To increase the size of an existing file
Increase the value in the Initial Size (MB) column for the file.
Make the data file as large as possible, based on the maximum amount of data you expect in the database.
To increase the size of the database by adding a new file
Click Add
Type the values for the new file.
Click OK.
Environment
Release: BRMAPS20100-11.7-Storage Resource Manager-Application Server Component: