sql database cleanup

; failure recovery-model-select-Simple model.or with SQL statements:ALTER DATABASE name set recovery simple V If we hand-erase may sometimes forget, below I give an example of an automatic purge. Automatic Cleanup method: The same is done by using the SQL Server Agent service to perform automatic jobs. Open Enterpri

| +----+----------+-----+ | 1|zhangsan| 20| | 2|lisi | 21| | 3|wangwu | 22| +----+----------+-----+ At this point, the full-time data is restored. Then use the 003bin.sql file to recover the full standby time to delete the database between the new data Mysql-uroot-p test +----+----------+-----+ |id|name |age| +----+----------+-----+ | 1|zhangsan| 20| | 2|lisi | 20| | 3|wangwu | 20| | 4|x

Label:Occasionally checks database jobs for failures every day and finds errors [SQL]View Plaincopy Select Top Ten job_id,run_date,run_time,run_duration,step_name,message From msdb: sysjobhistory where run_status = 0 ORDER by run_date desc,run_time desc The job failed. Plan 12 (replication agent schedule. ) called the job. The last Run is Step 1 (run the agent. )。. was executed

operate like SQL Server SQLite, such as: build tables, queries, etc. are very convenient, interested can try, here is not explained.In the project, you need to add SQLite references: System.Data.SQLite.dll and System.Data.SQLite.Linq.dllSQLite database cleanupFinally, to illustrate a bad place in SQLite, when one or more data tables in the database have a large

--database is occupied cannot be restored workaround:--1 , set the database to work in single-user mode. --Set method: Right-click on the database you want to restore, select Properties-> Options-> Status-> Restrict Access-> "single" On the right-click menu command. This is the menu command for SQLSERVER2005, other versions please find it yourself. --The

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

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

This article is a simple tutorial on Oracle Database Clean temp table Space Oh, if you're looking for an Oracle database to clean up the temp table space just come in and have a look. Law One, restart the library Library restart, the Smon process will complete temporary segment release, temp table space cleanup operations, but many times our library is not allo

--Database log name QueryUse DBNAMEGOSELECT file_id, name,* from Sys.database_files;GO---------------------------------------------------------------------------------------------------------sql SERVER 2005 Cleanup methodsUse [master]BACKUP LOG DBNAME with no_logUse APPDBCC shrinkfile (' Dbname_log ', 100)----------------------------------------------------------