SQL Server files after upgrading an Access database

[jbguernsey]

Hi all

I have upgraded an Access data file to SQL Server using the wizard
(Access XP, 2000 file format). There seems to be no way to direct the
SQL Server database files to a specified folder during this process. I
now have the SQL Server database residing on a server on drive C: but
it would be better on drive E: Does anyone know of a simple way to
move the SQL Server database or force the upgrade to go to a specified
folder?

I know little about SQL Server, so please be gentle ...

Thanks

Jeff

[Rich P]

Hi Jeff,

I have never used the upsizing wizard, but to move a sql server database
from one location to another, you need to detach the sql server database
from the server. You do this in Enterprise manager(sql server 2000) -
or the management console (sql server 2005).

Go to the database icon in Enterprise manager - right - click - go to
All Tasks, go to Detach Database - and click on Detach Database.

Now go to your server and move the mdf file to your desired location.
Then you have to re-attach the database. Just right click on the
Databases icon under the server name in Enterprise Manager. Go to All
Tasks - Attach Database. Click on Attach Database. Locate/select the
mdf file and click OK. Sql Server will automatically create a new ldf
file for you.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[jbguernsey]

Thanks Rick. I'll give that a try ASAP. Looks to be just what I
needed - thanks again.

Jeff
Rich P wrote:

Hi Jeff,

I have never used the upsizing wizard, but to move a sql server database
from one location to another, you need to detach the sql server database
from the server. You do this in Enterprise manager(sql server 2000) -
or the management console (sql server 2005).

Go to the database icon in Enterprise manager - right - click - go to
All Tasks, go to Detach Database - and click on Detach Database.

Now go to your server and move the mdf file to your desired location.
Then you have to re-attach the database. Just right click on the
Databases icon under the server name in Enterprise Manager. Go to All
Tasks - Attach Database. Click on Attach Database. Locate/select the
mdf file and click OK. Sql Server will automatically create a new ldf
file for you.

Rich

*** Sent via Developersdex http://www.developersdex.com ***