>>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham