[AccessD] Recover SQL Server

...geez Eric. you could have allowed JC to at least sweat a bit longer :)

William Hindman

----- Original Message ----- 
From: "Eric Barro" <ebarro at verizon.net>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Friday, April 06, 2007 12:34 AM
Subject: Re: [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
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>