Re: Individual database backup/restore

In article <337B5311.6602@netcomuk.co.uk>, Neil Truby <ntruby@netcomuk.co.uk> writes >Kevin Page wrote: >........ >> I have about 20 or 30 databases and splitting them up into there own >> dbspaces is just not a practical option. >> >Why? > >Neil Truby >Chase Manhattan Bank >Bournemouth, UK Each database has its own workload which will be running at different times of the day. For performance reasons I need to split each database over several disks, this means that each database will have several chunks allocated to it so any one disk could have upto 30 different chunks on it ! It make for a bit of an administration nightmare if one of the tables in a chunk on the centre of the disks grows beyond its predicted size as I would then have to allocate another chunk for it on the outside edge of the disk. -- Kevin Page Turnpike evaluation. For information, see http://www.turnpike.com/