<div>
Thanks a lot.., I am able to get the logical name.<br />
<br />
Please let me know is it possible to get the database name.., if yes how..?<br />
<br />
<br />
Waiting for reply.<br />
<br />
Regards,<br />
R S
</div>


Thanks a lot.., I am able to get the logical name.

Please let me know is it possible to get the database name.., if yes how..?


Waiting for reply.

Regards,
R S

<div>
Hi,<br />
<br />
How can I get the database name if I know the .bak file name.<br />
<br />
Regards,<br />
R S
</div>


Hi,

How can I get the database name if I know the .bak file name.

Regards,
R S

<div>
RESTORE HEADER ONLY FROM DISK = 'c:\yourfile.bak'<br />

</div>


RESTORE HEADER ONLY FROM DISK = 'c:\yourfile.bak'


<div>
sorry without space in between...<br />
<br />
RESTORE HEADERONLY FROM DISK = 'c:\yourfile.bak'<br />

</div>


sorry without space in between...

RESTORE HEADERONLY FROM DISK = 'c:\yourfile.bak'


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Please let me know how can i retrieve the logical file name if I have the .bak file i.e I want to know the file name for mdf and ldf files.<br />
<br />
Regards,<br />
R S
</div>
</div>


Hi,

Please let me know how can i retrieve the logical file name if I have the .bak file i.e I want to know the file name for mdf and ldf files.

Regards,
R S

Retrieve logical file name from .bak 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.