Database backup Restore

Source: Internet
Author: User
Tags management studio sql server management sql server management studio

Data software is using: SQL Server 2014

1. Version
    • Operating systems for new servers: Windows Server 2012
    • Server Software for new server: SQL Server 2014
    • Database management software:
      • SQL Server Management Studio
      • Navicat Premium
2.IP
    • If using the original IP: server operation is set to the original IP
    • If new IP: The profile IP address of each test cabinet is changed to a new IP
3. Backup Restore
    • Backup: Use Navicat Premium, backup to Dbo.sql file;
    • Restore: Restore using a backed-up dbo.sql file
    • Navicat Premium: Link: https://pan.baidu.com/s/1kVjA7Bp Password: I1IW
4. Daily backup
    • SQL Server Management Studio: daily backup data
    • Description: Use Studio restore: Requires table structure, because studio can only back up data cannot back up table structure
5. Graphic
    • To edit a SQL Server connection

    • Backup to Dbo.sql file: Right--Dump SQL file--data and structure

    • Restore: Right-click to create a new database named TESTDATADB
    • Right--run SQL file--Select the Dbo.sql file you just backed up

    • Reopen: Right-close the database, double-click to open, you can see the table

Database backup Restore

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.