Help with backup strategy

Hi,
I was just asked by my management to implement a new backup strategy. They
want me to be able to go back at any point in time to recover data. Example
auditing purposes. What do you guys recommend? My database is 8gb and
growing. Currently I was making a complete backup daily but only for 6 days
MTWTFS. Now I must also be able to recover at the very most recent point in
time as well.
Thanks
Transaction log backups:
http://msdn.microsoft.com/library/de...kprst_565v.asp
http://msdn.microsoft.com/library/de...ackpc_5a61.asp
http://msdn.microsoft.com/library/de...ackpc_6pv6.asp
David Portas
SQL Server MVP
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:63FAD062-5331-4F19-906E-B2B3E4F8223F@.microsoft.com...
> Hi,
> I was just asked by my management to implement a new backup strategy. They
> want me to be able to go back at any point in time to recover data.
> Example
> auditing purposes. What do you guys recommend? My database is 8gb and
> growing. Currently I was making a complete backup daily but only for 6
> days
> MTWTFS. Now I must also be able to recover at the very most recent point
> in
> time as well.
> Thanks
|||Chris wrote:
> Hi,
> I was just asked by my management to implement a new backup strategy. They
> want me to be able to go back at any point in time to recover data. Example
> auditing purposes. What do you guys recommend? My database is 8gb and
> growing. Currently I was making a complete backup daily but only for 6 days
> MTWTFS. Now I must also be able to recover at the very most recent point in
> time as well.
> Thanks
Hi Chris
You need to backup both your database and you logfiles. In this way, you
can always restore a database backup and then apply the logfiles up till
the time you want data restored.
You could e.g. do a full database backup at 22.00 and then logfiles
backup's at 10.00, 14.00 and 18.00. If you then need to restore data to
how it was at 12.00, you restore your full backup and then apply the log
from 10.00 and the log from 14.00 with the STOPAT 12.00 option.
The times is of course just examples, and can be anything you want. If
you just need this for auditing reasons, you could maybe go with only 1
logfile backup.
Try reading up on Backup and Restore in Books On Line - e.g. "Backing Up
and Restoring Databases", That might give you an idea on how to set up
the best plan that suits you.
Regards
Steen
|||Chris
http://vyaskn.tripod.com/sql_server_...ices.htm#Step1
--administaiting best practices
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:63FAD062-5331-4F19-906E-B2B3E4F8223F@.microsoft.com...
> Hi,
> I was just asked by my management to implement a new backup strategy. They
> want me to be able to go back at any point in time to recover data.
> Example
> auditing purposes. What do you guys recommend? My database is 8gb and
> growing. Currently I was making a complete backup daily but only for 6
> days
> MTWTFS. Now I must also be able to recover at the very most recent point
> in
> time as well.
> Thanks
|||Hi,
But would this allow me to go back say 6 months of a full year?
Thanks
"Chris" wrote:

> Hi,
> I was just asked by my management to implement a new backup strategy. They
> want me to be able to go back at any point in time to recover data. Example
> auditing purposes. What do you guys recommend? My database is 8gb and
> growing. Currently I was making a complete backup daily but only for 6 days
> MTWTFS. Now I must also be able to recover at the very most recent point in
> time as well.
> Thanks
|||Chris
Yes it would. Let say you do backups of the database every night and every
hour a log file. Well , due to a hardware failure or something like that you
losed the last full backup. Don't worry , restore a full backup database
from two weeks ago and the apply every log file backup ( the last one with
recovery option) .See, the data is in the database.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:AA41051A-A58E-4359-B3B3-5671B151F5DC@.microsoft.com...[vbcol=seagreen]
> Hi,
> But would this allow me to go back say 6 months of a full year?
> Thanks
> "Chris" wrote:

Help with backup strategy

Hi,
I was just asked by my management to implement a new backup strategy. They
want me to be able to go back at any point in time to recover data. Example
auditing purposes. What do you guys recommend? My database is 8gb and
growing. Currently I was making a complete backup daily but only for 6 days
MTWTFS. Now I must also be able to recover at the very most recent point in
time as well.
ThanksTransaction log backups:
http://msdn.microsoft.com/library/d... />
t_565v.asp
http://msdn.microsoft.com/library/d...>
kpc_5a61.asp
http://msdn.microsoft.com/library/d...>
kpc_6pv6.asp
David Portas
SQL Server MVP
--
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:63FAD062-5331-4F19-906E-B2B3E4F8223F@.microsoft.com...
> Hi,
> I was just asked by my management to implement a new backup strategy. They
> want me to be able to go back at any point in time to recover data.
> Example
> auditing purposes. What do you guys recommend? My database is 8gb and
> growing. Currently I was making a complete backup daily but only for 6
> days
> MTWTFS. Now I must also be able to recover at the very most recent point
> in
> time as well.
> Thanks|||Chris wrote:
> Hi,
> I was just asked by my management to implement a new backup strategy. They
> want me to be able to go back at any point in time to recover data. Exampl
e
> auditing purposes. What do you guys recommend? My database is 8gb and
> growing. Currently I was making a complete backup daily but only for 6 day
s
> MTWTFS. Now I must also be able to recover at the very most recent point i
n
> time as well.
> Thanks
Hi Chris
You need to backup both your database and you logfiles. In this way, you
can always restore a database backup and then apply the logfiles up till
the time you want data restored.
You could e.g. do a full database backup at 22.00 and then logfiles
backup's at 10.00, 14.00 and 18.00. If you then need to restore data to
how it was at 12.00, you restore your full backup and then apply the log
from 10.00 and the log from 14.00 with the STOPAT 12.00 option.
The times is of course just examples, and can be anything you want. If
you just need this for auditing reasons, you could maybe go with only 1
logfile backup.
Try reading up on Backup and Restore in Books On Line - e.g. "Backing Up
and Restoring Databases", That might give you an idea on how to set up
the best plan that suits you.
Regards
Steen|||Chris
http://vyaskn.tripod.com/ sql_serve...r />
.htm#Step1
--administaiting best practices
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:63FAD062-5331-4F19-906E-B2B3E4F8223F@.microsoft.com...
> Hi,
> I was just asked by my management to implement a new backup strategy. They
> want me to be able to go back at any point in time to recover data.
> Example
> auditing purposes. What do you guys recommend? My database is 8gb and
> growing. Currently I was making a complete backup daily but only for 6
> days
> MTWTFS. Now I must also be able to recover at the very most recent point
> in
> time as well.
> Thanks|||Hi,
But would this allow me to go back say 6 months of a full year?
Thanks
"Chris" wrote:

> Hi,
> I was just asked by my management to implement a new backup strategy. They
> want me to be able to go back at any point in time to recover data. Exampl
e
> auditing purposes. What do you guys recommend? My database is 8gb and
> growing. Currently I was making a complete backup daily but only for 6 day
s
> MTWTFS. Now I must also be able to recover at the very most recent point i
n
> time as well.
> Thanks|||Chris
Yes it would. Let say you do backups of the database every night and every
hour a log file. Well , due to a hardware failure or something like that you
losed the last full backup. Don't worry , restore a full backup database
from two weeks ago and the apply every log file backup ( the last one with
recovery option) .See, the data is in the database.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:AA41051A-A58E-4359-B3B3-5671B151F5DC@.microsoft.com...[vbcol=seagreen]
> Hi,
> But would this allow me to go back say 6 months of a full year?
> Thanks
> "Chris" wrote:
>

Help with backup strategy

Hi,
I was just asked by my management to implement a new backup strategy. They
want me to be able to go back at any point in time to recover data. Example
auditing purposes. What do you guys recommend? My database is 8gb and
growing. Currently I was making a complete backup daily but only for 6 days
MTWTFS. Now I must also be able to recover at the very most recent point in
time as well.
ThanksTransaction log backups:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_565v.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpc_5a61.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_backpc_6pv6.asp
--
David Portas
SQL Server MVP
--
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:63FAD062-5331-4F19-906E-B2B3E4F8223F@.microsoft.com...
> Hi,
> I was just asked by my management to implement a new backup strategy. They
> want me to be able to go back at any point in time to recover data.
> Example
> auditing purposes. What do you guys recommend? My database is 8gb and
> growing. Currently I was making a complete backup daily but only for 6
> days
> MTWTFS. Now I must also be able to recover at the very most recent point
> in
> time as well.
> Thanks|||Chris wrote:
> Hi,
> I was just asked by my management to implement a new backup strategy. They
> want me to be able to go back at any point in time to recover data. Example
> auditing purposes. What do you guys recommend? My database is 8gb and
> growing. Currently I was making a complete backup daily but only for 6 days
> MTWTFS. Now I must also be able to recover at the very most recent point in
> time as well.
> Thanks
Hi Chris
You need to backup both your database and you logfiles. In this way, you
can always restore a database backup and then apply the logfiles up till
the time you want data restored.
You could e.g. do a full database backup at 22.00 and then logfiles
backup's at 10.00, 14.00 and 18.00. If you then need to restore data to
how it was at 12.00, you restore your full backup and then apply the log
from 10.00 and the log from 14.00 with the STOPAT 12.00 option.
The times is of course just examples, and can be anything you want. If
you just need this for auditing reasons, you could maybe go with only 1
logfile backup.
Try reading up on Backup and Restore in Books On Line - e.g. "Backing Up
and Restoring Databases", That might give you an idea on how to set up
the best plan that suits you.
Regards
Steen|||Chris
http://vyaskn.tripod.com/sql_server_administration_best_practices.htm#Step1
--administaiting best practices
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:63FAD062-5331-4F19-906E-B2B3E4F8223F@.microsoft.com...
> Hi,
> I was just asked by my management to implement a new backup strategy. They
> want me to be able to go back at any point in time to recover data.
> Example
> auditing purposes. What do you guys recommend? My database is 8gb and
> growing. Currently I was making a complete backup daily but only for 6
> days
> MTWTFS. Now I must also be able to recover at the very most recent point
> in
> time as well.
> Thanks|||Hi,
But would this allow me to go back say 6 months of a full year?
Thanks
"Chris" wrote:
> Hi,
> I was just asked by my management to implement a new backup strategy. They
> want me to be able to go back at any point in time to recover data. Example
> auditing purposes. What do you guys recommend? My database is 8gb and
> growing. Currently I was making a complete backup daily but only for 6 days
> MTWTFS. Now I must also be able to recover at the very most recent point in
> time as well.
> Thanks|||Chris
Yes it would. Let say you do backups of the database every night and every
hour a log file. Well , due to a hardware failure or something like that you
losed the last full backup. Don't worry , restore a full backup database
from two weeks ago and the apply every log file backup ( the last one with
recovery option) .See, the data is in the database.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:AA41051A-A58E-4359-B3B3-5671B151F5DC@.microsoft.com...
> Hi,
> But would this allow me to go back say 6 months of a full year?
> Thanks
> "Chris" wrote:
>> Hi,
>> I was just asked by my management to implement a new backup strategy.
>> They
>> want me to be able to go back at any point in time to recover data.
>> Example
>> auditing purposes. What do you guys recommend? My database is 8gb and
>> growing. Currently I was making a complete backup daily but only for 6
>> days
>> MTWTFS. Now I must also be able to recover at the very most recent point
>> in
>> time as well.
>> Thankssql

Help with "enableEventValidation"

The "enableEventValidation" feauture is new for .Net 2.0

When I had a page that called back to itself through the use of a pushbutton, I recieved an error stating:

Invalid postback or callback argument. Event validation is enabled using <pages enableEventValidation="true"/> in configuration or <%@. Page EnableEventValidation="true" %> in a page. For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them. If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation.

I went into my web.config file and inserted the following as suggested by microsoft:

<system.web>
<pages enableEventValidation="true" />
</system.web>

Now the error has gone away, however, the whole point of this particular page is to allow me to edit a row in a datagrid. When I click on the edit button, the page is called back to itself but I the chosen row (and none of the page for that matter) is availible to be edited.

Any ideas on what I am doing wrong? I want to call back the page so that I can edit the row that I chose by clicking on that row's "edit" button.

Here is the actual code from my page:

<%@. Page Language="C#" ContentType="text/html" ResponseEncoding="iso-8859-1" %>
<%@. Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
<MM:DataSet
id="dsParts"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_STRING_PartsAreUs"] %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_DATABASETYPE_PartsAreUs"] %>'
CommandText='<%# "SELECT * FROM dbo.Parts" %>'
Debug="true"
>
<EditOps>
<EditOpsTable Name="dbo.Parts" />
<Parameter Name="Name" Type="VarChar" />
<Parameter Name="Description" Type="NVarChar" />
<Parameter Name="Price" Type="Money" />
<Parameter Name="PartID" Type="Int" IsPrimary="true" />
</EditOps>
</MM:DataSet>
<MM:PageBind runat="server" PostBackBind="true" />
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>
<body>
<form runat="server">
<asp:DataGrid id="dgParts"
runat="server"
AllowSorting="False"
AutoGenerateColumns="false"
CellPadding="3"
CellSpacing="0"
ShowFooter="false"
ShowHeader="true"
DataSource="<%# dsParts.DefaultView %>"
PagerStyle-Mode="NextPrev"
DataKeyField="PartID"
onCancelCommand="dsParts.OnDataGridCancel"
onEditCommand="dsParts.OnDataGridEdit"
onUpdateCommand="dsParts.OnDataGridUpdate"
onItemDataBound="dsParts.OnDataGridItemDataBound"
>
<HeaderStyle HorizontalAlign="center" BackColor="#E8EBFD" ForeColor="#3D3DB6" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Bold="true" Font-Size="smaller" />
<ItemStyle BackColor="#F2F2F2" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Size="smaller" />
<AlternatingItemStyle BackColor="#E5E5E5" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Size="smaller" />
<FooterStyle HorizontalAlign="center" BackColor="#E8EBFD" ForeColor="#3D3DB6" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Bold="true" Font-Size="smaller" />
<PagerStyle BackColor="white" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Size="smaller" />
<Columns>
<asp:EditCommandColumn
ButtonType="PushButton"
CancelText="Cancel"
EditText="Edit"
HeaderText="Edit"
UpdateText="Update"
Visible="True"/>
<asp:BoundColumn DataField="PartID"
HeaderText="PartID"
ReadOnly="true"
Visible="True"/>
<asp:BoundColumn DataField="Name"
HeaderText="Name"
ReadOnly="false"
Visible="True"/>
<asp:BoundColumn DataField="Description"
HeaderText="Description"
ReadOnly="false"
Visible="True"/>
<asp:BoundColumn DataField="Price"
HeaderText="Price"
ReadOnly="false"
Visible="True"/>
</Columns>
</asp:DataGrid>
</form>
</body>
</html>

Check here:

http://aspalliance.com/146_Editing_a_DataGrid_Control

Buck Woody

Help with "enableEventValidation"

The "enableEventValidation" feauture is new for .Net 2.0

When I had a page that called back to itself through the use of a pushbutton, I recieved an error stating:

Invalid postback or callback argument. Event validation is enabled using <pages enableEventValidation="true"/> in configuration or <%@. Page EnableEventValidation="true" %> in a page. For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them. If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation.

I went into my web.config file and inserted the following as suggested by microsoft:

<system.web>
<pages enableEventValidation="true" />
</system.web>

Now the error has gone away, however, the whole point of this particular page is to allow me to edit a row in a datagrid. When I click on the edit button, the page is called back to itself but I the chosen row (and none of the page for that matter) is availible to be edited.

Any ideas on what I am doing wrong? I want to call back the page so that I can edit the row that I chose by clicking on that row's "edit" button.

Here is the actual code from my page:

<%@. Page Language="C#" ContentType="text/html" ResponseEncoding="iso-8859-1" %>
<%@. Register TagPrefix="MM" Namespace="DreamweaverCtrls" Assembly="DreamweaverCtrls,version=1.0.0.0,publicKeyToken=836f606ede05d46a,culture=neutral" %>
<MM:DataSet
id="dsParts"
runat="Server"
IsStoredProcedure="false"
ConnectionString='<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_STRING_PartsAreUs"] %>'
DatabaseType='<%# System.Configuration.ConfigurationSettings.AppSettings["MM_CONNECTION_DATABASETYPE_PartsAreUs"] %>'
CommandText='<%# "SELECT * FROM dbo.Parts" %>'
Debug="true"
>
<EditOps>
<EditOpsTable Name="dbo.Parts" />
<Parameter Name="Name" Type="VarChar" />
<Parameter Name="Description" Type="NVarChar" />
<Parameter Name="Price" Type="Money" />
<Parameter Name="PartID" Type="Int" IsPrimary="true" />
</EditOps>
</MM:DataSet>
<MM:PageBind runat="server" PostBackBind="true" />
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>
<body>
<form runat="server">
<asp:DataGrid id="dgParts"
runat="server"
AllowSorting="False"
AutoGenerateColumns="false"
CellPadding="3"
CellSpacing="0"
ShowFooter="false"
ShowHeader="true"
DataSource="<%# dsParts.DefaultView %>"
PagerStyle-Mode="NextPrev"
DataKeyField="PartID"
onCancelCommand="dsParts.OnDataGridCancel"
onEditCommand="dsParts.OnDataGridEdit"
onUpdateCommand="dsParts.OnDataGridUpdate"
onItemDataBound="dsParts.OnDataGridItemDataBound"
>
<HeaderStyle HorizontalAlign="center" BackColor="#E8EBFD" ForeColor="#3D3DB6" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Bold="true" Font-Size="smaller" />
<ItemStyle BackColor="#F2F2F2" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Size="smaller" />
<AlternatingItemStyle BackColor="#E5E5E5" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Size="smaller" />
<FooterStyle HorizontalAlign="center" BackColor="#E8EBFD" ForeColor="#3D3DB6" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Bold="true" Font-Size="smaller" />
<PagerStyle BackColor="white" Font-Name="Verdana, Arial, Helvetica, sans-serif" Font-Size="smaller" />
<Columns>
<asp:EditCommandColumn
ButtonType="PushButton"
CancelText="Cancel"
EditText="Edit"
HeaderText="Edit"
UpdateText="Update"
Visible="True"/>
<asp:BoundColumn DataField="PartID"
HeaderText="PartID"
ReadOnly="true"
Visible="True"/>
<asp:BoundColumn DataField="Name"
HeaderText="Name"
ReadOnly="false"
Visible="True"/>
<asp:BoundColumn DataField="Description"
HeaderText="Description"
ReadOnly="false"
Visible="True"/>
<asp:BoundColumn DataField="Price"
HeaderText="Price"
ReadOnly="false"
Visible="True"/>
</Columns>
</asp:DataGrid>
</form>
</body>
</html>

Check here:

http://aspalliance.com/146_Editing_a_DataGrid_Control

Buck Woody

Help Urgent

Hi K. Babu

I am using Access as back end and VB 6.0 as front end. In access I have field name reporting date and I have fixed its property as date. Which stores data as MM/DD/YYYY.

I want to fecth reports on the bases of only Months and not on exact dates.

Since, crystal report selection formula data type is string, and my access datatype for the field is date, my problem is when I write my code only on months, the crystal report gives me message "Error in formula".

How should I write my code so that selection formula searches only months instead of comparing entire date field in the database and give me reports?

I will appreciate, if you could guide me ASAP.

RakeshI haven't used the SelectionFormula very much, but here's my thoughts...

If you want all the records for the month of April (for example), can't you just search for the records that are between 04/01/2004 and 04/30/2004? That way you still get the data you want and you're giving the query what it wants (a full date instead of just a month).

Help suppress

I am trying to suppress some details, what I have is 3 columns 1st is order number, 2nd is product, 3rd stock status ie allocated/back ordered. It prints a line per product and the status. What I am trying to do is if the order has one line on back order then I want to suppress the whole order.

Thanks

RichardHi,
Can you post the expected result with some sample data?

Madhivanan|||What version on Crystal are you using? I use 8.5, so you may need to modify the following to work with your version.

You can use a conditional suppress. I will assume that you have each order appearing in the Details section. Go into the Format of the details section. Find where you can check to Suppress that section. You should see a button that looks like 'x-2'. Click the button and enter a formula. The Detail section will be supressed each time the formula evaluates to True.

Example, put this in the Formula box when you click 'x-2':
{StockStatus} = "BackOrdered"

HELP sql server 2005 express connection hangs up

Hi

I got an access 2002 application front end with a sql server 2005 express back end. Some of my clients are having some difficulties. After using the application for a while, some of the users are finding that the system just hangs up. It usually happens after the front end application has been running for about an hour (sometimes sooner and sometimes later). There are perhaps 1 to 5 concurrent users and I have checked to see if there are any firewalls stalling it (I think I check all of them)- Is there any way that SQL Server 2005 express could be caused to just stall- This even occurs with the odd laptop. All the appropriate protocols are enabled as well. These databses are not very large.

ANY HELP WOULD BE GREATLY APPRETIATED!!!

Thanks

Frank Srebot

Moved thread to the SQL Server Express forum.|||

hi Frank,

what do you mean by "just hangs up"? does it completely stalls requiring a reboot, or it's "sleeeping" for just a while and then restarts working "as expected" or the like?

to start, few things to consider..

SQLExpress sets the "autoclose" property of it's created databases to true, and this causes the dbs to be shut down when not in use, meaning that tyey will be closed if no active connection references them.. this involves a little overhead at next re-use as the dbs must be re-open, but I do not think this is your problem... anyway, the eventual related "problem" can be workaround modifying the relative database property via sp_dboption database's system stored procedure call...

"autoshrink" database property is even set to true, and this causes, at engine scheduled time frames, the eventual shrinking of the involved databases, so that when lots of insert/delete operations are performed (actually lots of deletes), the engine wakes up a thread to shrink (when necessary) the databases, requiring some time to execute..

if the autogrowth property of the database's datafiles and logfiles is set to true and the engine states new file space is required, the engine enlarges the files (when needed) and this will obviously involve some time as well...

other non SQL Server related issues includes OS's scheduled tasks requiring lots of CPU and/or I/O..

but it's hard to solve this way

regards

|||

Thanks for the great and quick response.

To clarify, sql server just hangs up meaning that the application displays an hourglass and eventually the sql connection is lost and an error message is given. I was doing some research and I was wondering if the problem could be in the connection pooling configuration- currently the setting are that pool connections are enabled by default in the ODBC config settings- the databases which I am dealing are quite small- would any one have any ideas perhaps along these lines?

Thanks

Frank srebot

|||

Hi

This is an update to my connection Problem with Access 2002 to SQL SERVER EXPRESS 2005.

We are having random disconnects on the client side with Access putting up a "Connection Failure" dialog box even when the user is actively entering records into the system. Have any of you ever encountered this situation? We have disabled all TCP offloading engine technology on the machine thinking this was causing a problem with SQL Server as well as changing network cards to a whole different brand. We've pretty much ruled out the physical network at this point because we have changed cables and moved to another port on a different switch to no avail.

Is there some timeout setting or connection pooling setting that I am unaware of at the SQL Server level that has a problem interacting with Windows Server 2003 or Windows XP? I have checked and double checked all of the server settings between the old machine and the new and they are identical.

I did read that the connection pooling may be stressed and the pool of connections are 'Leaking'. This might be due to a bad cable or connection, but thats all I have found out.

Any info would be greatly appreciated.

Thanks

Frank

help required

i have created registration form which consist of 6 webform, for each user i had given option save and come back later (say on webform3), when userlogin for the second time without complete registration i.e, on the 6th webform i had given save option then only it enters into database. the problem is when user login in for the second time he should be redirected to same page(webform3)

so i need help from urside

I beleive you are saving this information in database table. i don't now what table structure you are using in your application. but i think you are saving that information in user table then just create a web user control and place it on the top of the each page. that user control will check with database that on which page access last time and redirect the request by using response.redirect/server.transfer.

|||

This tutorial video (one of the many excellent tutorials available at www.asp.net) will demonstrate this for you.

http://asp.net/learn/videos/view.aspx?tabid=63&id=47