Well yesterday it stayed in the recovery state until I cancelled it
eventually and changed the client settings. I had the recover option set
"not recovered" which is why it was hanging. It was waiting the log file
of the DB so it just waited and waited. 

 

After selecting the "recovery" option everything restored properly.
Thanks for the help.

 

Best regards,

 

Anas

________________________________

From: Dennis Naidoo [mailto:dnaidoo at stortech.co.za] 
Sent: Monday, April 23, 2007 8:28 AM
To: Anas Kayal
Subject: RE: [Veritas-bu] SQL Backup

 

Is it in a loading state? If so, then it is because you chose
"NORECOVERY" option on your restore script.

Try running this command in query analyzer to recover the database which
take it out of the LOADING state:

restore database <database_name> with recovery;

 

 

 

________________________________

From: Anas Kayal [mailto:anas at up.org.qa] 
Sent: 22 April 2007 10:57
To: veritas-bu at mailman.eng.auburn.edu
Subject: [Veritas-bu] SQL Backup

 

Greetings All,

 

I just started backing up SQL Server 2005 using Netbackup SQL Agent. I
created a separate SQL policy for the machine with Application and
Automatic Backups within it. I then went to the machine I ran the
Netbackup SQL Agent and specified the correct connection properties and
then specified which DB's to backup.

 

The backup went find and a separate process went on for each specified
DB. Once finished. I removed the DB's from my test server and went back
to the original machine and through the SQL Agent I performed a restore
for one of the specified DB. Netbackup restored it successfully.

 

When I went to the SQL Server I can see the DB but it states that its
"Restoring". Its been restoring for the past 3 hours and it's a very
minimal DB.

 

Am I doing something wrong here? Is this the correct procedure for
backup and restore?

 

Best regards,

 

Anas

-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
http://mailman.eng.auburn.edu/pipermail/veritas-bu/attachments/20070423/e3fd87e1/attachment.htm