Red Gate forums :: View topic - Filegroups and how to specify Full or Differential
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

Filegroups and how to specify Full or Differential

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
SQL_ME_RICH



Joined: 08 May 2012
Posts: 60

PostPosted: Tue May 08, 2012 10:53 pm    Post subject: Filegroups and how to specify Full or Differential Reply with quote

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
Back to top
View user's profile Send private message
SQL_ME_RICH



Joined: 08 May 2012
Posts: 60

PostPosted: Tue May 08, 2012 11:04 pm    Post subject: Reply with quote

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

Thanks again, and my apologies...
Back to top
View user's profile Send private message
RajK



Joined: 02 Feb 2012
Posts: 58

PostPosted: Sun May 13, 2012 12:27 pm    Post subject: Reply with quote

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/Knowledgebase/SQL_Backup/SQL%20Backup%20Filegroup%20How-to.pdf

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

Thanks for your patience and feedback in this matter.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group