Recovery Mode is changing

SQL Server 2000. We set the recovery mode for the msdb to full. When we check it a few days later, recovery mode set itself to simple. No set pattern, no consistency as far as we can see.Originally posted by littleccguy
SQL Server 2000. We set the recovery mode for the msdb to full. When we check it a few days later, recovery mode set itself to simple. No set pattern, no consistency as far as we can see.

Just curious...does it make coffee for you too when you get in in the morning?

Seriously doubt it...

How many people have access to the box?|||I have to agree with Brett ! There has to be someone doing it. Or try running a Tace on MSDB for a week (you can select filters and options to keep the size to minimum)

Recover the DTS packages

Hello, everyone:
A guy think that the DTS packages can be recoved by restore MSDB database. Is that true? Does anyone have experience on that? Thanks.
ZYThi's rihgt|||DTS packages can be saved in the sysdtspackages table of the MSDB database in SQL Server. DTS packages can also be saved outside of SQL Server in Meta Data Services, a structured storage file or a Visual Basic file.

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!!!
>

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!!!
>

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!!!
>

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!!!
>

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...
>> 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
> 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!!!
>>
>|||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!!!
>>
>>
>|||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!!!
>>
>>
>>
>|||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...
>> 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!!!
>>
>>
>>
>>
>|||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!!!
>