sql server maintenance checklist

First, backgroundPreviously wrote an article about backup: SQL Server maintenance plan to implement database backup, the above article using full backup and differential backup basically can solve the problem of database backup, but in order to protect the data more secure, we need to perfect our backup plan again;The following article mainly joins the log backup

change the original table to the online table has been modified failed. After you temporarily disable SQL Server account, you can modify the name of the table.Analysis: There is a schema-stable lock during SQL execution, and it is easy to modify the data structure failure for highly concurrent access tables. It is recommended that you temporarily stop the busine

Start a server, is exactly the cloud host, the environment inside is pre-configured, but in the configuration planning tasks, but found that mssql2005 plan backup can not do, will error: Copy Code code as follows: SQL Server Create Maintenance plan failed (SQL

 SQL Server Maintenance Plan Maintenance Plan is a very useful maintenance tool that can accomplish most of the database maintenance tasks, and by encapsulating these features, you can save a lot of code writing time. There is n

SQL ServerHorizontal scaling: Design, implementation and maintenance (3)-distributedPartitionView implementation In the previous articleArticle, We have already mentionedDistributed partition ViewThe linked server technology is used for implementation, and the implementation principle is also roughly described.Internal MechanismSo far, our series aims to practi

Tags: directory maintenance guideSQL Server 2014 installation and Configuration guideChapter Catalogue"SQL Server 2014 management and Maintenance"1th. Achieving data integrity and consistency1.1 Data integrity1.2 Data consistency1.3 Blocking and deadlocksThe 2nd chapter cont

of requests for full index scans per second or full table scans per second. If the scan frequency is greater than 1 per second, the index is missing or the index is poor. 3.2.5. SQL serveraccess methodspagesplits/sec displays the number of page splits per second. It can be avoided through proper index maintenance or good fill factor. 3.3. CPU 3.3.1. systemprocessor Queue Length indicates the system queue l

the New Task Step dialog box, enter the name of the output file that reports the fragmentation analysis results: 　　 6. Click the OK button to return to the new Job dialog box; 7. On the schedule page of the New Task dialog box, click New Schedule and enter the appropriate plan for running the SQL Server task: 　　 Schedule this stored procedure to execute at non-peak. To determine the database schema of the

Indeed, database maintenance is often given to professional database administrators, but as a developer, you may occasionally need to do this work temporarily. So, try these two SQL Server maintenance tips: Easily change the database owner, defragment the index. Who would have thought you could even teach one or two ne

Indeed, database maintenance is often given to professional database administrators, but as a developer, you may occasionally need to do this work temporarily. So, try these two SQL Server maintenance tips: Easily change the database owner, defragment the index. Who would have thought you could even teach one or two ne

recovery, and differential recovery; With the above foundation, we have added database backup elements to generate database backup files through maintenance plans. These include two types of files: Full backup and differential backup of the database, with these two files, we can use SQL Server backup and restoration full strategy (Graphic operations) or

Tags: server error code base SYS about MDA tar Restart Center Error symptoms: D:\Program Files\Microsoft SQL Server\mssql.1\mssql\log below Erroelog, hit with text, view run dimension plan unsuccessful is the generated error log details: 2011-08-11 14:16:48-! [298] SQL Server