We have installed Microsoft SQL Server 2005 to the deafult folder. However, we have another larger drive for our database files. We have changed the Server Properties > Database Settings to have the correct "Database default locations" that we want. However, when we use the Copy Database Wizard to bring over the many user databases on our existing server, the wizard always uses the original installation folder as the Destination Folders.
Is this a bug, or is there some way to change the defaults for these folders so we don't have to on every one?
Thanks
I have the same problem but by mistake I've found a way to modify the destination folder. On the grid with the destination folder click the one with the path. A label will appear over the grid and then you could edit the path. Cheers and hope that this will help you.
No comments:
Post a Comment