|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 725
|
I am having a SQL problem, not really your problem but I cannot seem to be able to solve it and hope that you can shed some light on the problem.....
I have an application created in VB Express attached to a Database in SQL Express. The application seems to work just fine, until I try to go into SSMS to do anything...including backup. I get error messages that says that the log file does not match the primary database. If I look at the log files, I see two.... If I delete those files BEFORE going into SSMS then everything is fine. If I go to SSMS first, I can see the database but I cannot access it...... If I take it off-line and then bring it back I can access it again. Anytime I go into SSMS and touch the database, I have to reboot the computer before the VBE application can connect to the database.
Without deleteing the log files (on fresh boot) if I run your backup program I get the following error log:
DETAILED LOG:
7/26/2011 8:31:34 AM Creating backup of 1080Library to C:\WINDOWS\TEMP
7/26/2011 8:31:34 AM ERROR: Backup of 1080Library failed: Database '1080Library' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
BACKUP DATABASE is terminating abnormally.
7/26/2011 8:31:34 AM Cleaning C:\Documents and Settings\Joe Ogburn\Desktop\programming\database stuff
7/26/2011 8:31:34 AM ERROR: Job finished (With Errors)
I deleted the log files, went into SSMS, took the database offline, brought online, rebooted the computer, ran your program and everything worked wonderfully.....
Obviously this IS NOT YOUR PROBLEM......there is something I am doing wrong somewhere but after days on the Microsoft boards I have no solutions....... And yes, I am very new to SQL databases..... and the programming thereof.....
I would appreciate any insight you might have,
Thanks,
Joe Ogburn
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
Joe, try stackoverflow.com. We don't have resources to help with generic MSSQL problems, sorry.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 725
|
Thanks for the quick relpy. As I said, it is not your problem.
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 725
|
Ruslan,
Here is the answer to my problem.....
The problem is making changes using VBE Designer. If you make any changes to the database structure using VBE designer it generates a second logfile with a _1 appended to it. As long as both logfiles exist, back up is not possible either through your program OR SSMS..... Easy solution, delete the BOTH logfiles and everything will work fine unless you go back into designer and make a database structure change..... which then makes the second logfile and the problem returns.........
Just thought I would pass it along, it might help somebody else.....
Thanks.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
Joe,
I appreciate you sharing the solution - glad it is resolved
|
|
|
|
|
