If you want to export / save all data of a database into a. sql file, do this: Right click on the database in sql server management studio tasks -> generate scripts script entire database and all database … I've checked the remember password option in sql server management studio when logging in to the database.