DetailPage-MSS-KB

知识库

文章编号: 307775 - 最后修改: 2007年10月29日 - 修订: 4.2

本文的发布号曾为 CHS307775

本页

概要

知识库中有几篇文章讨论 SQL Server 的灾难恢复问题。请参阅适合相应 SQL Server 版本的那些关于灾难恢复的文章。

更多信息

SQL Server 2000

314546  (http://support.microsoft.com/kb/314546/ ) HOW TO:在运行 SQL Server 的计算机之间移动数据库
281122  (http://support.microsoft.com/kb/281122/ ) INF: Restore File and Filegroup Backups in SQL Server
264474  (http://support.microsoft.com/kb/264474/ ) PRB:System Database Backups Cannot be Restored on a Different Build of SQL Server
221465  (http://support.microsoft.com/kb/221465/ ) INF: Using the WITH MOVE Option with the RESTORE Statement
274188  (http://support.microsoft.com/kb/274188/ ) PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
168001  (http://support.microsoft.com/kb/168001/ ) PRB:User Logon and/or Permission Errors after Restoring Dump
246133  (http://support.microsoft.com/kb/246133/ ) HOW TO:在 SQL Server 实例之间传输登录和密码
298758  (http://support.microsoft.com/kb/298758/ ) PRB:Using the Auto_Fix Option with sp_change_users_login Can Leave Security Vulnerabilities
274463  (http://support.microsoft.com/kb/274463/ ) INF:Understanding and Troubleshooting the Copy Database Wizard in SQL Server 2000
60054  (http://support.microsoft.com/kb/60054/ ) INF:Restoration of a Database from Transaction Dumps
180500  (http://support.microsoft.com/kb/180500/ ) PRB:Missing Device Causes Database to be Marked Suspect
253817  (http://support.microsoft.com/kb/253817/ ) HOW TO:当主控文件和数据库文件遭到破坏时如何备份上一个事务日志
240867  (http://support.microsoft.com/kb/240867/ ) INF: How to Move, Copy, and Back Up Full-Text Catalog Folders and Files

SQL Server 7.0

314546  (http://support.microsoft.com/kb/314546/ ) HOW TO:在运行 SQL Server 的计算机之间移动数据库
281122  (http://support.microsoft.com/kb/281122/ ) INF:Restore File and Filegroup Backups in SQL Server
224071  (http://support.microsoft.com/kb/224071/ ) INF:将 SQL Server 数据库移动到新位置
221465  (http://support.microsoft.com/kb/221465/ ) INF: Using the WITH MOVE Option with the RESTORE Statement
274188  (http://support.microsoft.com/kb/274188/ ) PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
168001  (http://support.microsoft.com/kb/168001/ ) PRB:User Logon and/or Permission Errors After Restoring Dump
246133  (http://support.microsoft.com/kb/246133/ ) HOW TO:在 SQL Server 实例之间传输登录和密码
298758  (http://support.microsoft.com/kb/298758/ ) PRB:Using the Auto_Fix Option with sp_change_users_login Can Leave Security Vulnerabilities
46424  (http://support.microsoft.com/kb/46424/ ) INF:Copying SQL Database Files for Backup/Restore Purposes
60054  (http://support.microsoft.com/kb/60054/ ) INF:Restoration of a Database from Transaction Dumps
180500  (http://support.microsoft.com/kb/180500/ ) PRB:Missing Device Causes Database to be Marked Suspect
253817  (http://support.microsoft.com/kb/253817/ ) HOW TO:当主控文件和数据库文件遭到破坏时如何备份上一个事务日志
257855  (http://support.microsoft.com/kb/257855/ ) BUG:Transaction Log Backup Possible After Automatic Rebuild of LDF
240867  (http://support.microsoft.com/kb/240867/ ) INF: How to Move, Copy, and Back Up Full-Text Catalog Folders and Files
195444  (http://support.microsoft.com/kb/195444/ ) INF: Frequently Asked Questions - SQL Server 7.0 - Conversion
298801  (http://support.microsoft.com/kb/298801/ ) PRB:Transaction Log Restores Stop Responding with "Minimum Query Memory Is Not Available" Message in Error Log

SQL Server 6.5

168001  (http://support.microsoft.com/kb/168001/ ) PRB:User Logon and/or Permission Errors after Restoring Dump
60054  (http://support.microsoft.com/kb/60054/ ) INF:Restoration of a Database from Transaction Dumps
46424  (http://support.microsoft.com/kb/46424/ ) INF:Copying SQL Database Files for Backup/Restore Purposes
169039  (http://support.microsoft.com/kb/169039/ ) INF:Disaster Recovery Planning for SQL Server
124023  (http://support.microsoft.com/kb/124023/ ) INF:Testing Methods for SQL Server Tape Dumps or Loads
152354  (http://support.microsoft.com/kb/152354/ ) PRB:Database Dumps and Restore May Fill Up MSDB Database
180500  (http://support.microsoft.com/kb/180500/ ) PRB:Missing Device Causes Database to Be Marked Suspect
187824  (http://support.microsoft.com/kb/187824/ ) INF:How to Move Tempdb to a Different Device
46424  (http://support.microsoft.com/kb/46424/ ) INF:Copying SQL Database Files for Backup/Restore Purposes

这篇文章中的信息适用于:
  • Microsoft SQL Server 2000 标准版
  • Microsoft SQL Server 6.5 标准版
  • Microsoft SQL Server 7.0 标准版
关键字: 
kbproductlink kbinfo KB307775
Microsoft和/或其各供应商对于为任何目的而在本服务器上发布的文件及有关图形所含信息的适用性,不作任何声明。 所有该等文件及有关图形均"依样"提供,而不带任何性质的保证。Microsoft和/或其各供应商特此声明,对所有与该等信息有关的保证和条件不负任何责任,该等保证和条件包括关于适销性、符合特定用途、所有权和非侵权的所有默示保证和条件。在任何情况下,在由于使用或运行本服务器上的信息所引起的或与该等使用或运行有关的诉讼中,Microsoft和/或其各供应商就因丧失使用、数据或利润所导致的任何特别的、间接的、衍生性的损害或任何因使用而丧失所导致的之损害、数据或利润不负任何责任。
其他支持选项
Microsoft Community 支持论坛
直接联系我们
查找 Microsoft 认证合作伙伴
Microsoft 商店