[SQL2005] Backup Schedule

I understand most things concerning making a backup, but I cannot seem to
figure out what a sensible schedule is for making a backup. I would love to
figure this out before we go live in a few months.
The database will have a reasonable mutation rate, i.e. around 500 data
changes per day and work-loss must be kept to a minimum. We expect the size
to be around 2GB. The schedule I have made now is as follows:
Full Backup on Sunday at 02:00
Differential Backups on other weekdays at 02:00
Transaction Log Backups every 4 hours every day
Clean History 4 weeks old files every week on Sunday at 04:00
I do not know if this makes sense. I do not know if the log backup proces
will hinder the users or not. I do know there are many many variables that
play a role in making a good backup procedure, but I would greatly appreciate
any insight concerning correct scheduling. TIA!I would definitely change things a bit, considering "work-loss must be kept to a minimum".
How about database backup every day and log backup at least every hour. Or log backups every 10
minutes? The more frequent you do log backup, the less impact is will have each time it is executed
(even though the impact is low to begin with, especially if you have separated log/data/backup
disks). For a 2 GB database, I probably wouldn't do differential backups, unless you have compelling
advantages to do so.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"PaulSand" <PaulSand@.discussions.microsoft.com> wrote in message
news:E2D4C305-A7A2-4651-A4DB-CE04E247F5FB@.microsoft.com...
>I understand most things concerning making a backup, but I cannot seem to
> figure out what a sensible schedule is for making a backup. I would love to
> figure this out before we go live in a few months.
> The database will have a reasonable mutation rate, i.e. around 500 data
> changes per day and work-loss must be kept to a minimum. We expect the size
> to be around 2GB. The schedule I have made now is as follows:
> Full Backup on Sunday at 02:00
> Differential Backups on other weekdays at 02:00
> Transaction Log Backups every 4 hours every day
> Clean History 4 weeks old files every week on Sunday at 04:00
> I do not know if this makes sense. I do not know if the log backup proces
> will hinder the users or not. I do know there are many many variables that
> play a role in making a good backup procedure, but I would greatly appreciate
> any insight concerning correct scheduling. TIA!|||I agree with Tibor. Although I'm sure useful in some scenarios, we
don't use differentials at all. Fulls once per day, and then logs
every hour to two hours, is what we do. It's easier to manage the
files, and we can keep track in our head which files exactly we need in
the case of restore. And we're in the same boat - "work-loss must be
kept to a minimum".
Tibor Karaszi wrote:
> I would definitely change things a bit, considering "work-loss must be kept to a minimum".
> How about database backup every day and log backup at least every hour. Or log backups every 10
> minutes? The more frequent you do log backup, the less impact is will have each time it is executed
> (even though the impact is low to begin with, especially if you have separated log/data/backup
> disks). For a 2 GB database, I probably wouldn't do differential backups, unless you have compelling
> advantages to do so.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "PaulSand" <PaulSand@.discussions.microsoft.com> wrote in message
> news:E2D4C305-A7A2-4651-A4DB-CE04E247F5FB@.microsoft.com...
> >I understand most things concerning making a backup, but I cannot seem to
> > figure out what a sensible schedule is for making a backup. I would love to
> > figure this out before we go live in a few months.
> >
> > The database will have a reasonable mutation rate, i.e. around 500 data
> > changes per day and work-loss must be kept to a minimum. We expect the size
> > to be around 2GB. The schedule I have made now is as follows:
> >
> > Full Backup on Sunday at 02:00
> > Differential Backups on other weekdays at 02:00
> > Transaction Log Backups every 4 hours every day
> > Clean History 4 weeks old files every week on Sunday at 04:00
> >
> > I do not know if this makes sense. I do not know if the log backup proces
> > will hinder the users or not. I do know there are many many variables that
> > play a role in making a good backup procedure, but I would greatly appreciate
> > any insight concerning correct scheduling. TIA!

[:#] problems viewing the custom sql statement in the gridview control

Hi,

I really need some help trying to figure out why my gridview is not working when I create a custom sql statement. It "executes" the query, but gives me an error message when I "test the query". Here is the error message:"There was an error executing the query. Please check the syntax of the command and if present, the types and values of the parameters and ensure they are correct. Syntax error: Expecting '.', identifier or quoted identifier."

Here is my sql statement:

SELECT TBLPROJECTS.NAME, TBLPROJECTTYPES.NAME AS PROJECTTYPE, TBLPROJECTS.DESCRIPTION, TBLUSERS_1.LOGIN AS OWNERNAME,
TBLUSERS.LOGIN AS MANAGERNAME, TBLPROJECTS.START_DATE, TBLPROJECTS.END_DATE, TBLAOI.NAME AS AREAOFINTEREST,
TBLPROJECTS.MANPOWER, TBLUNITS.NAME AS MANPOWERUNIT
FROM TBLPROJECTS INNER JOIN
TBLAOI ON TBLPROJECTS.AOI_ID = TBLAOI.ID INNER JOIN
TBLPROJECTTYPES ON TBLPROJECTS.PROJECTTYPE_ID = TBLPROJECTTYPES.ID INNER JOIN
TBLUNITS ON TBLPROJECTS.MANPOWERUNITS_ID = TBLUNITS.ID INNER JOIN
TBLUSERS ON TBLPROJECTS.MANAGER_ID = TBLUSERS.ID INNER JOIN
TBLUSERS TBLUSERS_1 ON TBLPROJECTS.OWNER_ID = TBLUSERS_1.ID

I have tested it on a new project and still it does not work, I cannot find any problem, please help!!!!!!!!!!!!!!!!!!!!!!!!

Does the query compile and return results by itself if you execute it in query analyzer?

|||

Yes, it compiles in the "Execute Query" in the "Query Builder", but when I click next, and it is supposed to Test the query, it doesnt work. Then it gives me an error when I try to ctrl F5,

DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Web.HttpException: DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[HttpException (0x80004005): DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'.] System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName) +198 System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) +2775 System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) +59 System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data) +12 System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) +101 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +25 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +140 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +68 System.Web.UI.WebControls.GridView.DataBind() +5 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +61 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +67 System.Web.UI.Control.EnsureChildControls() +97 System.Web.UI.Control.PreRenderRecursiveInternal() +50 System.Web.UI.Control.PreRenderRecursiveInternal() +171 System.Web.UI.Control.PreRenderRecursiveInternal() +171 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5731

I hope this helps? Thanks

|||

Yes, it compiles in the "Execute Query" in the "Query Builder", but when I click next, and it is supposed to Test the query, it doesnt work. Then it gives me an error when I try to ctrl F5,

DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Web.HttpException: DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[HttpException (0x80004005): DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'.] System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName) +198 System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) +2775 System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) +59 System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data) +12 System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) +101 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +25 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +140 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +68 System.Web.UI.WebControls.GridView.DataBind() +5 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +61 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +67 System.Web.UI.Control.EnsureChildControls() +97 System.Web.UI.Control.PreRenderRecursiveInternal() +50 System.Web.UI.Control.PreRenderRecursiveInternal() +171 System.Web.UI.Control.PreRenderRecursiveInternal() +171 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5731

I hope this helps? Thanks

|||

Yes, it compiles in the "Execute Query" in the "Query Builder", but when I click next, and it is supposed to Test the query, it doesnt work. Then it gives me an error when I try to ctrl F5,

DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Web.HttpException: DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[HttpException (0x80004005): DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'ID'.] System.Web.UI.DataBinder.GetPropertyValue(Object container, String propName) +198 System.Web.UI.WebControls.GridView.CreateChildControls(IEnumerable dataSource, Boolean dataBinding) +2775 System.Web.UI.WebControls.CompositeDataBoundControl.PerformDataBinding(IEnumerable data) +59 System.Web.UI.WebControls.GridView.PerformDataBinding(IEnumerable data) +12 System.Web.UI.WebControls.DataBoundControl.OnDataSourceViewSelectCallback(IEnumerable data) +101 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +25 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +140 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +68 System.Web.UI.WebControls.GridView.DataBind() +5 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +61 System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +67 System.Web.UI.Control.EnsureChildControls() +97 System.Web.UI.Control.PreRenderRecursiveInternal() +50 System.Web.UI.Control.PreRenderRecursiveInternal() +171 System.Web.UI.Control.PreRenderRecursiveInternal() +171 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5731

I hope this helps? Thanks

|||Hi dotnetjunkie17,

Yes, it compiles in the "Execute Query" in the "Query Builder", but when I click next, and it is supposed to Test the query, it does not work

Since your sql query string even doesn't pass the "Query Builder" , there should be something wrong with your sql query string itself.

I've checked your query string, and find some errors. You cannot use INNER JOIN that way, to correct your errors, following the above code:

SELECT TBLPROJECTS.NAME,
TBLPROJECTTYPES.NAME AS PROJECTTYPE,
TBLPROJECTS.DESCRIPTION,
TBLUSERS_1.LOGIN AS OWNERNAME,
TBLUSERS.LOGIN AS MANAGERNAME,
TBLPROJECTS.START_DATE,
TBLPROJECTS.END_DATE,
TBLAOI.NAME AS AREAOFINTEREST,
TBLPROJECTS.MANPOWER,
TBLUNITS.NAME AS MANPOWERUNIT
FROM
TBLPROJECTS

INNER JOIN
TBLAOI ON TBLPROJECTS.AOI_ID = TBLAOI.ID
INNER JOIN
TBLPROJECTTYPES ON TBLPROJECTS.PROJECTTYPE_ID = TBLPROJECTTYPES.ID
INNER JOIN
TBLUNITS ON TBLPROJECTS.MANPOWERUNITS_ID = TBLUNITS.ID
INNER JOIN
TBLUSERS ON TBLPROJECTS.MANAGER_ID = TBLUSERS.ID
INNER JOIN
TBLUSERS TBLUSERS_1 ON TBLPROJECTS.OWNER_ID = TBLUSERS_1.ID