Is it possible to export a SQL Server database (data, structures) without its users ?
If yes, is it possible using SSMS ?
There is a way to get the result you're after but it's not a backup and should not be considered as such (see gbn's answer to understand why).
This is a handy tool for generating scripts that you might use in an application installer and to prime your application's database with objects such as stored procedures, views reference tables and data. But it's not to be used as a mission critical backup.
On the second page you can choose what to script:
Just make use "Users" is not selected.
On the next page select the
The Advanced Scripting Options window allows you to pick and choose what to script and how to script it. If you want to script the data as well as the schema then choose
Again and just to re-iterate, this is not considered a reliable or sanctioned method to backup a database.
No. Users can:
If users were stripped out you break the database
If you want to export all data and scripts then you can skip users that way.