Setting data/log file locations in SQL Server 2005 not working when upsizing from Access.
Posted on 2008-09-29
I am trying to upsize a large Access database to SQL Server 2005. I have limited space in the normal location where SQL Server creates its data and log files (namely, folder C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data). In Management Studio, I opened the properties for the server, selected Database Settings, and changed the "Database default locations" for Data and Log to a larger volume. (Happens to be Z:\SQL-Data.)
When I use Integration Services to import data into a new database, it uses the location I have specified (the Z: drive). However, when I run the Access Upsizing Wizard, the data and log files are still being created on the C: drive. I'm guessing there is a registry key that could be changed, but I would prefer to know where this file path can be designated within the Managment Studio or some other utility. Thanks!