MS SQL 2000 DB recovery

well here i am trying to recover an MS SQL 2000 server and
i don't have a clue in what is involved.
The server had a single IDE drive and it crashed on me! So
now i have to figure out how to restore this guy without
knowing what to do. here is what i did:
Reinstalled win 2k server on it
dumped system_state from tapes
restored all c: and d: from full backup (mssql what
installed on c:, d: was just for daily backups of the DBs)
I'm just wandering if there is a proper method of restore
(transaction logs and stuff) that i need to follow'
Can enybody explane me what is the right procedure to
restore a MS SQL server from backup?
Please help!!It depends on what you have. If you have the .mdf and .ldf
files, these are the database files. You can use
sp_attach_db and be back in business very quickly.
If you have .bak files, this is a backup file and you need
to restore it. As you are not experienced with SQL Server
use enterprise manager. BOL has a step by step guide to
take you through the process. (Search on restoring)
Regards
John|||Hi John,
I forgot to mention that i have both files... bak
and .mdf and .ldf files...
>--Original Message--
>Hi John,
>Thanks for your reply... i do have the lattest bak file
>can i just restore it from this file. Do i need to create
>the server from scratch create the exact tables and then
>restore from all the bak files?
>Jeff
>>--Original Message--
>>It depends on what you have. If you have the .mdf
>and .ldf
>>files, these are the database files. You can use
>>sp_attach_db and be back in business very quickly.
>>If you have .bak files, this is a backup file and you
>need
>>to restore it. As you are not experienced with SQL
Server
>>use enterprise manager. BOL has a step by step guide to
>>take you through the process. (Search on restoring)
>>Regards
>>John
>>.
>.
>|||If you have the .mdf and .ldf, that would be quicker. Copy
them to a server that has SQL Server installed. Use
sp_attach_db to attach them. Depending on size of the
database and server configuration, it will take from a few
seconds to a minute or two., and then you will have a
working accessable database.
If you use the .bak you will need to do a full restore,
which will take longer.
You do not need to create anything prior to the attach or
restore. All you need is an installation of SQL Server.
Attach just lets the master database know it has a new
database attached to it. Restore will build the database
from scratch including tables indexes etc as well as
restoring the data.
Check Books on line for full details.|||Thx John,
I appriciate your time and your help.. i'll let you know
how it goes ;)
>--Original Message--
>If you have the .mdf and .ldf, that would be quicker.
Copy
>them to a server that has SQL Server installed. Use
>sp_attach_db to attach them. Depending on size of the
>database and server configuration, it will take from a
few
>seconds to a minute or two., and then you will have a
>working accessable database.
>If you use the .bak you will need to do a full restore,
>which will take longer.
>You do not need to create anything prior to the attach or
>restore. All you need is an installation of SQL Server.
>Attach just lets the master database know it has a new
>database attached to it. Restore will build the database
>from scratch including tables indexes etc as well as
>restoring the data.
>Check Books on line for full details.
>.
>|||Thanks for all your help john... that worked fine!!!
Jeff
>--Original Message--
>If you have the .mdf and .ldf, that would be quicker.
Copy
>them to a server that has SQL Server installed. Use
>sp_attach_db to attach them. Depending on size of the
>database and server configuration, it will take from a
few
>seconds to a minute or two., and then you will have a
>working accessable database.
>If you use the .bak you will need to do a full restore,
>which will take longer.
>You do not need to create anything prior to the attach or
>restore. All you need is an installation of SQL Server.
>Attach just lets the master database know it has a new
>database attached to it. Restore will build the database
>from scratch including tables indexes etc as well as
>restoring the data.
>Check Books on line for full details.
>.
>