Filegroups and how to specify Full or Differential
SQL_ME_RICH
Posts: 112
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
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
Comments
Thanks again, and my apologies...
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.