Backing up and restoring databases with Ms sqlserver increases the size of database backup files, and sometimes it is difficult to explain the backup files to the customer.
I. How to back up a database
1,View the physical path of the database, open "Enterprise Manager", and findCMSDatabase, right-click it and view its properties. The "Database" option allows you to view the storage location of database files, and the "transaction log" option allows you to view the storage location of transaction log files;
2. open" service "from the management tool ", find MSSQLServer to stop the service.
3. Find the physical path of the database storage, for example, C: \ Program Files \ Microsoft SQL Server \ MSSQL \ data
FindCms_data.mdfAndCms_log.ldfTwo files,WinRARCompress the data into a file and store it in another directory (Backup Directory) by date.
Ii. How to restore a database
1,Back up the database to the backup directory using the one method;
2, Open "Enterprise Manager", right-click the database, select "add Database" in "all tasks", and click ... Click to select MDF File is the data file of the database. The system automatically reads the data file and log file under the button List In the window, the "OK" button is activated and the "button" button is clicked to restore the database.
By noble Paul