<div>
Have a look here, depends if your master database is down and how much of the system is down..:<br />
<a href="http://support.microsoft.com/default.aspx?scid=kb;en-us;307775" rel="ugc">http://support.microsoft.com/default.aspx?scid=kb;en-us;307775</a><br />
<br />
<br />
Is SQL Server still available or has everything been lost ? (including your OS ??)...<br />

</div>


Have a look here, depends if your master database is down and how much of the system is down..:
http://support.microsoft.com/default.aspx?scid=kb;en-us;307775 [http://support.microsoft.com/default.aspx?scid=kb;en-us;307775]


Is SQL Server still available or has everything been lost ? (including your OS ??)...


<div>
Please also bear in mind if you have to reinstall SQL-Server you need to patch up to the last known version to allow a restoration of the system databases/user databases:<br />
<a href="http://support.microsoft.com/default.aspx?scid=kb;en-us;264474" rel="ugc">http://support.microsoft.com/default.aspx?scid=kb;en-us;264474</a>
</div>


Please also bear in mind if you have to reinstall SQL-Server you need to patch up to the last known version to allow a restoration of the system databases/user databases:
http://support.microsoft.com/default.aspx?scid=kb;en-us;264474 [http://support.microsoft.com/default.aspx?scid=kb;en-us;264474]

<div>
<div class="content wysiwyg-content">
I have SQL Server 2000 which is backed fully backed up every night. This is an open database backup. The hard disk has crashed and I would like to restore it. Can someone tell me a step by step procedure of restoring the full database once the hard disk is replaced. The backup is taken on hard disk and this file is copied onto a tape every night. I have a copy of this file from last night. This is quite urgent as its a production DB. Can someone help please.
</div>
</div>


I have SQL Server 2000 which is backed fully backed up every night. This is an open database backup. The hard disk has crashed and I would like to restore it. Can someone tell me a step by step procedure of restoring the full database once the hard disk is replaced. The backup is taken on hard disk and this file is copied onto a tape every night. I have a copy of this file from last night. This is quite urgent as its a production DB. Can someone help please.

How to Restore SQL Server after hard disk crash ?

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.