[AccessD] Recover SQL Server

Just attach the databases using Query Analyzer or Enterprise Manager. 

EXEC sp_attach_db @dbname = 'pubs',
        @filename1 = 'C:\Program Files\Microsoft SQL
Server\MSSQL\Data\pubs.mdf',
        @filename2 = 'C:\Program Files\Microsoft SQL
Server\MSSQL\Data\pubs_log.ldf'

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of JWColby
Sent: Thursday, April 05, 2007 9:14 PM
To: 'Access Developers discussion and problem solving';
dba-sqlserver at databaseadvisors.com
Subject: [AccessD] Recover SQL Server

Is it possible to recover a set of SQL Server databases that were mounted
(active) when my computer died?  I have the database files themselves out on
a data drive, and I have the SQL Server directory and all of its sub
directories out on the same drive, but the system that ran that sql server
is unrecoverable.  And of course I do not have a recent backup.
 
John W. Colby
Colby Consulting
www.ColbyConsulting.com
 
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.446 / Virus Database: 268.18.26/746 - Release Date: 4/4/2007
1:09 PM