removing a corrupt sql7 database and restoring using arcserve

[Sudmill]

Scuse the stupid question, but I havent used SQL Server since 6.5 (4 yrs ago), so thought Id ask for some advice considering the issues at hand. We have a problem where one of our six SQL server (7.0) databases is corrupt (and has been marked as such), and so needs to be removed and restored from backup, without affecting the other 5 live databases.
The last good backup tape contains a backup of all databases performed using arcserve (which Ive not used before), so Ill need to restore database X from this tape after ive removed the corrupt one(how?)

What do I need to do and look out for, and how will the restore affect the master database?

Thanks for any assistance inadvance.

J. Cheers

John (Sudmill)

 

[Sudmill]

Any ideas? Cheers

John (Sudmill)

 

[RickCole]

I've never used archserve so can't help you with that part.

But if I was in your situation with a SQL Server backup tape I would do the following:

Drop corrupt database by running the following:

DROP DATABASE dbname

Recreate database same size as original and then restore database from backup.

There are no issues to look out for on the master database.

Rick.

 

[JohnBates]

Sudmill - Like Rick, I've not ever used Arcserve either.

I use SQL Server 7. Had a database that was flagged as "Suspect" once. this db was unusable. Data replication had stopped running because of the 'damaged' db.

I didn't even DROP it.
Just performed the restore (from a Backup on same disk)

After that, everything was fine. The Restore will handle Master db itself; I wouldn't worry about that.

Maybe someone will knowledge of Arcserve will reply.
John

 

[tlbroadbent]

We stopped using Arcserve to backup SQL Server databases a couple of years ago. Now we backup SQL DBs to disk and copy the backup files to tape with Arcserve. When necessary we restore the backup from tape and then restore the database from the backup on disk.

If you are using the ArcServe SQL Agent, I believe you can choose to restore the database from a session on tape and indicate that you want to restore it to the original location. It should be restored properly.

Either scenario could result in the loss of data including new users setup on the database, roles, permissions, etc. However, it should not effect other databases, including master. Terry L. Broadbent
Programming and Computing Resources

http://tlbroadbent.home.attbi.com/prog.htm