How to properly create backup for Microsoft SQL Database?

Hello Tomas, 

It is possible, the default configuration can help you backup databases normally with simple recovery model. To perform the backup of bulk-logged or full databases, we would need to tweak the vRanger quiesce script. Due to the complexity, I would rather recommend you to create a support case if possible and we can gladly help you on a remote session to accomplish what you are trying to do.  

Hi Tomas,

From the vRanger inventory screen if you right click on VM you will see option to set up VSS tools. Once you click on that you will see the option you will see the option to truncate logs. 

If you need further assistance setting up VSS tools or you are having issues with log truncation I would suggest opening up a support case. 

You can take backup of Microsoft SQL database by two ways:

1. Using SQL Server Management Studio

• Open Microsoft SQL Server Management Studio
• Connect to the "ServerName\Instance" of the server that has the DB you want backed up.
• Expand the Databases tab to get to the DB you want to back up.
• Right click the desired DB --> Tasks --> Back Up...
• Set "Backup Type" to "Full"
• Go through the rest of the General and Options tab information to set the options to what you want.
• Click OK to start the Backup process.

2. Using T-SQL

• Specify path to store database backups
• Specify backup file name format
• Select list of databases to backup
• Loop through databases
• Programmatically create database backup command using database name, path and file name format
• See attached SQL Server backup script

It’s very important to take a backup for SQL Database on regular basis. Sometimes, users fail to restore data backup due to known reasons. In this situation, you can go for alternative solution like Stellar SQL Database Toolkit.

You can take backup of Microsoft SQL database:

1. Using SQL Server Management Studio

• Open Microsoft SQL Server Management Studio
• Connect to the "ServerName\Instance" of the server that has the DB you want backed up.
• Expand the Databases tab to get to the DB you want to back up.
• Right click the desired DB --> Tasks --> Back Up...
• Set "Backup Type" to "Full"
• Go through the rest of the General and Options tab information to set the options to what you want.
• Click OK to start the Backup process.

 It’s very important to take a backup for SQL Database on regular basis. Sometimes, users fail to restore data backup due to known reasons. In this situation, you can go for alternative solution like ***Information has been Flagged as Spam and has been Deleted. if you feel that the information deleted is not Spam please contact us or Reply to the Private Message Sent. ****