|
|
You're in the
sql server new users
group:Recover Model Database
sql server new users:
Do you have a backup of model database? [quoted text, click to view] "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!!! >
Gabe
[quoted text, click to view] > tempdb is skipped. You cannot run a query that requires tempdb Is it an error?[quoted text, click to view] "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!!! >>> >> >> > >
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 [quoted text, click to view] "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!!! >>>>> >>>> >>>> >>> >>> >> >> > >
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!!! >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
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 [quoted text, click to view] "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!!! >> > >
Yes, it is an error.
- Gabe [quoted text, click to view] "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!!! >>>> >>> >>> >> >> > >
Don't see what you're looking for? Try a search.
|
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |