sql server maintenance checklist

Label:Test system maintenance process, in order to ensure that the test smoothly need to set up a test system on multiple servers (backup), this time need to move the database back and forth, before our usual method of database backup restore is really simple and convenient, but encountered different server installed SQL version of the rest of the dish, Although

Tags: style blog http color os using SP strong fileOriginal: Database backup of "MS SQL" Database maintenance plan (i)Before you make a database backup, be sure to hear: full backup, differential backup, incremental backup, transaction log backup ... and other words, the following illustration to illustrate.完整备份：A full database backup contains all the data in the database. For small databases that can be ba

Label:Issue: SQL Server error: 15404, unable to get information about Windows NT Group/user Mypc/administrator ', error code 0x534. [SQLSTATE 42000] (connisloginsysadmin)Confirm Login NameSecurity-Login Name: Confirm Administrator user name prefix xxx/administrator, verify that XXX is the native user name, and sometimes change the user name after this problem occurs. Change to native user name/administrator

Before you make a database backup, be sure to hear: full backup, differential backup, incremental backup, transaction log backup ... and other words, the following illustration to illustrate.完整备份：A full database backup contains all the data in the database. For small databases that can be backed up quickly, the best approach is to use full database backups. However, as the database grows, a full backup takes more time to complete and requires more storage space. Therefore, for large databases, a

, NAME = n' TestDB1-full database backup ', SKIP, NOREWIND, NOUNLOAD After the creation steps are completed, the next step is to create a plan. The operation for creating a plan is very simple, and the interface is described in detail. I will not talk about it much. You can also configure alarms and notifications, but this is rarely used. The method of executing SQL scripts in SQL jobs to back up data is si

. The SQL Server system has some problems. SQL Server is a set of large professional database software, which often requires maintenance and cleaning. However, we system developers cannot always go to the users for maintenance, th

Label:Introduction The transaction log in SQL Server is undoubtedly one of the most important parts of SQL Server. Because SQL Server uses transaction logs to ensure persistence (durability) and transaction rollback (Rollback). Th

create per-partition statistics by using the INCREMENTAL option)3. Regenerate data for a partition online (SQL2014 The progress report for the online Index action event class now has two new data columns: PartitionID and PartitionNumber)4. Re-organize data for a partition online (SQL2005)5. Filegroup Backup and piecemeal restore (SQL2005)6, CheckFilegroup (SQL2005)7. Swap partitions (delete historical data or archive or ETL)8, lock upgrade can be promoted to the partition lock, instead of direc

Prepare to do before copying: 1. Publisher, Subscriber creates a Windows user with the same name and sets the same password as a valid access user for the publication snapshot folder My computer Control Panel Management tools Computer Management Users and Groups Right-click User New user Create a user who is logged on to Windows in the group of Administrators 2. At the publisher, create a new shared directory as the repository for the published snapshot files: My computer D:\ Create a new dir

MS SQL Server Query optimization methodThere are many reasons for the slow speed of queries, which are common1, no indexes, or no indexes (this is the most common problem with query slowness, is the flaw in programming)2, I/o throughput is small, creating a bottleneck effect.3, no computed columns are created causing the query to be not optimized.4, Low memory5, network speed is slow6, query out the amount

Label:This article summarizes the various pits in SQL Server 2012/2014 that are linked to SQL Server 2000, all of which are problems encountered in practical applications. Someone might say why SQL SERVER 2000 is still in use, why

50 methods to skillfully optimize your SQL Server database There are many reasons for slow query speed. The following are common causes: 1. No index or no index is used (this is the most common problem of slow query and is a defect in programming) 2. Low I/O throughput, resulting in a bottleneck effect. 3. the query is not optimized because no computing column is created. 4. Insufficient memory 5. slow net