sql server maintenance cleanup task

Log cleanup methods under SQL Server 2008 (2011-07-14 10:30:45) Transfer from http://blog.sina.com.cn/s/blog_4bdd3d0b0100wfvq.html Tags: it Every time the database log to see the explosion of some big head, so random search a way to get rid of the log, the next big head, and search for half a day, so or write a blog, do not loo

cleans up backups one months ago.First click on the Schedule button of the first Subplan, set the full backup cycle setting as follows.You then set the period for the differential backup.The last file cleanup cycle.Once set up, save, and the maintenance plan is set up.In fact, SQL Server automatically generated the ap

Summary of index, foreign key, and field syntax maintenance for mysql, SQL Server, and oracle databases, and SQL Server oracle Summary of index, foreign key, and field syntax maintenance for mysql,

Server Maintenance plans that are automatically performed on a regular basis: Rebuilds the index with the new fill (duty) factor to reorganize the data on the data and index pages. This ensures that database pages contain equally distributed data and remaining space, which allows for faster growth in the future. Remove an empty data page from the database page to compress the data file. Update index statist

1, set the database mode to Simple mode: Open SQL Enterprise Manager, in the console root in turn, click the Microsoft SQL Server-->sql Server group--> double hit Open your server--> double-click to open the database directory-->

Tags: DBCC article BSP color size ASE file detail supportSQL Server log file too large log file cleanup method, the network provides a lot of separate database--〉 delete log files-〉 Additional database method, this method is too risky, the process is relatively long, and sometimes there will be the phenomenon of separation unsuccessful. The following methods do not require database separation and additional

operation is to adjust the memory configuration size. Manual operation Method: 1. Open SQL Server Management (Enterprise Manager); 2. Open the Properties panel for the instance of SQL Server; 3. Locate the memory settings and change the maximum server memory usage. Use scr

. The Distribution transaction table could not be cleared. [SQL]View Plaincopy --View the jobs performed SELECT * from msdb.dbo.sysjobs where job_id = ' dc0df572-9339-46ed-84e7-2c1ed622c067 ' View SQL Server Agent account, NT authority\network SERVICE Find this directory, is the snapshot directory, has not been used for a long time. A f

backed up, choose to create a backup file for each database, the file is saved in the C-disk backup directory, the extension is Bak, for security purposes, we can check "Verify backup Integrity", Of course, we can not choose. The new features of compressed backup are available in SQL2008, making backup files smaller and faster to backup, where we are backed by compression. Finally, I chose the execution plan, which I chose to do every Sunday night at 0 o'clock. (6) Click "Next" button, go to t

go to the page that defines the complete backup task, This interface is too long. I can't hide the taskbar and the scroll bar appears. Here we choose the database to be backed up and choose to create a backup file for each database, the file is stored in the Backup Directory of drive C with the extension of bak. For security reasons, we can select "verify Backup integrity" or choose not. The new features of compressed backup are provided in SQL2008

notice that the maintenance plan is not under SQL Server Agent. Navigate to the maintenance plan, managed by. The maintenance plan is not created by default on the database. Right-click the maintenance plan and you see the new

Clearing the log in SQL Server must be done in simple mode, and then back to full mode when the purge action is complete.*[databasename] The name of the database to compress the log.Setting the database schema to Simple modeALTER DATABASE SET with no_wait ALTER DATABASE SET RECOVERY SimpleQuerying log files for FiledidSELECT * from SysfilesFill in the Filedid of the log with the first argument in paren

Tags: style blog http using io strong file dataEvery time the database log to see the explosion of some big head, so random search a way to get rid of the log, the next big head, and search for half a day, so or write a blog, do not look for a mess.1. Set the database to Simple modeSelect the database you want to shrink, right-click Properties---options, select Simple Mode2. Select tasks, shrink-file3. Select LogOr use the following statementcode use [Master]GOALTER DATABASE dnname SET RECOVERY

Two methods of server SQL Server log cleanup Method One In general, the contraction of the SQL database does not greatly reduce the size of the database, its primary role is to shrink the log size, you should do this periodically to avoid the database log too large 1, set t

SQL error log records the database running process encountered a variety of problems and some important information, as a problem, we usually do not take the initiative to clean up these log files, only every time the server restart, SQL will automatically delete the oldest log files, and new into a log file. By viewing the database log file on the