/etc/crontab # edit the file and add45 22 * root/home/mysql_data/mysql_databak.sh # indicates that backup is performed at every day.Ctrl + o # Save ConfigurationCtrl + x # exit
5. Restart crond to make the settings take effect.Service cron stop # stopService cron start # start/Etc/init. d/cron restart # restartChkconfig cron on # Set to boot
Every day, you can see compressed files such as mysqldata_bak_2012_04_11.tar.gz under the/home/mysql_datadirect
sp_help_fulltext_catalogs
Search for full-text index Directories
sp_help_fulltext_columns
Full-text index Column
sp_help_fulltext_tables
Full-text index table
Drop fulltext index on TableName
Delete full-text index directory drop fulltext catalog catalog_name
If full-text indexes are not available in SQL backup, you must delete the indexes before restoring them.
The details are as follows:
How to obtain the number of full-text indexes in the data
One, SVN full-scale backup script:1) New file Backup.bat , open the editor and enter the following:echo offinstallation directory for REM subversionSet svn_home="C:\Program Files (x86) \visualsvn Server"REM Parent directory for all repositorySet svn_root=D:\RepositoriesThe list of REM backupsSet backup_svn_root=D:\SvnBak (note: Where the red logo is modified according to the actual situation)REM Create a te
Problem
There is a lot of data that needs to be dug inside the Microsoft SQL Server System view. This data is used to present information to the end users of SQL Server Management Studio and to Third-party management tools available to SQL Server professionals. This data not only contributes significantly to database backup
Today is a bumpy day, why this is the case, because in the Windows Server Backup to do the system state backup, there has been a failure; a friend did a scheduled task to do a system state backup, today found that there was an error, as shown, all failed, why?
650) this.width=650, "width=" 574 "height=" "title=,"
company's customers ' data and wiped out most of the server's content, and the customer data recovery was hopeless.For these frequently occurring events, we have a deeper understanding of the first of the DBA code: Effective backups are more than everything. There is an urgent need to improve and refine the backup effort, and the DBA optimizes the backup as follows:1.
Microsoft pushes Windows Home Server to upgrade software power Pack3 Beta: Backup is back. Microsoft is about to launch a new power Pack 3 upgrade software for the Windows Home Server system, and Windows home after installing this upgrade software Server will be able to support Windows 7.
Windows7 has added a new feat
An I/O error occurs in SQL Server due to cloning backup from a virtual machine.
CASE Environment:
Server Configuration: CPU: Intel E5-2690
RAM: 12 GB Virtual Machine
Operating System: Windows Server 2008 R2 Standard Edtion x64
Database Version: SQL SERVER 2008R2Case study:
Simple remote backup solution for Linux Server databases (MySQL and Oracle)
Simple remote backup solution for Linux Server databases (MySQL and Oracle)
Simple remote backup solution for MySQL Databases on Linux servers
First, let's briefly describe:
1. Execute the scrip
the file and add45 22 * root/home/mysql_data/mysql_databak.sh # indicates that backup is performed at every day.Ctrl + o # Save ConfigurationCtrl + x # exit5. Restart crond to make the settings take effect.Service cron stop # stopService cron start # start/Etc/init. d/cron restart # restartChkconfig cron on # Set to bootEvery day, you can see compressed files such as mysqldata_bak_2012_04_11.tar.gz under the/home/mysql_datadirectory.To restore a file
are a point, and the next is what we want to talk about.1. Do a log backup, remember to select "Back up the tail of the log."Then in the "Options", strictly follow the selection in the Red box to check, otherwise, you may cry. and ensure that the database does not have a connection, because there is a link, log backup is not backup.2. After the log
"Problem description"When you make a manual backup of system management, you are prompted to "fail to open Backup device" E:\ automatic backup \ufidau8xtmp\ufdata. BAK '. An error occurred on the device or the device is offline. For more information, see the SQL Server error log. -2147217900 "Then click "OK" will promp
1 , open the Windows Server Backup "Select Local backup and select" One-time backup "in the Action Bar; (in a real-world production environment, you can select either a one-time backup or a backup plan, depending on your needs.) )
There are four variables that affect the performance of tape backup devices and allow SQL Server backup and restore performance operations to increase the linear proportions of the system by substantially adding more tape devices.
Software data block size
Number of tape devices sharing a small computer system interface (SCSI) bus
Tape Device Type
The software
The following are only references, and may be slightly different if there are multiple instances:
This environment is SQL Server Standard version 64-bit and SQL Server 2008 Standard version 64-bit dual instances installed simultaneously in a
On Windows Server 2008 Standard Version 64-bit OS:
Code
Copy Code code as follows:
Windows
"Customer Name": Binzhou Wudi County Hospital of Shandong Province"Software name": Zhong Lian Jia Yu His hospital information management system"Database Version": MS SQL Server 2008R2 "database size": 48GB."Problem description": On the eve of the Lunar New Year, the customer due to server hard disk damage, causing RAID5 serious damage. It also affects all hot backup
There are two ways to back up SQL Server databases: one is to back up DATABASE files using BACKUP DATABASE, and the other is to directly copy the DATABASE files mdf and log files ldf. The following describes the backup and recovery of the latter. This document assumes that you are familiar with SQL Server Enterprise Ma
There is already a DOE database on the SQLServer server and there is a large amount of data in it. Now we are preparing to use another backup file A1.BAK (not the backup file of the DOE database) import other data (that is, add some data tables to the DOE after the import, the table has already recorded data), and keep the data of the original DOE unchanged. 1. F
To install the Windows Server Backup tool
1) login DC-01;
2 Click Start, and then click Server Manager.
3 in the feature summary, click Add Feature.
4 in the list of features, double-click Windows Server Backup features, and then click Windows
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.