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.
"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