Backup only specific tables...

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Backup only specific tables...

Postby SQL_ME_RICH » Tue Jun 26, 2012 6:30 pm

Hello -

Is there a way with 7.0.6.2 to back up just specific tables of any given database? Or are the only options Full, Diff, Log?

Thank you,
SQL_ME_RICH
SQL_ME_RICH
 
Posts: 64
Joined: Tue May 08, 2012 10:41 pm

Postby Marianne » Wed Jun 27, 2012 10:20 am

Hi

It is not possible to back up specific tables. However, you can select Filegroups or files on step 2 of the backup wizards, then select the particular filegroups or files of a database that you want to back up.

Cheers,

Marianne
Marianne Crowder
Red Gate Software Limited
Marianne
 
Posts: 45
Joined: Mon Oct 03, 2011 3:24 pm

Postby SQL_ME_RICH » Thu Jun 28, 2012 1:45 am

Yeah - unfortunately, that won't work for this particular scenario, but thank you for the information!
SQL_ME_RICH
 
Posts: 64
Joined: Tue May 08, 2012 10:41 pm


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests