How SQL 200 automatically backs up data

Question addendum: Can you tell us more about how to make that tool? For MS data, you need to use the backup tool SQL2005 database backup, which is generally divided into two types: one is manual backup. The second is automatic backup. Here are two types.

It is good to add a scheduled backup plan to the execution plan, and pay attention to the disk space in the backup area every day.

Preparation materials: computer, sqlserver2000

1. Click "Start" "All Programs" "Microsoft SQL Server" "Enterprise Manager" to open the "Enterprise Manager" console window.

2. In the SQL Server Backup dialog box, click the drop-down triangle on the right side of Databases and select the name of the database to be backed up. In the Name box, you can type the name of the file generated by the backup.

3. In the "Select Backup Destination" dialog box that opens, click the browse button on the right side of the "File Name" box to open the "Backup Device Location" dialog box.

4. SQL Server starts to back up the database according to the specified backup purpose, and a prompt will be given after the backup is completed, click the OK button.

Step 1, click "Start" "All Programs" "Microsoft SQL Server" "Enterprise Manager" to open the "Enterprise Manager" console window.

Step 2: In the left pane of the Enterprise Manager console window, in the directory tree of "Microsoft SQL Servers, SQL Server Group, Local". Then right-click on the "Database" option and perform "All Tasks" in the pop-up shortcut menu "Back up database".

Step 3: Open the SQL Server Backup dialog box and click the drop-down triangle to the right of Databases to select the name of the database you want to back up (in this case, the default master database is used). In the Name box, you can type the name of the file generated by the backup. Then click on the "Add" button.

Step 4, In the "Select Backup Destination" dialog box that opens, click the browse button on the right side of the "File Name" box to open the "Backup Device Location" dialog box. In the dialog box, locate the folder on your local hard disk where you want to save the backup database files, and then type a suitable name for the backup file in the File Name box. When the settings are complete, click the OK button.

Step 5, go back to the "Select Backup Destination" dialog box, you can see the settings just made in the "File Name" box, click the "OK" button.

1,。- Automatic backup by date.

declare @sql varchar(100)set @sql='d: Path database name'+rtrim(convert(varchar,getdate(),112))+'.bak'

backup database database name to disk=@sql try this

2,。It is also possible to back up manually. Right-click the database name to back up.

You can use the command or back up in Enterprise Manager, where you should be able to right-click on the database you want to back up.

1.From your computer's start menu, select SQL Server Management Studio and double-click. Tap on the "Connect" button in the interface that appears.

2.In the "Microsoft SQL Server Management Studio" interface, select "Maintenance Plans" under "Administration", right-click on the maintenance plan, click "Maintenance Plan Wizard", 3In the SQL Server Maintenance Plan Wizard page, click Next

4.Write the name and description in the screen that appears. Then click "Change" to set the top backup plan.

5.In the Job Schedule Properties page, change the execution time, that is, how often the backup is made. This should be a daily backup. If the interval is changed to 1, the change is performed once at 0:00:00, that is, the data is automatically backed up at 00:00 every day.

6.Once you've made the changes, you'll see "Executed at 0:00:00 every day." Plans will be available starting May 16, 2014. Then click on the "Next" button.

7.Select the database file to be backed up on the Maintenance Task page. Then click Next.

8.Select the order of maintenance tasks to move the database files to be backed up. Then click Next.

9.On the Definition Backup Database Complete page, select a database file from the drop-down list behind the database. Then click on the "OK" button.

10.Select the backup path on the Definition Backup Database Complete page. Then click Next.

12.In the Complete Wizard screen that appears, you'll see the details of setting up a backup.

13.This results in an automatic backup of the database.

For database management, in fact, the most important point is to back up the database frequently, so if you manually back up every day, the workload of the administrator is a bit large. SQL Server 2000 databases come with an automatic database backup function. The following is how to automatically back up SQL Server 2000 databases.

1. Open SQL Server 2000 Enterprise Manager.

2. Open the database list and right-click All Tasks on the database you want to back up the database.

3. In the pop-up settings window, select "Database - Complete", click "Add" on the right side of the backup list, and select the path and name of the backup file.

4. Select "Rewrite Existing**" in the override option

5. Check the "Scheduling" option and click "."icon to schedule.

6. Select "Recurring", click "Change", select "Weekly", "Every 1 week", "Monday", select the time you want to make the backup in the daily frequency, and then press "OK" to complete the automatic backup setting.

First, open Enterprise Manager, click Microsoft SQL Server in the root directory of the console - > SQL Server Group - > double-click to open your server.

Then click Tools in the menu above > select Database Maintenance Planner;

The Database Maintenance Plan Setup Wizard pops up, click Next.

Select the data to be automatically backed up - > the next step to update the data optimization information, here you generally do not need to make a selection - > the next step to check the database integrity, and generally do not choose.

Next, specify the database backup plan, the default is to back up once every week, click Change to select Daily backup and click OK.

Next, specify the backup disk directory, select the specified directory, such as you can create a new directory in the d disk such as: d: databak, and then choose to use this directory here, if you have more databases, it is best to choose to establish a subdirectory for each database, and then choose to delete the backup earlier than how many days ago, generally set 4 7 days, it depends on your specific backup requirements, the default backup file extension is bak;

The next step is to specify the transaction log backup plan, depending on your needs to make a choice --> the report to be generated next, generally do not make a choice --> the next step to maintain the plan history, it is best to use the default option --> the next step to complete.

After completion, the system is likely to prompt that the SQL Server Agent service has not been started, first click OK to complete the plan setting, then find the SQL green icon in the status bar in the lower right corner of the desktop, double-click to open, select SQL Server Agent in the service, and then click Run, and select the Automatically start service when starting OS at the bottom;

Step to read. 8. You can set to start SQL Server Agent::Run automatically, click Enter. In System Services, find the sqlserveragent service that is set to start automatically.

At this point, the database maintenance schedule is complete!

It's best to use database snapshots, which are available in Books Online.

1. SQL Server agent (task planner and alert manager) with SQL Server installed is required. (Look at the red box).

If you don't have it in Service Manager, you are using SQL Server Lite or Express, or you didn't have the option to install SQL Server Agent when you installed it.

2. Open Enterprise Manager, click Microsoft SQL Server in the root directory of the console - > SQL Server Group - > double-click to open your server, and then click Tools in the menu above - > select Database Maintenance Planner. At this time, the database maintenance plan setup wizard will pop up, and then follow the wizard operation.

3. The follow-up setting is not difficult, and you can try a few more times yourself.