SQL Server 7.0 backup and recovery-related issues
SQL Server 6.5 can dump the SQL statement (Dump) and loading (Load) SQL server 7.0?
Can back up (Backup) and the restoration of (Restore).
Resume the following information in the database, how to resolve »
SQL-DMO Error: Could not obtain exclusive lock on database Model
This is because the resume database, and are using a model database, in order to recover data before sp_who this process to see if it was stored in the database using the model.
In Windows 95/98 under SQL Server 7.0 can backup to tape in »
It does not, please database backup to disk drives by backup to tape.
In Windows 95/98, you can perform under such as "EXEC sp_addumpdevice 'tape', 'tapedump1', '\ \. \ Tape0'" command, but when you run the "backup database to tapedump1" will appear the following information: Server: Msg 3201, Level 16, State 5, Line 1 Cannot open backup device 'tapedump1'. Device error or device off-line. See the SQL Server error log for more details. Server: Msg 3013, Level 16, State 1, Line 1 Backup or restore operation terminating abnormally.
And the SQL Server 7.0 errorlog will also appear the following information: BackupTapeFile:: OpenMedia: Backup device '\ \. \ Tape0' failed to open. Operating system error = 2 (The system cannot find the file specified.).
Will be SQL Server 7.0 database backup to the network when the following information Server: Msg 3201, Level 16, State 1, Line 1 Cannot open backup device 'E: \ pubs.dat'. Device error or device off-line. See the SQL Server error log for more details. Server: Msg 3013, Level 16, State 1, Line 1 Backup or restore operation terminating abnormally.
Error log in and there 1998-12-29 11:58:21.62 kernel BackupDiskFile:: CreateMedia: Backup device'E: \ pubs.dat 'failed to create. Operating system error = 5 (Access is denied.).
How to resolve »
This is due to the lack of competence. Make sure the SQL Server Service Account for domain user (Domain User), and on the Internet written permission.
If it is possible to SQL Server 7.0 database backup to compressed volumes (Compressed Volume)?
Yes, but do not propose to do so, if the database backup to the compression volume, in a backup before and after the resumption of the implementation of DBCC.
The database will be released back to the backup failed to do a copy of the SQL Server 7.0 result in the transaction log marked as copies (replication), how to resolve »
Can refer to the following two methods:
If possible, backup database before the first publication of its unpublished.
Before the resumption, the target set in the database release.
What is the difference between backup (differential backup)?
Backup is the difference between SQL Server 7.0 to provide new features, the difference backup records only after the last full backup by the changes.
You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
Leave a Reply