Home > Archive > microsoft.public.sqlserver.server > November 2002 > HELP - cannot attach physical database file





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author HELP - cannot attach physical database file
W H Hodson

2002-11-11, 5:23 pm

I had to un-install my MSDE (SQL 7) server and re-install
it today when the 'sa' user was somehow corrupted.

I have an intact database that contains data that was not
backed up in the last 2 weeks. I don't want to loose it.

I would like to attach the old database to the new server.

sp_attach_db does NOT seem to work. It creates a new
database but none of the actual data files are there.

Steven Wilmot

2002-11-11, 7:23 pm

Can you post details

- what syntax are you using to attach the database
- what error are you getting.

etc.


"W H Hodson" <bhodson@jgraves.com> wrote in message
news:a18001c289d6$e4de5d60$39e
f2ecf@TKMSFTNGXA08...
> I had to un-install my MSDE (SQL 7) server and re-install
> it today when the 'sa' user was somehow corrupted.
>
> I have an intact database that contains data that was not
> backed up in the last 2 weeks. I don't want to loose it.
>
> I would like to attach the old database to the new server.
>
> sp_attach_db does NOT seem to work. It creates a new
> database but none of the actual data files are there.
>



Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net