Glenn,
How did you connect the database? Did you use the sp_attach_db or
the sp_attach_single_file_db store proc.?
What is the error(s) that you get?

RW

Hi all hope someone can help. Over the christmas period we had a
server crash which we can no longer get in to. I have built 2000 server on a
new hard drive and re-installed sql 7 with a script which sets up the basic
databases from previous so we only need to do a restore but can not access
the tapes to restore the backup. I can access the old hard drive and pull
over the mdf and ldf files not a problem. 2 of the original databases where
on the c: partition which have started fine after stopping the service and
pasting the files and restarting. The 6gb database which is the most
important was on a d: partition but now will only be on the c: as its 1 big
drive, I tried to copy and paste as with the other databases but can't
connect and get odbc errors.

I am really stuck with this 1 so any help would be great

Thanks

Glenn




begin 666 trans.gif
M1TE&.#EAI@`2`(#_`,# P ```"'Y! $`````+ ````"F`!(`0 (YA(^IR^T/
MHYRTVHNSWKS[#X;B2);FB:;JRK;N"\?R3-?VC>?ZSO?^#PP*A\2B\8A,*I?,
(IO,)%18``#L`
`
end

Glenn Clark (glenn.clarkNOSPAM@btinternet.com) writes:
[quoted text, click to view]

There is not much information here. I would actually suggest that you
open a case with Microsoft. If you had a crash, you may have database
files that corrupt in some way, and in such case, it's not much we can do
from here.

And in any case, try to get assistance with repairing broken server over
newsgroup may take quite some time. Assuming that it costs you money to
have the databases unavailable, the cost for a case may still be worth it.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at