Re: Sql Server 2005 - Moving data folder

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/details.aspx?FamilyId=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&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@xxxxxxxxxxxxxxx> wrote in message
news:1135860899.084363.176670@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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: Got an Exception error - still
    ... it looks to me like you are trying to attach the adventureworks database which is made for sql2005 with sql2000, ... I tried using Enterprise Manager for SQL 2000. ...
    (microsoft.public.sqlserver.setup)
  • RE: SQL 2005 SP1 Database Mirroring
    ... Die Dienste SQL Server, SQL Server Agent und SQL Server Browser werden mit ... ALTER DATABASE [AdventureWorks] SET RECOVERY FULL WITH NO_WAIT ...
    (microsoft.public.de.sqlserver)
  • Re: Got an Exception error - still
    ... Error 602 can certainly indicate database corruption, ... you're connected to an instance of SQL Server 2000. ... "AdventureWorks". ...
    (microsoft.public.sqlserver.setup)
  • Re: Got an Exception error - still
    ... I uninstalled the AdventureWorks from the the control panel then I ... I tried using Enterprise Manager for SQL 2000. ... Could not open new database ... install put it in the wrong place. ...
    (microsoft.public.sqlserver.setup)
  • Re: Got an Exception error - still
    ... On the screen to attach the database, the only choice is adding the mdf. ... Once the mdf is chosen, both the mdf and ldf files appear below in thebox. ... "AdventureWorks". ... I think I have SQL 2005 Express and SQL 2005 on my PC. ...
    (microsoft.public.sqlserver.setup)