cancel
Showing results for 
Search instead for 
Did you mean: 

Restoring Tables, Functions and views in SQL Server

Anderson_R__Gom
Level 5
Partner Accredited Certified

Hi,

I dont know if it is possible.

I have one environment with three SQL Server 2005 and my backups are working fine.

I already restored the entire database to the same server and different server and worked fine too.

My doubt is the following.

Can I restore only one table, function or view?

Kind Regards.

 

4 REPLIES 4

Yogesh9881
Level 6
Accredited

Sorry to say but the answer is  NO  - you can not  restore one table in MS sql

that is possible with oracle 

Anderson_R__Gom
Level 5
Partner Accredited Certified

OK... I already suspected.

You said that in Oracle environment I can restore one table... But in the guide I read that to restore a table it's necessary to make a entire restore of database.

What is the procedure to restore a table in oracle environment?

Kind regards.

Yogesh9881
Level 6
Accredited

Dear

Please believe on admin guides

 

V4
Level 6
Partner Accredited

For oracle please open new thread.

Multiple question in single thread would confuse others while searching for solution relevant to theirs