How To install SQL Server 2005 on External HDD
-
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.
-
have you looked at the SQL Server 2005 Setup Log Files?
there will be an entry in there with a description of the error
-
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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
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..
-
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 recoverabilityWe walk in the dark places no others will enter
We stand on the bridge and no one may pass -
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