<div>
Which version of sql server are you using? SQL Server 7.0 does not support restore of a single table if I am not mistaken. As far as restoring form a datafile is concerned the syntax is<br />
<br />
RESTORE DATABASE MyNwind <br />
FROM DISK = 'c:\mssql7\backup\MyNwind.<wbr />bak'<br />

</div>


Which version of sql server are you using? SQL Server 7.0 does not support restore of a single table if I am not mistaken. As far as restoring form a datafile is concerned the syntax is

RESTORE DATABASE MyNwind
FROM DISK = 'c:\mssql7\backup\MyNwind.bak'


<div>
<div class="content wysiwyg-content">
hi <br />
how to retore a database from a .dat file..<br />
and how to retore a single table from a database.
</div>
</div>


hi 
how to retore a database from a .dat file..
and how to retore a single table from a database.

MS SQL SERVER -restore database from .dat file

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.