>>Hi,
>>
>>When I bring up Back Up Database from the SSMS I see two fields that I need to clarify my understanding:
>>
>>1. Backup to (disk) (e.g. "c:\Program Files\Microsoft SQL Server\MSSQL2\MSSQL\Backups\MyDatabase.bak
>>
>> I understand that MyDatabase.bak has not one but many backs, correct? And I don't seem to be able to change this name (it is grayed). Correct?
>>
>>2. Name: (e.g. MyDatabase-Full Database Backup). This name I can change. Do I understand correct that the inside MyDatabase.bak there will be a backup under this name that I will (if necessary) be able to restore?
>>
>>TIA.
>
>1. You should be able to change that file name and chose a place for backup. (just click on Add button to specify your own name)
>
>2. This name essentially means nothing (e.g. it's not important).
>
>Generate the script from SSMS and look at it and compare with the BOL syntax.

Whenever someone says that "this is not important for you to know" I tend to focus on these things more <bg>.

For some reason I remember either seeing or reading somewhere that the .bak contains all backups created for the database. I was just wondering how (if becomes necessary) I can restore this or that specific back.

What is BOL?

Thank you for your help.