SQL 6.5 database recovery

Article View: bit.databases.mssql-l

Article #81

Back to bit.databases.mssql-l Previous Next

#81

From: eloi
Date: Sat, 29 Apr 2000 00:00

13 lines
1371 bytes

I don't know very much about SQL. I've got a problem I hope someone
can help me with. A person with very little common sense was
expirementing with our SQL backup and deleted a database from
Enterprise Mgr so he could restore it from backup. The backup is with
Arcserve and it looks like it's not gonna restore. 

The thing is we have a file copy of the "device" files - both the
database and the log. I tried creating a new database with the same
names, shutting SQL down and copying the backup files back, then
restarting. SQL marks the database "Suspect." I ran the SP_Resetstatus
and it seemed to run, but after restarting the services the database
is still suspect. Anyone have any idea how I can get this database
working again?

Technical Details

Message-ID: <i=EKOWZVvpT=tjMUita6RAy+Dsdg@4ax.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6611,ea1f59e9efd7cc52,start
X-Google-Attributes: gidf6611,public
From: eloi <eloi@notmyemail.com>
Subject: SQL 6.5 database recovery
Date: 2000/04/29
Message-ID: <i=EKOWZVvpT=tjMUita6RAy+Dsdg@4ax.com>
X-Deja-AN: 617185288
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: abuse@home.net
X-Trace: news1.alsv1.occa.home.com 957018780 24.5.134.174 (Sat, 29 Apr 2000 07:33:00 PDT)
Organization: @Home Network
MIME-Version: 1.0
NNTP-Posting-Date: Sat, 29 Apr 2000 07:33:00 PDT
Newsgroups: bit.databases.mssql-l