Hello, I have a tempdb with a few devices, each device was created for data or log as it is recomended to keep them separate. My problem now is I need to take out a few of those devices that the tempdb is atached too, to then move them to a tempdb2 thats going to be created. I know that the database ihas to be dropped to then move the devices but ASE dosnt let me. Please help me my job depends on this.
thank you in advance and sorry i for my english
ps. tempdb needs to stay on the server. Just to make it simple if i didn't make my self clear is that i need to move the tempdb devices and move them to a tempdb2