Re: Select from occupancy numfiles aberration

2017-12-13 Thread Schofield, Neil (Contractor - Storage & Middleware, Backup & Restore)
Classification: Public Classification: Public Richard If by 'accumulator' you mean that the NUM_FILES column is actually showing the sum of the current row and the previous row/rows then I don't think this is the case. It looks to me like there is an implicit ORDER BY NUM_FILES on the select

Re: Using TDP to backup NDF files

2017-12-13 Thread Harris, Steven
Bill There is an option in TDP to back up a file group. I've never understood what it is for. Looking online for information about NDF files, that same term, "file group", popped up. So, I'd start there are see if that fits your use case. Cheers Steve Steven Harris TSM Admin/Consultant

Re: Select from occupancy numfiles aberration

2017-12-13 Thread Richard Cowen
Has anyone seen a case when a select from occupancy returns rows where the NUMFILES columns is acting as an accumulator? SP 7.1.7.100 The command. select NODE_NAME,TYPE,FILESPACE_NAME,STGPOOL_NAME,NUM_FILES,PHYSICAL_MB,LOGICAL_MB,REPORTING_MB,FILESPACE_ID from occupancy Here is a sample

Using TDP to backup NDF files

2017-12-13 Thread Bill Boyer
Is there a way to backup NDF files as part of the database backup? I have a customer with a database with an NDF file the use for 'archiving'. That doesn't get included as part of the TDPSQLC BACKUP * FULL command. How can I get that included in the SQL backup of the server? Or do I need to use