>Hi,
>
>I am working on a script which should be able to restore a full sql server
>2000 automatically. When I do a full restore of the system databases the
>file locations of the mdf and ldf files don't change but when I restore the
>differential backup the ldf file places it self in the default directory of
>Microsoft SQL Server.
>
>So my script looks like this:
>
>restore database model from disk = 'c:\backup\model.bkf' with norecovery,
>replace
>go
>restore database model from disk ='c:\backup\modeldiff.bkf' with
>recovery,replace
>go
>
>The model log file should go into "e:\database\data\" but instead it goes
>into "C:\Program Files\Microsoft SQL Server\MSSQL\Data"
>
>why does it work fine when I do like this:
>
>restore database model from disk = 'c:\backup\model.bkf' with recovery,
>replace
>
>but not when I want to do a diff restore???
>
>I know I can detach and attach the model database, but then I also have to
>stop and start the database with a trace flag - not very pretty....
>
>
>Any ideas???
>
>Christoffer
>

>
>"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
>news:47dl81t4qahcv4l8gjbrb6c8oo934vl09p@4ax.com...
>> You can view the physical files from the backup using
>> restore filelistonly.
>Correct, I can view the paths with restore filelistonly and it shows the
>correct file locations.
>
>> If you need to have the files in
>> another location, use the move option in the restore script
>> to specify the physical file locations.
>No, You cannot use the move option with system databases.
>

>
>"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
>news:3s9m811b194jc1qs0v74kugnhqcfg2c4lo@4ax.com...
>> Yes you can use with move. You can follow the example in the
>> following knowledge base article:
>> http://support.microsoft.com/?id=304692
>>
>
>In the article is mentioned the following:
>
>NOTE: These instructions in this article do not apply to SQL Server 2000.
>
>The response from the server is :
>tempdb is skipped. You cannot run a query that requires tempdb.
>