OffOn
    Register
    HomeSQL Server

    How to take Database Backup in SQL Server 2008 R2?

    admin November 14, 2024 2 Comments

    It might be important to take the back of the SQL Server database regularly and store them in a secure place which will help you to recover or restore data in case of natural disaster or any other issues.

    In this blog post, I will demonstrate a step by step process to backup database in SQL Server 2008 R2.

    How to take Database Backup in SQL Server 2008 R2?

    Follow the below steps to take the Database Backup in SQL Server 2008 Management Studio R2.

    1. Launch SQL Server Management Studio

    2. Connect to the SQL Server Instance where the database exists.

    3. Expand the Database node and right click the database that you want to backup in the Microsoft SQL Server Database Engine in Object Explorer. This will open a Context Menu. Click Tasks -> Backup option.

    4. A Back up Database Dialog box will be opened. Verify the Database Name, Backup type (Full)

    5. In the Backup component, select the radio button “Database”. In the Backup set, leave the default name and provide description (optional) and then leave the default value (0) days for backup set will expire after option.

    6. Alternatively, you can add the Destination to different path where the SQL Server database back up should be saved to by clicking the “Add” button.

    7. Click OK to start the backup process of the SQL Server database. Within some time, you should receive a confirmation message stating that the database was successful if all went fine… The backup file should now be available in the earlier selected path.

    Tag:

    Share:

      2 Comments

    1. James
      October 2, 2012
      Reply

      What about the transaction logs?

    2. Senthil Kumar
      October 2, 2012
      Reply

      try BACKUP LOG …

    Leave A Reply

    Your email address will not be published. Required fields are marked *

    You May Also Like

    See more
    code coder coding computer

    SQL Server Error Msg 1459 – An error occurred while accessing the database mirroring metadata. Drop mirroring (ALTER DATABASE database_name SET PARTNER OFF) and reconfigure it.

    In this blog post, let’s learn about the error message “1459 – An error occurred while accessing the database mirroring...
    Read more
    code coder coding computer

    SQL Server Error Msg 7937 – Columnstore index has one or more missing column segments. Please run DBCC CHECKDB for more information.

    In this blog post, let’s learn about the error message “7937 – Columnstore index has one or more missing column...
    Read more
    code coder coding computer

    SQL Server Error Msg 8685 – Query cannot be compiled because element appears in XML plan provided to USE PLAN but USE PLAN was applied to a non-cursor statement. Consider using an XML plan obtained from SQL Server for statement without modification.

    In this blog post, let’s learn about the error message “8685 – Query cannot be compiled because element appears in...
    Read more