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 |
|
matthisco
Starting Member
48 Posts |
 Posted - 2009-02-02 : 08:46:45
|
| Hi Folks, I've just started using SQL 2005 studio express.Since I've started populating a table I can't seem to modify it. I keep getting the error:Table 'xxx' could not be loaded. The log for database is not available. Check the event log for related error message. Resolve the error and restart the Db.I can't find the logs either, can anyone please help?Thankyou |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-02 : 08:49:05
|
| how were you trying to modify table? with t-sql query or from designer? |
 |
|
|
matthisco
Starting Member
48 Posts |
Posted - 2009-02-02 : 08:52:12
|
| From the designer, right clicking on the table and choosing modify. I've done this loads in the past up until now. |
|
|
|
matthisco
Starting Member
48 Posts |
Posted - 2009-02-02 : 08:57:22
|
| This seems to be happening with all of my databases. |
|
|
|
matthisco
Starting Member
48 Posts |
Posted - 2009-02-02 : 11:58:09
|
| Bumping for answers |
|
|
|
revdnrdy
Posting Yak Master
220 Posts |
Posted - 2009-02-02 : 12:27:11
|
quote:
Hi Folks,I've just started using SQL 2005 studio express.Since I've started populating a table I can't seem to modify it.I keep getting the error:Table 'xxx' could not be loaded. The log for database is not available. Check the event log for related error message. Resolve the error and restart the Db.I can't find the logs either, can anyone please help?
It sounds to me like perhaps you (or someone) deleted the log files?Is this the case? I do not think your database will load without the log files.r&r |
|
|
|
matthisco
Starting Member
48 Posts |
Posted - 2009-02-02 : 12:35:43
|
| Thanks again for your replyIt works fine and I can open the tables, I just can't seem to edit the tables in designer view. |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2009-02-02 : 12:36:23
|
| To add to what revdnrdy said, check if the log file is present. To do this, right click on the database in the object explorer, select properties, then files. That will tell you where the data file and log file are located. Then, use windows explorer to see if those files are actually present in those directories. If they are present, check to see if the disk is full, or if there are some other system errors. Windows event viewer (start->run, eventvwr) would be a good place to look for system errors. |
|
|
|
|
|
|
|
|
Table could not be loaded