[AccessD] Recover SQL Server

As I recall his database is HUGE though and he was still looking for a
method to back it up.   Good luck getting it back online John. So much
for that RAID disk technology saving you eh?  ;-)   Got bit by
something else than a drive failure I take it?

GK

On 4/6/07, William Hindman <wdhindman at dejpolsystems.com> wrote:
> ...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
> >
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Gary Kjos
garykjos at gmail.com