Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
benking9987
Posting Yak Master
124 Posts |
 Posted - 2009-10-22 : 10:37:28
|
| I have SQL Server 2005 that I interact with using MS Access on the front end for linked tables and queries. I am getting the following error this morning:"ODBC--insert on a linked table 'XZ_Transactions' failed.[Microsoft][ODBC SQL Server Driver][SQL Server]The log for database 'KNSInventoryDB' is not available. Check the event log for related error messages. Resolve any errors and restart the database."We can view all data intact and just fine currently. We just cannot add records or modify records in the database. INSERT and UPDATE SQL actions are not working properly.Yesterday our network moved our sql server from one server to another, but everything was working fine on the new server until later in the evening.Does anyone have any ideas how to work with this? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-10-22 : 11:50:45
|
| Check the SQL Server error log. Look for messages relating to this database. Post the full error messages here.Check the drive that the SQL transaction log is on (the .ldf file) make sure the drive is available.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
#9001 Log file error