image

How to Backup Microsoft SQL Database by Using Transact-SQL

Create a full database backup by executing the BACKUP DATABASE statement to create the full database backup, specifying: The name of the database to back up.The backup device where the full database backup is written.The backup options like COPY_ONLY, COMPRESSION, etc. COMPRESSION will be very helpful to reduce the backup size.COPY_ONLY is very useful for Read More