---
title: "Managing Backups (SybaseToSQL) | Microsoft Docs"
ms.custom: ""
ms.date: "01/19/2017"
ms.prod: sql
ms.reviewer: ""
ms.technology: ssma
ms.topic: conceptual
helpviewer_keywords: 
  - "Tester Component,Managing Backups"
ms.assetid: 266d987c-ecc5-4fa4-bfdf-8c584f1a1332
author: "Shamikg"
ms.author: "Shamikg"
---
# Managing Backups (SybaseToSQL)
Sybase Backup Management lets you backup and restore table data before or after running a test. You can also manage the backup content with Manage Backup Contents dialog.  
  
## Sybase Backup Management  
  
### Backup  
To open the backup dialog, on the Tester menu point to Sybase Backup Management, then click Backup.... In the backup dialog you will find the Sybase Metadata tree displaying all tables of the loaded Sybase schema. Select one or more tables to perform a backup.  
  
The following buttons are available on the dialog:  
  
-   Click the **Check State** button to check the table's backup state.  
  
-   Click the **Backup** button to back up table's the data.  
  
-   Click the **Cancel** button to close the dialog.  
  
### Restore  
To open the restore dialog, on the Tester menu point to Sybase Backup Management, then click Restore.... There you will find a tree containing the tables available in backup. Select one or more tables to restore its data.  
  
The following buttons are available on the dialog:  
  
-   Click the **Check State** button to check the table's backup state.  
  
-   Click the **Restore** button to restore backup data into the table.  
  
-   Click the **Cancel** button to close the dialog.  
  
### Managing Backup Contents  
To open Managing Backup Contents, on the Tester menu point to Sybase Backup Management, then click Backup Content.... There you will find a tree containing the tables in the backup.  
  
The following buttons are available on the dialog:  
  
-   Click the **Check State** button to check the table's backup state.  
  
-   Click the **Remove** button to remove the table from the backup.  
  
-   Click the **Close** button to close the dialog.  
  
## SQL Server Backup Management  
SQL Server Backup Management lets you backup and restore table data before or after running a test. You can also manage the backup content with Manage Backup Contents dialog.  
  
### Backup  
To open the backup dialog, on the Tester menu point to SQL Server Backup Management, then click Backup..... In the backup dialog you will find the SQL Server Metadata tree displaying all tables of the loaded SQL Server databases. Select one or more tables to perform a backup.  
  
The following buttons are available on the dialog:  
  
-   Click the **Check State** button to check the table's backup state.  
  
-   Click the **Backup** button to back up the table's data.  
  
-   Click the **Cancel** button to close the dialog.  
  
### Restore  
To open the restore dialog, on the Tester menu point to SQL Server Backup Management, the click Restore.... There you will find a tree containing the tables available in backup. Select one or more table to restore its data.  
  
The following buttons are available on the dialog:  
  
-   Click the **Check State** button to check the table's backup state.  
  
-   Click the **Restore** button to restore backup data into the table.  
  
-   Click the **Cancel** button to close the dialog.  
  
### Managing Backup Contents  
To open Managing Backup Contents, on the Tester menu point to SQL Server Backup Management, then click Backup Content.... There you will find a tree containing the tables in the backup.  
  
The following buttons are available on the dialog:  
  
-   Click the **Check State** button to check the table's backup state.  
  
-   Click the **Remove** button to remove the table from the backup.  
  
-   Click the **Close** button to close the dialog.  
  
## See Also  
[Testing Migrated Database Objects (SybaseToSQL)](../../ssma/sybase/testing-migrated-database-objects-sybasetosql.md)