What are the commands We use to do physical backups?

 is backup taken is in binary format(.bak/.trn)?

is there any control file sql server read during startup as Memory Initailsation(awe Eanble or not) Etc.?

How can we manually rollback and forward transactions during startup or can we read Transaction log?

Hi,

Use can either use Management Studio or TSQL command that is "BACK DATABASE" for backing up. Backup are saved as binary file with the extension of "bak" (or you can give any extension).

I have not come across any control file like that but you can set up various things. For example, you can set AWE by using server property, you can set a stored procedure to run at startup by using sp_procoption.

You cannot read the transaction log unless you use a thrid-party tool. SQL Server automatically roll forward committed transactions and roll back uncommitted transaction at the startup. You do not want to do it manually.