2005

Question

Post reply

2005

jass.jerry

SSC Journeyman

Points: 79
More actions
January 19, 2008 at 10:26 pm

#185706

Hello,
I recently installed SQL 2005 it didn't give me the option to select which partition I want my Database and Logs on, I have D and E Partition, D for databse and E for logs how do I fix this without reinstalling the whole thing.
Jack

Viewing 5 posts - 1 through 4 (of 4 total)

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

russell-154600 Ten Centuries Points: 1375 More actions · Answer 1

sp_detach_db 'dbname'

then copy/paste files to desired location

then

sp_attach_db 'data file path', 'log file path'

when u see everything working right, delete original files that u copied.

see here as well

Jeff Moden SSC Guru Points: 1004312 More actions · Answer 2

... and, if you're really smart, do a backup first.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Steve Jones - SSC Editor SSC Guru Points: 736162 More actions · Answer 3

There's a place to change the default file locations in the server properties, Database Settings.

I'd do the detach, attach listed above.

russell-154600 Ten Centuries Points: 1375 More actions · Answer 4

Jeff Moden (1/20/2008)
... and, if you're really smart, do a backup first.

LOL. TRUE TRUE