DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 307775 - Last Review: October 29, 2007 - Revision: 4.3

This article was previously published under Q307775

On This Page

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.

MORE INFORMATION

SQL Server 2000

314546  (http://support.microsoft.com/kb/314546/EN-US/ ) HOW TO: Move Databases Between Computers That Run SQL Server
281122  (http://support.microsoft.com/kb/281122/EN-US/ ) INF: Restore File and Filegroup Backups in SQL Server
264474  (http://support.microsoft.com/kb/264474/EN-US/ ) PRB: System Database Backups Cannot be Restored on a Different Build of SQL Server
221465  (http://support.microsoft.com/kb/221465/EN-US/ ) INF: Using the WITH MOVE Option with the RESTORE Statement
274188  (http://support.microsoft.com/kb/274188/EN-US/ ) PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
168001  (http://support.microsoft.com/kb/168001/EN-US/ ) PRB: User Logon and/or Permission Errors after Restoring Dump
246133  (http://support.microsoft.com/kb/246133/ ) HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
298758  (http://support.microsoft.com/kb/298758/EN-US/ ) PRB: Using the Auto_Fix Option with sp_change_users_login Can Leave Security Vulnerabilities
274463  (http://support.microsoft.com/kb/274463/EN-US/ ) INF: Understanding and Troubleshooting the Copy Database Wizard in SQL Server 2000
60054  (http://support.microsoft.com/kb/60054/EN-US/ ) INF: Restoration of a Database from Transaction Dumps
180500  (http://support.microsoft.com/kb/180500/EN-US/ ) PRB: Missing Device Causes Database to be Marked Suspect
253817  (http://support.microsoft.com/kb/253817/EN-US/ ) HOW TO: Backup the Last Transaction Log When the Master and the Database Files Are Damaged
240867  (http://support.microsoft.com/kb/240867/EN-US/ ) 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/EN-US/ ) HOW TO: Move Databases Between Computers That Run SQL Server
281122  (http://support.microsoft.com/kb/281122/EN-US/ ) INF: Restore File and Filegroup Backups in SQL Server
224071  (http://support.microsoft.com/kb/224071/EN-US/ ) INF: Moving SQL Server Databases to a New Location
221465  (http://support.microsoft.com/kb/221465/EN-US/ ) INF: Using the WITH MOVE Option with the RESTORE Statement
274188  (http://support.microsoft.com/kb/274188/EN-US/ ) PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
168001  (http://support.microsoft.com/kb/168001/EN-US/ ) PRB: User Logon and/or Permission Errors After Restoring Dump
246133  (http://support.microsoft.com/kb/246133/ ) HOW TO: Transfer Logins and Passwords Between Instances of SQL Server
298758  (http://support.microsoft.com/kb/298758/EN-US/ ) PRB: Using the Auto_Fix Option with sp_change_users_login Can Leave Security Vulnerabilities
46424  (http://support.microsoft.com/kb/46424/EN-US/ ) INF: Copying SQL Database Files for Backup/Restore Purposes
60054  (http://support.microsoft.com/kb/60054/EN-US/ ) INF: Restoration of a Database from Transaction Dumps
180500  (http://support.microsoft.com/kb/180500/EN-US/ ) PRB: Missing Device Causes Database to be Marked Suspect
253817  (http://support.microsoft.com/kb/253817/EN-US/ ) INF: How to Backup Last Transaction Log when Files are Damaged
257855  (http://support.microsoft.com/kb/257855/EN-US/ ) BUG: Transaction Log Backup Possible After Automatic Rebuild of LDF
240867  (http://support.microsoft.com/kb/240867/EN-US/ ) INF: How to Move, Copy, and Back Up Full-Text Catalog Folders and Files
195444  (http://support.microsoft.com/kb/195444/EN-US/ ) INF: Frequently Asked Questions - SQL Server 7.0 - Conversion
298801  (http://support.microsoft.com/kb/298801/EN-US/ ) 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/EN-US/ ) PRB: User Logon and/or Permission Errors after Restoring Dump
60054  (http://support.microsoft.com/kb/60054/EN-US/ ) INF: Restoration of a Database from Transaction Dumps
46424  (http://support.microsoft.com/kb/46424/EN-US/ ) INF: Copying SQL Database Files for Backup/Restore Purposes
169039  (http://support.microsoft.com/kb/169039/EN-US/ ) INF: Disaster Recovery Planning for SQL Server
124023  (http://support.microsoft.com/kb/124023/EN-US/ ) INF: Testing Methods for SQL Server Tape Dumps or Loads
152354  (http://support.microsoft.com/kb/152354/EN-US/ ) PRB: Database Dumps and Restore May Fill Up MSDB Database
180500  (http://support.microsoft.com/kb/180500/EN-US/ ) PRB: Missing Device Causes Database to Be Marked Suspect
187824  (http://support.microsoft.com/kb/187824/EN-US/ ) INF: How to Move Tempdb to a Different Device
46424  (http://support.microsoft.com/kb/46424/EN-US/ ) INF: Copying SQL Database Files for Backup/Restore Purposes

APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbproductlink kbinfo KB307775
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support