SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL DB Recovery
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kerrycorcoran
Starting Member

38 Posts

Posted - 06/14/2007 :  10:47:18  Show Profile  Reply with Quote
Please help!

Windows Server 2003 SE
SQL 2000 w/ 4
Veritas Netbackup 5.1 w/ MP5 (for backup/recovery)

Sometimes, not always, when I attempt to recovery a database I will follow the process of restoring the DB and it will complete with a status of successful. However when I attempt to view the DB in Enterprise Manager it states (loading) next to the DB - and never finishes.

As I said, this doesn't happen all the time, but of course when it happens I only know to start over, rebuild everything and go through the recovery process again. I am sure this is something simple.

I apologize for my lack of knowledge in regards to SQL.

Any insight greatly appreciated.
Thanks,
Kerry

Edited by - kerrycorcoran on 06/14/2007 11:13:47

Kristen
Test

United Kingdom
22431 Posts

Posted - 06/14/2007 :  10:59:26  Show Profile  Reply with Quote
"view the DB in Enterprise Manager it states (loading) "

I presume you are trying REFRESH (i.e. right-click the database, choose REFRESH) a few times in E.M. before assuming it didn't work?

I loathe Veritas for SQL backups. And I'm not alone in these parts!

backup SQL database to a disk file. Get Veritas to back up the file to tape. Much more reliable than getting Veritas to backup the database directly to tape.

Kristen
Go to Top of Page

kerrycorcoran
Starting Member

38 Posts

Posted - 06/14/2007 :  11:13:09  Show Profile  Reply with Quote
Kristen,

Yes, I have clicked refresh a few times; still loading.

I am can certainly entertain the idea of using SQL to backup to file/disk and have Veritas backup the file, however I need to recover this first.

Aprreciate any help! I am down right now.

Thanks,
Kerry
Go to Top of Page

Kristen
Test

United Kingdom
22431 Posts

Posted - 06/14/2007 :  11:24:24  Show Profile  Reply with Quote
I don't know diddly-squat about Veritsa, so sorry for naive questions.

Can you recover from Tape to a File first, and then try recovering the file? On SQL 2005 there is some ability to test a backup file for integrity.

Recovering on another machine is an option too. Do you have an identical tape deck on a different machine (in case the tape can be read better on the other machine's tape drive)

Enough disk space for the recovery to complete?

Is it attempting to do a recovery and THEN recover some more (e.g. DIFF or TLog files)?

(There is a recovery setting to NOT put the database live, which allows you to subsequently recover one, or more, TLog backups and THEN put it live)

Kristen
Go to Top of Page

kerrycorcoran
Starting Member

38 Posts

Posted - 06/14/2007 :  12:11:49  Show Profile  Reply with Quote
Kristen,

Not so sure this issue is being caused by Veritas. Again, not an expert with SQL, so I could be way off.

But Veritas will complete the restore and reply successful, yet when I opem EM I see the loading message.

This stinks!
Kerry
Go to Top of Page

blindman
Flowing Fount of Yak Knowledge

USA
2365 Posts

Posted - 06/14/2007 :  13:19:10  Show Profile  Reply with Quote
Agreed on Veritas. I've seen too many customers who THOUGHT they were getting nightly backups, but in reality did not have recoverability.
Use SQL Server tools to backup to dump databases and logs to files, and then use Veritas to archive those files.

e4 d5 xd5 Nf6
Go to Top of Page

rmiao
Flowing Fount of Yak Knowledge

USA
7266 Posts

Posted - 06/14/2007 :  13:22:44  Show Profile  Reply with Quote
What kind of restore options does Veritas have? Did it restore db to usable status (not with norecovery nor standby option)?
Go to Top of Page

Kristen
Test

United Kingdom
22431 Posts

Posted - 06/14/2007 :  14:12:53  Show Profile  Reply with Quote
Good point!

See if database can be put "live". After Veritas has finished try:

RESTORE DATABASE MyDatabase RECOVERY

Kristen
Go to Top of Page

kerrycorcoran
Starting Member

38 Posts

Posted - 06/14/2007 :  14:45:01  Show Profile  Reply with Quote
Everyone thanks for your insight. Was able to get this resolved by using the information you had given. The issue was caused by the Recovery setting ; i had inadvertantly set it to NOT RECOVERED. I changed this setting to RECOVERED and all is well!

Thank you very much!

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000