Restore SQL Server DataBase

[cjouault]

Hello,

I use NetBackup 5.0 and SQL Server 2000.
I want to restore only one table in my database. Is it possible? If it's possible, does I need to stop SQL Server or can use it during the restoration?

Thank

Céline

 

[comtec17]

Are you using the SQL Agent?

Do you see the table when you choose the restore option from the client?

 

[cjouault]

Hello,

Yes, I have the SQL Agent and I see the table.

Céline

 

[comtec17]

If you stopped SQL you would not be able to restore the table direct, so you will need to keep SQL online unless you are recovering from a RAW Backup.

 

[cjouault]

Thanks comtec17 but I want know if I can use the SQL Server Database (execute sql request) and restore a table in the same times.

Thanks a lot for your response.

Céline