Recover SQL Server v8 database on 2005?

I have managed to attach a database to my new instance of SQL Server 2005. The database orignally went into suspect mode on SQL Server v8.0. I have managed to get it into emergency mode but cannot see any tables. DBCC CHECKDB etc do not work. I get the error saying to upgrade the database to the newest version.

Any ideas? Thanks in advance!

What is the error you get that causes it to go suspect?

Try ALTER DATABASE <dbname> SET ONLINE to see the error.

|||

Part of attaching a database from an older version of SQL on a newer instance involves making any required alterations to the database structure needed by the new version.

If the database was suspect on SQL 2000 before it was detached, that may well prevent those alterations from happening.

Why are you trying to attach this database to a newer version of SQL instead of resolving the suspect status before moving it?

|||The mdf and ldf files were recovered from a failing RAID array before the whole thing died. So there is not actually a way to attempt a repair on the original system.
|||Kevin,
Will attaching these data files to a SQL Server 2000 make difference , could be a different hardware

Thanks
Vishal|||I agree, I would try and get the database back to a SQL2K instance, fix your problems there and then move to 2005.|||

Vishal Gandhi wrote:

Kevin,
Will attaching these data files to a SQL Server 2000 make difference , could be a different hardware

Thanks
Vishal

Yes, because the SQL 2000 instance will not need to perform the upgrade step prior to bringing the database online.

|||Hi,

If you used sp_resetstatus to make the db status to emergency mode, then you should restore the db using the latest backup available.

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

Recover database

Hi

I've had a powerfailure, that resulted in I had to scratch my DB server, I've managed to get all the .mdf and .ldf files from the server. On the new server I get a "Error 823: I/O error (torn page)" when I'm trying to attach the .mdf file to the New server.
Both the new and the old server is a win2003 with SQL 2000 SP3

Is there anybody who knows how I can recover the DB?

/Runetry a restore to a blank database...