Re: How to get data from a malfunctioning sql-server?
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 09/16/03
- Next message: Sue Hoegemeier: "Re: how to give developer right to run SQL profiler without assign them SA right"
- Previous message: Luck: "Re: SP3 Install Error Error running script: sq3_serv_uni.sql(1)"
- In reply to: Hans Roger Lien: "How to get data from a malfunctioning sql-server?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 16 Sep 2003 09:23:52 -0400
You might be able to attach the files on the new server. Just placing them
in a directory does not work. In any case you must install sql server first
on the new server before you attempt any of this. These should help:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
-- Andrew J. Kelly SQL Server MVP "Hans Roger Lien" <hlie@cronus.no> wrote in message news:056c01c37c51$1ce91b60$a001280a@phx.gbl... > The Nachi.A virus caused system registry failure, that > forced me to replace the existing registry with an old > backup. This backup was taken before any software were > installed, and because of that none of the installed > programs are loaded in startup, including sql-server. How > do I get my data from the old crashed sql-server into an > other sql-server? Tried to just copy the files from > MSSQL\Data but that didn't work...
- Next message: Sue Hoegemeier: "Re: how to give developer right to run SQL profiler without assign them SA right"
- Previous message: Luck: "Re: SP3 Install Error Error running script: sq3_serv_uni.sql(1)"
- In reply to: Hans Roger Lien: "How to get data from a malfunctioning sql-server?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
