bluehost automatic backups

Preparation tools:SqlServer2008WinRar1. Set up maintenance schedule scheduled backups for SQL ServerThis is a simple operation, and you can follow the wizard to add a maintenance plan.2. Automatic compression scriptsc:\progra~2\winrar\winrar.exe a D:\bak\database_buckup_%date:~0,4%_%date:~5,2%_%date:~8,2% D:\bak\database_*%Date:~0,4%_%date:~5,2%_%date:~8,2%_*.BakThe format of the backup file is: Database_ba

txt text file to Jfsuqian.bat, also put in the D:\databackup directoryCD C:\Program Files\Microsoft SQL Server\100\tools\binn sqlcmd-s.-I D:\databackup\JPKFSuQian.sqlExplain:First line: is the installation path of your SQL ServerThe second line: The SQL script path that needs to be executed, which is the backup script we wrote earlier5. Create a bat file to delete the backup, as in the fourth step, create a txt text file on the desktop, enter the following, then rename the txt file to Del_4_ba

Label:1. DescriptionSQL Server2008 itself has regular automatic backup capabilities, and we only need simple configuration to enable very simple and efficient automatic backup.2. Open the SQL Server Agent serviceTo implement the automatic backup feature, first make sure that SQL Server's SQL Server (proxy) service is turned on.If you do not see this SQL Server Ag

Tags: tool AAC server including INIT test scheduled backup commonly used simpleIn SQL Server, for data security reasons, you need to back up the database on a regular basis. While the backup database is usually in the early hours of the basic no database operation, so we can not ask the administrator every day to the night 1 o'clock to back up the database. The most common way to implement scheduled automatic back