[AccessD] Recover SQL Server

...amazing how often us old horses don't do as we say ...can't count the 
number of times I've been caught without a backup when I really needed one 
...and then resolve to never do that again ...until the next time :)
William Hindman
----- Original Message ----- 
From: "JWColby" <jwcolby at colbyconsulting.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Friday, April 06, 2007 10:05 AM
Subject: Re: [AccessD] Recover SQL Server


> Believe me, I have been sweating plenty already.  8>(~)
>
>
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman
> Sent: Friday, April 06, 2007 1:41 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [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
>>
>
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>