Filegroups and how to specify Full or Differential

Compresses, encrypts, secures and monitors SQL Server backups.

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

Filegroups and how to specify Full or Differential

Postby SQL_ME_RICH » Tue May 08, 2012 10:53 pm

Forgive the newbie question here, but we are doing some tests right now on backup routines, and are wanting to know if we do choose the Filegroup option to do backups with (much the way you have to do this with T-SQL or from the GUI in SSMS), is there a way to specify (a switch of some sort, or a checkbox in the Backup 6 GUI) to make sure it is a Full backup, or a Differential backup?

This is being used against a SQL Server 2005 Enterprise Edition, SP3 installation, and we have approximately 30 different Filegroups that make up various parts of the database. Just want to be able to get back to a moment in time, as accurately as possible to any kind of data loss outage, in similar fashion to an old-school Full/Diff/TLog routine.

Thank you, and forgive me if I missed this in searching your topics out here (I didn't see anything straight away along these lines...).

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

Postby SQL_ME_RICH » Tue May 08, 2012 11:04 pm

My apologies...It is Backup 7, not 6. I will repost it there, so this thread can be deleted.

Thanks again, and my apologies...
SQL_ME_RICH
 
Posts: 64
Joined: Tue May 08, 2012 10:41 pm

Postby RajK » Sun May 13, 2012 12:27 pm

I am the support engineer that is investigating this question you have reported.

I have attached below the url which describes how to do filegroup backups in SQL Backup. The article is fairly old but the content is still current for version 7.0.

http://www.red-gate.com/support/Knowled ... How-to.pdf

Please have a look and let me know if this addresses your question.

Thanks for your patience and feedback in this matter.
RajK
 
Posts: 58
Joined: Thu Feb 02, 2012 8:21 am


Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 0 guests