> Thanks for the reply. I tried this and received the following:
>
> Msg 5133, Level 16, State 1, Line 1
> Directory lookup for the file "C:\Program Files\Microsoft SQL
> Server\MSSQL\data\master.mdf" failed with the operating system error
> 3(The
> system cannot find the path specified.).
> Msg 3156, Level 16, State 3, Line 1
> File 'master' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL\data\master.mdf'. Use WITH MOVE to identify a valid
> location for
> the file.
> Msg 5133, Level 16, State 1, Line 1
> Directory lookup for the file "C:\Program Files\Microsoft SQL
> Server\MSSQL\data\mastlog.ldf" failed with the operating system error
> 3(The
> system cannot find the path specified.).
> Msg 3156, Level 16, State 3, Line 1
> File 'mastlog' cannot be restored to 'C:\Program Files\Microsoft SQL
> Server\MSSQL\data\mastlog.ldf'. Use WITH MOVE to identify a valid
> location
> for the file.
> Msg 3119, Level 16, State 1, Line 1
> Problems were identified while planning for the RESTORE statement.
> Previous
> messages provide details.
> Msg 3013, Level 16, State 1, Line 1
> RESTORE DATABASE is terminating abnormally.
> "Allan Mitchell" wrote:
>
>> Hello J_70,
>>
>> DTS will not IMPORT this file although we could RESTORE.
>>
>> Go to SSMS and get a new query window. You can now issue
>>
>> RESTORE DATABASE <name> FROM DISK = '<Path to .bak>'
>>
>> <name> does not have to exist already
>>
>> --
>>
>> Allan Mitchell
>> http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com
>> |
>> http://www.konesans.com
>>> I have a SQL server backup from an unknown version. It is a *.bak
>>> file and I would like to restore the database. We run SQLServer 7.0.
>>> Could someone point me in the right direction about how to get
>>> started. I've run DTS Import but when I specify OLE DB provider, I
>>> do not seem to get an option to select the database I want to
>>> import. TIA.
>>>