Blog has been built for several years, but because I am a layman, so the beginning of the use of the Zblog asp+access database to build, mainly because of technical shortcomings.
But after several years of finishing and writing, found this system more and more cards, consulted a lot of bloggers, and went to Zblog forum many times, found that because of the database cause, Access database can only build some small station, the data volume has reached the obvious pressure, So recently tried to upgrade and convert access to SQL server2012 Microsoft database, after a few days of tossing and consulting some tall man, finally solved the problem, now access more carefree.
My blog:
(读后感http://www.simayi.net读书笔记)
The theme of the review of the education of the actual site.
So, today I'm going to learn to use SQL Server 2012 to back up the database, after all, books are important things, once lost or backup errors can have serious consequences.
The steps are as follows:
First step: Login to SQL server2012 database management background: ()
The second step: Select your own database and perform backup operations, and I think it should be more secure to back up the data to their hard drive. ()
I'll go! Is that all right? I don't know what's wrong with my backup? If there is a problem with this backup, I hope you correct me!
Important NOTES:
1. I am the selected full backup.
2. And in the options, overwrite the current backup set.
In addition: There is a way to export data directly, so also OK? Does a full backup not have multiple backup sets and media problems? For large databases must be a differential backup, then you need to back up the backup data to a path is more convenient?
Technology sharing how to fully back up the SQL Server 2012 database?