Newbie SQL question

Article View: bit.listserv.sqlinfo

Article #325

Back to bit.listserv.sqlinfo Previous Next

#325

From: barto
Date: Wed, 08 May 2002 17:19

13 lines
1452 bytes

I had to restore a database from tape (.MDF and .LDF) files.  I
created a new SQL database and pointed the datasource to the .MDF
file, and duplicated the original settings on the live database.  
I need to be able to access this backup db to check for data
integrity.  I cannot see the tables in this restored db.  Is there
some import function I need to complete?  I have tried going through
the import data wizard, but can't get it to pull the data up.

Is there a decent web guide that I could use for reference?

Thanks, I'm very unfamiliar with SQL and have had this dumped on me,
with no support!!! help!
-b

Technical Details

Message-ID: <3cd9499c.16443013@mi.news.verio.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!sjc-peer.news.verio.net!news.verio.net!dfw-read.news.verio.net.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 11355a,550635dd78a9d049,start
X-Google-Attributes: gid11355a,public
X-Google-ArrivalTime: 2002-05-08 10:19:57 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!sjc-peer.news.verio.net!news.verio.net!dfw-read.news.verio.net.POSTED!not-for-mail
From: brent_bartman@notthisdenso-diam.com (barto)
Newsgroups: bit.listserv.sqlinfo
Subject: Newbie SQL question
Message-ID: <3cd9499c.16443013@mi.news.verio.net>
X-Newsreader: Forte Free Agent 1.21/32.243
Lines: 13
Date: Wed, 08 May 2002 17:19:51 GMT
NNTP-Posting-Host: 209.69.34.70
X-Complaints-To: abuse@verio.net
X-Trace: dfw-read.news.verio.net 1020878441 209.69.34.70 (Wed, 08 May 2002 17:20:41 GMT)
NNTP-Posting-Date: Wed, 08 May 2002 17:20:41 GMT
Organization: Verio