sql server maintenance checklist

system requirements change, may also deliberately leave one or two alternate fields.In a table, the order of each row of data can be arbitrarily transformed, usually in the order in which the data is inserted. You can also sort the data by index, in short, the data row arrangement here does not affect the subsequent sequencing of the programming process.But the data between rows is also fine and do not repeat, this is controlled by the primary key, because the primary key specifies that no repe

display the progress of the installation in the "Installation Progress" menu.14. After installation, on the "Complete" menu, display the installed components and services.15. Close the installation window. Configure SQL Server: 1. "Start | Run ", enter Secpol.msc.650) this.width=650; "title=" clip_image014 "style=" border-top:0px;border-right:0px;background-image:none; border-bottom:0px;padding-top:0px;pad

use this proxy account. Note that there is a third tab, reference, which shows which job step uses this proxy account, and you can modify or delete the agent directly. Using a proxy accountYou can now modify the job step to use the proxy account. If you are following this series of articles, you should have a job called Shellout, and its second step S2 is the PowerShell subsystem. Open this job step and change the running identity to Proxydemo credentials (10.6). If you do not have this job ste

Label:Requirements Description In our production environment, in most cases, we need to have our own operation and maintenance system, including the detection of their own health status. In the event of an exception, an early warning is required, and the form of notification is generally communicated by e-mail. e-mail as a very convenient way to implement early warning, in terms of timeliness and ease of use also has irreplaceable advantages. Therefor

attributes to the standard mode. The operation method is the same as the first one, because logs are often an important basis for restoring the database in case of exceptions. 4. Set daily automatic Database Backup We strongly recommend that users with conditions perform this operation!1. Open the Enterprise Manager and click Microsoft SQL Server> SQL

the recovery model of the database to be full mode, which can be modified using the following statement: ALTER DATABASE adventureworks2008r2 SET RECOVERY full;2. Check that the compatibility level of the database is 90 or higher, that is, 2005 or more SQL Server, if not, you can use the following script to modify: ALTER DATABASE adventureworks2008r2 SET compatibility_level=100;--2008 sp_dbcmptlevel @DBNA

Transferred from: http://www.seayee.net/article/info_106.htmlThe recent maintenance plan for MS SQL Server 2005, which configures a server, automatically backs up the database and can create a maintenance plan, but after setting the run time, save the hint "the GUID should c

TCP/IP to another port.　　9. Reject detection from port 1434Because there is no limit on port 1434 detection, some database information can be detected by others, and DOS attacks may also increase the CPU load on the database server. Therefore, for Windows 2000 operating systems, when using IPSec to filter out UDP communication that rejects port 1434, you can hide your SQL