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