Sql Server 2005 - Moving data folder

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.aspx?scid=kb;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$MSSQLSERVER)

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

.

Relevant Pages

  • Re: Side-by-side upgrade - moving master, msdb and model
    ... MVP - Windows Server - Clustering ... "In some cases, you may want to copy the system databases, including ... from the source SQL Server 2000 instance to the SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: AS2005 ... what is wrong with it?
    ... What I have seen is that the dev server is *faster* than the prod server ... And does your dev server also have all 6 databases with all these roles? ... When I restore the "PROV" i got approx 20 sec. ... Starting from an empty data folder should show if this theory is true ...
    (microsoft.public.sqlserver.olap)
  • Re: BizTalk Server 2004 ConfigFramework.exe error
    ... one BizTalk is installed on? ... machines (both for SQL and DTC) is not blocked by firewalls and new MSDTC ... Multi-computer configuration using Windows Server 2003 or Windows XP ... >>all associated databases. ...
    (microsoft.public.biztalk.general)
  • RE: Clustering a standalone SQL server + storage array
    ... working as expected with out error your ready to install sql server. ... log files to the data and log shared drives you setup as part of the cluster. ... Our apps team look after a trading system that uses an HP DL360 server ... running SQL 2000 SP3a with a few small databases on it. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Side-by-side upgrade - moving master, msdb and model
    ... MVP - Windows Server - Clustering ... "In some cases, you may want to copy the system databases, including the ... from the source SQL Server 2000 instance to the SQL ...
    (microsoft.public.sqlserver.clustering)
Loading