Re: transferring a SQL database from a hard drive?
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 08/12/04
- Next message: Dan Guzman: "Re: Backing up SQL databases"
- Previous message: Andrew J. Kelly: "Re: How to extract texts of all stored procedure"
- In reply to: boe: "transferring a SQL database from a hard drive?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 11 Aug 2004 22:01:01 -0400
In the future you should have backups so this isn't an issue but have a look
at these:
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 MVP "boe" <boe_d@hotmail.com> wrote in message news:OakYeVAgEHA.904@TK2MSFTNGP09.phx.gbl... > Our company had a server that died. I believe the database was sql personal > edition but I'm not sure. We cannot get the server back up no matter what > we do, it comes up with a blue screen of death and it was on a motherboard > that has no idendification whatsoever. We need to make the database work > again on another server and there was no backup. We can access just about > all of the files from the hard drive. > > Is there any way to import the database onto a new box? > > Thank you > >
- Next message: Dan Guzman: "Re: Backing up SQL databases"
- Previous message: Andrew J. Kelly: "Re: How to extract texts of all stored procedure"
- In reply to: boe: "transferring a SQL database from a hard drive?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
