RE: MSSQL Server Recovery
From: Pankaj Agarwal [MSFT] (pankaja_at_online.microsoft.com)
Date: 08/27/04
- Next message: UncleSam89: "Questions on compatibility SQL Server 2000 and 2005"
- Previous message: dwaine: "RE: Job step fails with Error 7399 and 7312"
- In reply to: KS: "MSSQL Server Recovery"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 27 Aug 2004 23:45:58 GMT
Hello KS
Assuming you have all database files (including system databases - master,
msdb), you should follow the steps below :
1. Install SQL Server to the same location on the second server (as your
old server)
2. Apply the same service pack and/or hotfix that you had on your old
server.
3. Stop SQL Server services and replace all database files with the ones
that you had from your old server.
Remember the above step may not work correctly if you do not have the
system database file level backups. If this condition was a result of file
system corruption and the database files were copied after the corruption,
its possible that they may be corrupted too. So the above steps may not
work.
If you only have the user database files, follow the step in the article
below :
314546 HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/?id=314546
There is also a section in the above article regarding recovering orphaned
logins.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
- Next message: UncleSam89: "Questions on compatibility SQL Server 2000 and 2005"
- Previous message: dwaine: "RE: Job step fails with Error 7399 and 7312"
- In reply to: KS: "MSSQL Server Recovery"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
