Recover Model Database

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!!!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!!!
>|||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...
>|||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...
>|||Yes, it is an error.
- Gabe
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:edKaC8vtHHA.484@.TK2MSFTNGP06.phx.gbl...
> Gabe
> Is it an error?
>
>
> "Gabe Matteson" <gmatteson.rounder.com.nospam> wrote in message
> news:OprCNZvtHHA.412@.TK2MSFTNGP04.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...
>|||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
"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...
>|||resolved!
thanks all.
"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!!!
>