How To Create Backup In SQL Server

1 Copy Only Backup

Syntax:-

          Backup Database Database Name To Disk ='Path' With Copy_Only;

Example:-

         Backup Database College To Disk ='F:\Bb\College.Bak'WITH COPY_ONLY;

2 Full Backup

Syntax:-

          Backup Database Database Name To Disk ='Path' With Format;

Example:-

          Backup Database College To Disk ='F:\Bb\College1.Bak'WITH Format;