cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Veritas.com
Support

Backing up and taking apart an SQL DB to back it up separate and restoring it separate pieces

MadMax949
Level 3

‎03-23-2010 01:38 PM

Hello Backup Admin's
We would like to take a SQL DB and back up pieces of it. Not as a whole DB, but in Individuals straps. I.E. The core of the DB and its parts attached to it. If I wanted to just back up a piece of info can that be done? And if so, how? I have always done it as a whole and when a restore was needed I would restore it as a whole and take out what I needed from it.
Please pass on the good news...
Max
0 Kudos
2 REPLIES 2

MadMax949
Level 3

‎03-24-2010 10:21 AM

Has anyone backed up an SQL data base in pieces? and if so restored them that way? Do you know if that can be done?
0 Kudos

Andy_Welburn
Level 6

‎03-25-2010 01:55 AM

Don't use the SQL agent ourselves, we backup the backup as it were!

Had a quick peruse of the Admin Guide:
"A SQL Server instance cannot be backed up as a single entity. The largest granularity of a SQL Server backup is the database."

It's either not what you wanted to hear, or not what you were asking!


Listing of Veritas NetBackup (tm) 6.5 and 6.5.x Manuals and links to the respective TechNotes
0 Kudos