Local Drive Partition

[mreigler]

I have a Windows 2003 Standard Edition Server with a 2 drive raid 1 configuration. The logical drive is partitioned into 4 partitions (C:\, F:\, T:\, and X:\). One of the hard drives failed. After replacing the drive and getting the server back up and running, SQL server 2005 no longer sees the F:\, T:\, or X:\ partitions. When I try and restore a backup (putting the log file on T:\ I get an invalid path error.

Mike Reigler
Melange Computer Services, Inc

 

[ptheriault]

You have to change your restore path in the database restore wizard or if you are using TSQL you have to use the "with move" option.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mreigler]

That's the problem, the restore wizard is not recognizing T:\ as a valid local drive. IF I use "with move" I get:

Msg 5133, Level 16, State 1, Line 1
Directory lookup for the file "T:\dbname_log.ldf" failed with the operating system error 3(The system cannot find the path specified.).




Mike Reigler
Melange Computer Services, Inc

 

[mreigler]

Nevermind.

Turns out a colleague mis-communicated the server name. We where running the restore on a backup server that doesn't have the drives partitioned.

Oops.

Thanks

Mike Reigler
Melange Computer Services, Inc