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 |
|
gigi69
Starting Member
2 Posts |
 Posted - 2006-08-01 : 12:38:13
|
| i need to attach my db, but i receive this error:an error occurred while processing the log for database 'xyj'.Could not open database 'xyj' . Create database is aborted. (Microsoft Sql Server,error 9004).Can you help me? |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-08-01 : 17:31:54
|
| Are you on SQL 2000 or 2005? Do you have any backups of the database?Paul RandalLead Program Manager, Microsoft SQL Server Storage Engine + SQL Express(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
 |
|
|
gigi69
Starting Member
2 Posts |
Posted - 2006-08-02 : 00:43:32
|
| The db was created with sql 2000, but i make an upgrade to sql 2005.I have a backup...one month ago...thank you for your interesting...gigi |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2006-08-02 : 10:21:00
|
| You have two choices:1) restore from the month old backup2) use a trick to enable attaching the database, but then you'll need to run emergency mode repair, which will result in data loss and transactional inconsistencies.If you can cope with the loss of work, I'd go with using the backup.Paul RandalLead Program Manager, Microsoft SQL Server Storage Engine + SQL Express(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
|
|
|
error 9004