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 |
|
bobk544
Starting Member
6 Posts |
 Posted - 2007-11-03 : 10:24:03
|
| Hello, i've installed DotNetNuke on my PC and used Visual Studio 2005 to create an SQL Server 2005 database using the "add new element" feature in the Solution Explorer, which works fine, but sometime when i log back in and bring up the DNN web page i will get some kind of database error, ie below:The log scan number (49:361:1) passed to log scan in database 'C:\DOCUMENTS AND SETTINGS\BOB\LOCAL SETTINGS\TEMP\VWDWEBCACHE\IBM-E24B88DE7DD_DOTNETNUKE\APP_DATA\DATABASE.MDF' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup. Could not open new database 'C:\DOCUMENTS AND SETTINGS\BOB\LOCAL SETTINGS\TEMP\VWDWEBCACHE\IBM-E24B88DE7DD_DOTNETNUKE\APP_DATA\DATABASE.MDF'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 9003)Can you please tell me if there is a way i can sync up the (.ldf) file with the (.mdf) file somehow as this error will sometimes happen when i havn't made any changes to the database, or at least i think DNN hasn't, maybe it does but it's not obvious.Thanks very much for any suggestions or references!BobK |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-11-03 : 12:34:36
|
| From http://forums.asp.net/t/1173689.aspx"The error message indicates that either the database file you are trying to attached has already been attached in sql express or there is data corruption in your database file(.mdf file) , thus the db file could not be attached. I would suggest you connect to your sql express server through management studio to make a verification (Note here that since Sql Express use customer instance, in management studio, you must login using the same account as the one you used in your application). If that db file has been attached, detach it and take another try. If there is no such file attached already in your sql express, I would suggest you first attach that mdf file to your database. If you still get this error, it means that the mdf file is data corrupted (information in ldf file and mdf file does not match) and cannot be used anymore---You need to restore it then." |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-03 : 20:19:11
|
| Why put db files under personal profile? |
|
|
|
bobk544
Starting Member
6 Posts |
Posted - 2007-11-03 : 20:47:40
|
| thanks all will give it a try!BobK |
|
|
|
mahdishad
Starting Member
1 Post |
Posted - 2010-10-01 : 05:59:58
|
| Hi .i have same problem like bobk544 with sqlserverExpress and sqlserver get me that error.i tryed your guide but i get again that error.please help me. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-10-01 : 06:48:17
|
| Please rather post new questions in a new thread and give as much info as you can. Thanks--Gail ShawSQL Server MVP |
|
|
|
|
|
|
|
|
log file (.ldf) does not match the data file (.mdf