Hi Anas,

Can u provide the restore logs..! Just click on Monitor Status (NB SQL
agent), check verbose and click refresh.

Just cut paste the necessary contents available in the large window...!
These are just the basic error messages but reveal quite a lot. For indepth
troubleshooting require dbclient logs.

How did u ascertain that the restore went fine. The activity monitor might
show u a success but the logs would report errors.

If u know how to use the MSSQL query analyzer, check whether any restore
processes are still running (i'm bad with SQL).

On 4/22/07, Anas Kayal <anas at up.org.qa> wrote:
>
>  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
>
> _______________________________________________
> Veritas-bu maillist  -  Veritas-bu at mailman.eng.auburn.edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: 
http://mailman.eng.auburn.edu/pipermail/veritas-bu/attachments/20070423/d4e568d1/attachment.htm