Thanks for the link. I was able to get the entire server running again on
the cluster. Just need to restore the model from backup (i was able to
create a new one)
i issue:
RESTORE DATABASE model
FROM DISK = 'g:\model\model_db_200706242000.BAK'
WITH MOVE 'modeldev' TO 'G:\Program Files\Microsoft SQL
Server\MSSQL\Data\model.mdf',
MOVE 'modellog' TO 'G:\Program Files\Microsoft SQL
Server\MSSQL\Data\modellog.ldf'
i recieve:
Server: Msg 3156, Level 16, State 1, Line 1
File 'modeldev' cannot be restored to 'G:\Program Files\Microsoft SQL
Server\MSSQL\Data\model.mdf'. Use WITH MOVE to identify a valid location for
the file.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
at a lose!!!
Thanks for any help,
- Gabe
[quoted text, click to view] "Uri Dimant" <urid@iscar.co.il> wrote in message
news:%23%23X0s2wtHHA.3544@TK2MSFTNGP03.phx.gbl...
> Gabe
> I have never restored master when trying to move a SQL server. I usually
> script logins and jobs for transfer and restore only the user databases.
>
http://msdn2.microsoft.com/en-us/library/aa213790(SQL.80).aspx
>
>
> "Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
> news:uP8HfswtHHA.2108@TK2MSFTNGP02.phx.gbl...
>> Yes, it is an error.
>> - Gabe
>>
>> "Uri Dimant" <urid@iscar.co.il> wrote in message
>> news:edKaC8vtHHA.484@TK2MSFTNGP06.phx.gbl...
>>> Gabe
>>>> tempdb is skipped. You cannot run a query that requires tempdb
>>> Is it an error?
>>>
>>>
>>>
>>>
>>> "Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
>>> news:OprCNZvtHHA.412@TK2MSFTNGP04.phx.gbl...
>>>> yes i do, i try to restore it but i get this error..
>>>>
>>>> tempdb is skipped. You cannot run a query that requires tempdb
>>>>
>>>>
>>>> "Uri Dimant" <urid@iscar.co.il> wrote in message
>>>> news:up$BjYutHHA.4572@TK2MSFTNGP02.phx.gbl...
>>>>> Gabe
>>>>> Do you have a backup of model database?
>>>>>
>>>>> "Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
>>>>> news:ek6F7SutHHA.3480@TK2MSFTNGP04.phx.gbl...
>>>>>> SQL 2000.
>>>>>> I was trying to move the system files, I managed to move the master,
>>>>>> msdb, tempdb but then it died on the model. and I need to recover
>>>>>> database... the sql service keeps failing. thank you!!!
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
