SQL2000 database cannot be backed up or copied from data files

Use winrar to package the database file into a rar file, if the error message dialog box pops up, select ignore, and then some error messages are prompted. If the RAR file created by winRAR exists, it can be copied to other disks and then extracted.

6.Data Error, Cyclic Redundancy Check (CRC) is a data transmission error detection function that performs polynomial calculations on data and appends the resulting results to the back of the frame, and the receiving device also executes a similar algorithm to guarantee the correctness and integrity of the data transmission. If the CRC verification fails, the system repeatedly copies data to the disk and falls into an endless loop, resulting in the replication process not being completed.

There are many possible reasons for cyclic redundancy check errors, including hardware and software failures.

You can try these two methods to see if it works.

1. Disk defragmentation (longer time).

Select (Properties) Select (Tools) and then select Disk Cleanup 2 to run the Disk Detection Tool.

Start Run Input: chkdsk d:f Enter heavy.

It could be that the database file is corrupted. Do you have a previous backup? It is better to recommend that you make a backup once a day.

It's an operating system problem. I haven't seen it, pay attention!

backup database [database name] to disk=[b server disk path].

Okay? Synchronous words:

1.【Full Backup】【Create Backup Settings】First, find a drive letter with a large disk space, create an hwdbbackup folder in the root directory, then open SQL Server 2000 Enterprise Manager - Manage Backups, right-click on the backup, and select [New Backup Settings].

Note: Enter the name of the data to be backed up, and then point to the directory you just created. Click OK and the backup device for the database is set up.

2.[Backup Database] also right-click on the backup, select [Backup Database], first select the database you need to back up, note, backup settings, select the backup settings you just created, select [Full Backup] for backup, and select [Rewrite**] for rewriting

3.Set Schedule, select Recurring, and click Change

In this way, the automatic full backup is established at 23 o'clock every day, in addition to the complete backup, the differential backup at 12 o'clock at noon every day is also needed, so that even if it appears, the database cannot be recovered, then the data after 12 o'clock is gone, and the supplement order is at most the afternoon order.

4.[Differential Backup] The following details the differential backup method: right-click [Backup] to select the backup database, note: select [Differential] for backup, and select [Append to**] for override

The scheduling of full backup and differential backup is the same, but the specific difference is only in time, and it must be set to about 12:20 to 1:00, because the number of business orders during this period is relatively small.

Once that's done, our backup is set up, and we're going to look at the tasks in the job.

In addition to database backups, there should be a weekly automatic database maintenance plan, and the steps for maintenance planning are described below

Open Enterprise Manager, select a database maintenance plan, right-click, select New Maintenance Plan, click Next, and select the following databases Select Databases.

Click Next and be sure to tick the box on Reorganize Data. and from the database file...

At the same time, you must set the schedule, select the schedule, select the weekly, and the date of occurrence must be selected after the full backup is just established, and then execute, otherwise it will cause excessive pressure on the server.

After setting the data optimization information, click Next and choose not to check data integrity.

Then the next interface appears, note that the schedule is established at 3:30, and the backup is made every day.

Then click Next.

Then click Next directly, don't choose all the choices in the back, the default is on the line, click Done, look at the homework.

You can start the job, look at the results, and then go to the folder you just created, and you can find the corresponding backup file.

sql2000 to do synchronization, I really don't have this environment, I used to be sql2005 to do synchronization, I don't know if you can use it, you need to q me 523740321

You can refer to this solution.

Or try the following statement.

Run the following statement to fix the problem and restart the SQL service after it is complete.

if serverproperty( 'servername ') begindeclare @server sysname

set @server = @@servername

exec sp_dropserver @server = @server

set @server = cast(serverproperty( 'servername ') as sysname)

exec sp_addserver @server = @server , local = 'local 'end

If you add it to your problem, it's extremely simple,Open SQL should be no problem,Select the database you want to automatically backup,Right click,Select all tasks and then select scheduled tasks,So that the automatic backup page option comes out,It's important here,If you want to back up the data to another computer, the backup path is changed to the network path,That is, back up a shared folder of your b server,This is believed to be very simple for you,The last point,Automatic deletion, When you set up automatic backup, there will be an option for you to set how long the files are automatically deleted, this is up to you, and how many hours you want to automatically delete are OK.