Microsoft KB Archive/307775

= INF: Disaster Recovery Articles for Microsoft SQL Server =

Article ID: 307775

Article Last Modified on 10/29/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q307775



SUMMARY
SQL Server has several Knowledge Base articles about disaster recovery. Refer to the appropriate version of SQL Server to see what disaster recovery articles are available for that version.



SQL Server 2000
314546 HOW TO: Move Databases Between Computers That Run SQL Server

281122 INF: Restore File and Filegroup Backups in SQL Server

264474 PRB: System Database Backups Cannot be Restored on a Different Build of SQL Server

221465 INF: Using the WITH MOVE Option with the RESTORE Statement

274188 PRB: &quot;Troubleshooting Orphaned Users&quot; Topic in Books Online is Incomplete

168001 PRB: User Logon and/or Permission Errors after Restoring Dump

246133 HOW TO: Transfer Logins and Passwords Between Instances of SQL Server

298758 PRB: Using the Auto_Fix Option with sp_change_users_login Can Leave Security Vulnerabilities

274463 INF: Understanding and Troubleshooting the Copy Database Wizard in SQL Server 2000

60054 INF: Restoration of a Database from Transaction Dumps

180500 PRB: Missing Device Causes Database to be Marked Suspect

253817 HOW TO: Backup the Last Transaction Log When the Master and the Database Files Are Damaged

240867 INF: How to Move, Copy, and Back Up Full-Text Catalog Folders and Files

SQL Server 7.0
314546 HOW TO: Move Databases Between Computers That Run SQL Server

281122 INF: Restore File and Filegroup Backups in SQL Server

224071 INF: Moving SQL Server Databases to a New Location

221465 INF: Using the WITH MOVE Option with the RESTORE Statement

274188 PRB: &quot;Troubleshooting Orphaned Users&quot; Topic in Books Online is Incomplete

168001 PRB: User Logon and/or Permission Errors After Restoring Dump

246133 HOW TO: Transfer Logins and Passwords Between Instances of SQL Server

298758 PRB: Using the Auto_Fix Option with sp_change_users_login Can Leave Security Vulnerabilities

46424 INF: Copying SQL Database Files for Backup/Restore Purposes

60054 INF: Restoration of a Database from Transaction Dumps

180500 PRB: Missing Device Causes Database to be Marked Suspect

253817 INF: How to Backup Last Transaction Log when Files are Damaged

257855 BUG: Transaction Log Backup Possible After Automatic Rebuild of LDF

240867 INF: How to Move, Copy, and Back Up Full-Text Catalog Folders and Files

195444 INF: Frequently Asked Questions - SQL Server 7.0 - Conversion

298801 PRB: Transaction Log Restores Stop Responding with &quot;Minimum Query Memory Is Not Available&quot; Message in Error Log

SQL Server 6.5
168001 PRB: User Logon and/or Permission Errors after Restoring Dump

60054 INF: Restoration of a Database from Transaction Dumps

46424 INF: Copying SQL Database Files for Backup/Restore Purposes

169039 INF: Disaster Recovery Planning for SQL Server

124023 INF: Testing Methods for SQL Server Tape Dumps or Loads

152354 PRB: Database Dumps and Restore May Fill Up MSDB Database

180500 PRB: Missing Device Causes Database to Be Marked Suspect

187824 INF: How to Move Tempdb to a Different Device

46424 INF: Copying SQL Database Files for Backup/Restore Purposes

Additional query words: kbSQLServ2000 kbSQLServ650 kbSQLServ700

Keywords: kbproductlink kbinfo KB307775

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.