...
Name | Default | Autogrow All Files |
PhixFlow database | ||
PRIMARY | Yes | No |
Temp database | ||
PRIMARY | Yes | Yes |
Database Files
Logical Name | File Type | Filegroup | (Initial) size | Autogrowth/ Maxsize | Path (see MS SQL Server planning ) | Filename |
PhixFlow database | ||||||
phixflow | ROWS Data | PRIMARY | 10,000 MB | By 1000MB, Unlimited | On Disk 1 - data files | phixflow.mdf |
phixflow_log | LOG | - | 1000 MB | By 64 MB, Unlimited | Disk 2 - transaction logs | phixflow_log.ldf |
Temp database | ||||||
temp | ROWS Data | PRIMARY | 1000 MB | By 64 MB, Unlimited | On Disk 3 - temp DB | tempdb.mdf |
temp_log | LOG | - | 100 MB | By 64 MB, Unlimited | Disk 2 - transaction logs | tempdb.ldf |