Hi

I'm trying to move the data folder where the db's are kept for SQL
Server 2005 from the C drive to the local D drive.

I've followed this article
http://support.microsoft.com/default...b;en-us;224071

Once detaching the database (Adventureworks say) the file won't move
(access denied). I guess it's locked. Stopping SQL Server doesn't make
any difference.

Also want to make sure new databases are created here by default. Also
the permissions for the SQL data folder is a bit weird, one of the
users is called:

SQLServer2005MSSQLUser$MYSERVER$MSSQLSERVER
(MYSERVER\SQLServer2005MSSQLUser$MYSERVER$MSSQLSER VER)

Bit of a long name and I can't assign that to my new data folder on the
new drive.

Does anybody have experiences on moving the databases over here. If
it's easier I'll remove/reinstall SQL server (it's a new install
without crititical data), however I couldn't see an option for where
the data goes by default).

Does anybody have experiences on moving the databases over with SQL
Server 2005?

Many thanks

Alex

Hi

I just tried this and seem to have the same problem with Adventureworks but
I could move other user database. Even stopping all services and re-booting
didn't help. In the end I just deleted the files and re-installed from
http://www.microsoft.com/downloads/d...displaylang=en
When you run the msi you can specify the new location.

Now I seem to be able to move the adventureworks database without issue.

John

<postings (AT) alexshirley (DOT) com> wrote