Post reply

How To install SQL Server 2005 on External HDD

  • October 20, 2010 at 4:23 am

    #225292

    Hi all, I am new in this forum, my name Eddy..

    I got the problem in instaling sql server 2005 on my external HDD, when I installed sql server I choose installation path on G:\program files\microsoft sql server\

    all the step was running well but when I was in "SQL Server Database Services" Step, an error occur say ' The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." '

    I cannot fix the problem even I have tried searching on internet.. can someone help me, This is for my thesis, I need help.. thanks.

  • October 20, 2010 at 4:38 am

    #1239563

    have you looked at the SQL Server 2005 Setup Log Files?

    there will be an entry in there with a description of the error

  • October 20, 2010 at 4:44 am

    #1239570

    eddywibowo89_new (10/20/2010)

    I got the problem in instaling sql server 2005 on my external HDD,

    Ok, I'm curious... Why would you install SQL onto an external drive?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 20, 2010 at 1:55 pm

    #1239903

    hi steveb, where can I check setup log files? if I have check that, what should I do? sorry I am not expert in sql server 🙁

    hi gilamonster, oh this is my thesis, I make a data warehouse system in my thesis company, and the .bak file must be restore. It's size was 30GB, in the other hand my remaining space in C:\ only 9GB and another partition(D:\) only 8.9GB..

    so I need install in external HDD to restore the database..

  • October 20, 2010 at 2:03 pm

    #1239908

    Where you install the SQL executable and where the database files are is totally unrelated. You can (as I have) install SQL into the default location (c:\Program files...) and, during setup, specify a completely different location for default database location. Plus you can restore a database and put its files anywhere that the SQL service has access to.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 22, 2010 at 12:32 am

    #1240730

    hm okay I will try it first.. but last time when I try to restore database in eksternal drive, it gets an error. I forgot what the error said, but I will check it first.. Thanks GilaMonster 😀

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply