cancel
Showing results for 
Search instead for 
Did you mean: 

Need to configure the SQL backup in Netbackup 7.6...Pls help

A_3
Level 4
Certified

Presently database is offline. But need to take one time backup.

How we can proceed with.....Also tell me the policy type to select.

 

Regards,

Ajay Kumar

1 ACCEPTED SOLUTION

Accepted Solutions

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

Hello,

 

yes SQL db backup is not possible for offline databases.

Just backup files which constitute the database - that should be one .mdf at least and one .ldf at least. Refer to SQL documentation or consult your dba.

Restore then would be in two steps:

- file-level restore or these files

- sp_attach_db action on these files

Regards

Michal

View solution in original post

3 REPLIES 3

Michal_Mikulik1
Moderator
Moderator
Partner    VIP    Accredited Certified

Hello,

 

yes SQL db backup is not possible for offline databases.

Just backup files which constitute the database - that should be one .mdf at least and one .ldf at least. Refer to SQL documentation or consult your dba.

Restore then would be in two steps:

- file-level restore or these files

- sp_attach_db action on these files

Regards

Michal

A_3
Level 4
Certified

Thanks Michal..

Please expain in details... Since client is requested there SQL backups. But those are offline.

Once online what should i select for policy type. Since i am unable to find the MS SQL-Server type in NBU 7.6

 

Regards,

Ajay Kumar

Marianne
Level 6
Partner    VIP    Accredited Certified
You need Application and Database license on the master server to enable MS-SQL policy type. Download the NBU for MS-SQL manual for detailed instructions. Links to manuals in Handy NBU Links in my signature.