• State Suggested Answer
  • Locked Locked
  • Replies 4 replies
  • Answers 2 answers
  • Subscribers 19 subscribers
  • Views 7425 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to properly create backup for Microsoft SQL Database?

cakan tomas
over 5 years ago

Hello,

I have question about Quest vRanger. How is possible create proper backup for Microsoft SQL Database server? I mean transaction logs, .... Thanks.

Tomas

Parents
  • 0 over 5 years ago

    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. ****

Reply
  • 0 over 5 years ago

    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. ****

Children
No Data