cancel
Showing results for 
Search instead for 
Did you mean: 

How to backup a SQL database schema and recover that schema ?

cc1702004
Level 4

May I know whether anyone has any experience backing up a SQL database schema and only recovering that database schema ? If yes, please be kind to advice how it can be done ?

I was reading the Netbackup SQL 7.7.2 admin guide, I only saw a brief mention like this :

To recover your database schema use the NetBackup
MS SQL Client to restore your latest backup of the master database.

Thank you

cc1702004

 

1 REPLY 1

Michal_Mikulik1
Level 6
Partner    VIP    Accredited Certified

Hello,

you cannot backup/restore MS SQL database schema (so group of all objects under a SQL account) directly. It is similar that you cannot backup/restore a certain table/tables directly.

What you can do is restore of the whole database into alternate db and then copy the database schema from restored db to original db by SQL means.

Actually, I dont understand the note about a master database backup below.

Regards

Michal