Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • Last Modified:

SQL 2005 database attach error

An error occurred while processing the log for database "Team". If possible, restore from backup. If a backup is not available, it may be necessary to rebuild the log. Could not open the new database "Team". CREATE DATABASE aborted.

Unfortunately I do not have a database backup.  What are my options?

Thanks
0
jdr0606
Asked:
jdr0606
1 Solution
 
jogosCommented:
For sollutions see

http://blog.sqlauthority.com/2008/07/21/sql-server-fix-error-9004-an-error-occurred-while-processing-the-log-for-database-if-possible-restore-from-backup-if-a-backup-is-not-available-it-might-be-necessary-to-rebuild-the-log/

And don't forget to take on your 'Unfortunately I do not have a database backup'. And not the copy-the-files kind off that probably is the source off your error.
0
 
arnoldCommented:
What do you mean by attach, did you move the MDB and LDF files from a different system after it crashed?

Only work on copies to make sure if ne thing does not work you have the original with which to try another approach.
http://blog.sqlauthority.com/2010/04/26/sql-server-attach-mdf-file-without-ldf-file-in-database/
0
 
jdr0606Author Commented:
When I run the following commands as instructed in the above link I get these errors.

Where am I using the wrong syntax?

DBCC CHECKDB 'team' REPAIR_ALLOW_DATA_LOSS
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'teamview'.

DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'REPAIR_ALLOW_DATA_LOSS'.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
arnoldCommented:
What is the status of the database, does it attach and comes in as read-only?
0
 
jdr0606Author Commented:
It is currently in emergency mode
0
 
arnoldCommented:
0
 
Eugene ZCommented:
it is:

DBCC checkdb ('team', repair_allow_data_loss);
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now