Re: Edit botton does not work

Tech-Archive recommends: Speed Up your PC by fixing your registry


Hi Hilary,

In such case, how can we solve this problem to allow SQL start taking inputs
from outside like the web entries ??

Can we tune the database? Can we change the backup directory path?

I looked at the backup directory path and I want to make a new diretcory
path for backup, then my question is how does the database decide which
directory path is choicen for the next backup? (In case I do not remove the
old directory path)




Thank you for all the help,


Frank




"Hilary Cotter" wrote:

1) yes it does, but it would say something like transaction log full. In sql
2000 the message is

Error: 9002, Severity: 17, State: 2
The log file for database 'databasename' is full.
If you are using SQL Server 2005, you receive an error message that is
similar to the following:
Error: 9002, Severity: 17, State: 2
The transaction log for database 'databasename' is full. To find out why
space in the log cannot be reused, see the log_reuse_wait_desc column in
sys.databases

2) this message appears to be unrelated.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Frank" <Frank@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ED54A34E-B1B1-43F0-B31D-83D2AF624010@xxxxxxxxxxxxxxxx

Maybe I can explain in detail, hope you can see what went wrong...

My server, hosts aspx pages that connect to SQL installed on the same
server.
Then, after some of our IT staffs found out the harddrive keeping the SQL
backup and transaction files was almost full, we decided to move the files
to
another location. Then, today, we found out that the bottons on the aspx
pages do not work, meaning the new data we enter into the fields are not
going into SQL.....

My question is:
1) Does SQL have some auto-shut operations that reject any inputs from
outside of the SQL, such as the web data entries???

2) I have two following events recorded, do you think they are the
problems
caused to the web pages not intaking any inputs into SQL????


Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 5/9/2006
Time: 6:38:42 PM
User: N/A
Computer: LASC07
Description:
SQL Server Scheduled Job 'ALL - Update Funai Customer Orders for Tracking
v2' (0x86B9E575A21AC9428245EF7AFE5CD92E) - Status: Failed - Invoked on:
2006-05-09 18:30:02 - Message: The job failed. The Job was invoked by
Schedule 309 (6:30 PM WeekDaily). The last step to run was step 1 (ALL -
Update Funai Customer Orders for Tracking v2 2).

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

-------------------------------------
Event Type: Error
Event Source: SQLSERVERAGENT
Event Category: Alert Engine
Event ID: 318
Date: 5/9/2006
Time: 7:45:16 PM
User: N/A
Computer: LASC07
Description:
Unable to read local eventlog (reason: The parameter is incorrect).

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.






Thanks,


Frank














"Hilary Cotter" wrote:

The transaction log size should not matter, unless you are using
SharePoint
Portal or Team Services and full recover model. In this case you should
back
up the transaction log, although it probably is not the problem here.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Frank" <Frank@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E18C79C6-A073-491A-B30E-2BC190A96D8D@xxxxxxxxxxxxxxxx
Hope someone can answer my question:

On a aspx page, when I click a "Edit" botton and the page does not
fresh,
what would be the causes?


The harddrive that hosts the SQL Transaction Log Back Up is 99% full,
does
it matter to the functioning of the aspx page??


Thanks,

Frank






.

Relevant Pages