Kunal  Gautam
How to create Backup of Database in SQL Server 2012?
By Kunal Gautam in SQL Server on Apr 24 2013
  • Pramod Gehlot
    Jul, 2013 2

    1. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree. 2. Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database. 3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears. 4. In the Database list box, verify the database name. You can optionally select a different database from the list. 5. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE). 6. In the Backup type list box, select Full.

    • 0
  • Pramod Gehlot
    Jul, 2013 2

    1. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree. 2. Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database. 3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears. 4. In the Database list box, verify the database name. You can optionally select a different database from the list. 5. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE). 6. In the Backup type list box, select Full.

    • 0
  • Pramod Gehlot
    Jul, 2013 2

    1. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree. 2. Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database. 3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears. 4. In the Database list box, verify the database name. You can optionally select a different database from the list. 5. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE). 6. In the Backup type list box, select Full.

    • 0
  • Pramod Gehlot
    Jul, 2013 2

    1. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree. 2. Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database. 3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears. 4. In the Database list box, verify the database name. You can optionally select a different database from the list. 5. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE). 6. In the Backup type list box, select Full.

    • 0
  • Pramod Gehlot
    Jul, 2013 2

    1. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree. 2. Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database. 3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears. 4. In the Database list box, verify the database name. You can optionally select a different database from the list. 5. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE). 6. In the Backup type list box, select Full.

    • 0
  • Pramod Gehlot
    Jul, 2013 2

    1. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree. 2. Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database. 3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears. 4. In the Database list box, verify the database name. You can optionally select a different database from the list. 5. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE). 6. In the Backup type list box, select Full.

    • 0
  • Pramod Gehlot
    Jul, 2013 2

    1. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree. 2. Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database. 3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears. 4. In the Database list box, verify the database name. You can optionally select a different database from the list. 5. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE). 6. In the Backup type list box, select Full.

    • 0
  • pratius jawala
    May, 2013 22

    BACKUP DATABASE database_name TO DISK='d:\path\to\backup\file\on\the\server.bak'

    • 0
  • Raj Kumar
    Apr, 2013 29

    1. After connecting to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree. 2. Expand Databases, and depending on the database, either select a user database or expand System Databases and select a system database. 3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears. 4. In the Database list box, verify the database name. You can optionally select a different database from the list. 5. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE). 6. In the Backup type list box, select Full.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS