November 3, 2006 at 3:05 am
Hi,
I currently work for a number of clients, and one of my clients decided to add some new data files to the primary file group, even though there is only one disk. This in itself is not really a problem, but when I need size the database correctly, I need to take into account the two files.
Is there a way for me to merge these two files together? I could then size the database properly.
Thanks
Peter Gadsby
Peter Gadsby
Business Intelligence Consultant
www.hgconsult.co.uk
November 3, 2006 at 3:22 am
why don't you modify your script to take account of multiple files?
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
November 3, 2006 at 3:31 am
Because I don't know which tables have been allocated to which file because the new files have been added to the primary filegroup. Therefore I don't know how to correctly size each file.
Peter Gadsby
Business Intelligence Consultant
www.hgconsult.co.uk
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply