Question

how to do backup entire database?

Answer 1

To backup entire database, use following syntax;

BACKUP DATABASE { database_name }

TO backup_device [ ,...n ]

[ MIRROR TO clause ]

[ WITH { DIFFERENTIAL | [ ,...n ] } ];