We are currently running SQL Server 12.
Our working database (not System Databases) is PrimaryErp and referenced in our projects using the familiar dbo syntax.
Currently, to do backups, we right-click the database from Microsoft SQL Server Management Studio (MSSMS), select Tasks > Back Up....
We have a similarly named database called PrimaryErp_Archive that these backups are restored to.
Management has learned that the database can be backed up differently. Both the Live and the Archive databases can have the same names. Live would still be referenced with the familiar dbo prefix; however, Archive could be prefixed with archive or backup.
Management simply told me this would be better, without explanations.
How is this better?
And, more importantly, how do I do it?
As a Bonus: Is there a way this database backup technique could reliably be done in in C# code, or would I need to always do this from within MSSMS? I know how to code in C# much better than I know my way around MSSMS.