This checklist creates a database that is adequate for approximately 5-7 million rows in the FileSpec table, allowing for fragmentation over time. The database has a filegroup that can extend to 10 GB and a log that can extend to 2.5 GB.
If you do not have the correct version of SQL server, as described in the File Reporter Configuration and Installation Guide, you must upgrade your SQL server. Service packs are available at the Microsoft web site.
exec sp_dboption N'model', N'bulkcopy', N'true'
go
exec sp_dboption N'model', N'trunc. log', N'true'
go
exec sp_dboption N'model', N'autoshrink', N'false'
go
exec sp_dboption N'model', N'auto create statistics', N'true'
go
exec sp_dboption N'model', N'auto update statistics', N'false'
go
exec sp_dboption N'SRMFC', N'bulkcopy', N'true'
go
exec sp_dboption N'SRMFC', N'trunc. log', N'true'
go
exec sp_dboption N'SRMFC', N'autoshrink', N'false'
go
exec sp_dboption N'SRMFC', N'auto create statistics', N'true'
go
exec sp_dboption N'SRMFC', N'auto update statistics', N'false'
go
use master
go
alter database SRMFC
add filegroup SRMFC_tables
go
Complete the template with the directory location(s) on the server, then execute the following commands in an SQL Query Analyzer window, replacing the G: directory location with the path on available disk(s):
use master
go
alter database SRMFC
add file
(
name = 'SRMFC_tables1',
filename = 'G:\SRMFC_tables1.ndf',
size = 500MB,
MAXSIZE = 5000MB,
FILEGROWTH = 100MB
)
to filegroup SRMFC_tables
go
alter database SRMFC
add file
(
name = 'SRMFC_tables2',
filename = 'G:\SRMFC_tables2.ndf',
size = 500MB,
maxsize = 5000MB,
FILEGROWTH = 100MB
)
to filegroup SRMFC_tables
go
use master
go
alter database SRMFC
modify filegroup SRMFC_tables default
go
grant execute on GetDailySchedule to SRMSvcGroup
go
use master
go
alter database tempdb
modify file
(name = tempdev,
size = 500MB)
go
alter database tempdb
modify file
(name = tempdev,
filegrowth = 50MB)
go
alter database tempdb
modify file
(name = tempdev,
maxsize = 1500MB)
go