• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 377
  • Last Modified:

big problem microsoft sql server 8.00.382

okay i have a big problem...

We have a database.. mssql server says that the database is (loading)...

I can't get to it....

I've detached it...

And want to attach is again but it wont...

any help?/

0
evrlght
Asked:
evrlght
  • 7
  • 3
  • 2
  • +5
1 Solution
 
ispalenyCommented:
Did you try sp_attach_single_file_db ?
0
 
evrlghtAuthor Commented:
how do you use those sp_attach_single_file_db commands?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
evrlghtAuthor Commented:
how do you use those sp_attach_single_file_db commands?
0
 
evrlghtAuthor Commented:
I get the error 9003 the LSN (...) passed to log.....

I cant restore it... and deleting the log doesnt help either
0
 
adatheladCommented:
Using the example of the pubs database, this is the syntax to run from Query Analyser:

EXEC sp_attach_single_file_db @dbname = 'pubs',
   @physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'

0
 
evrlghtAuthor Commented:
Server: Msg 5105, Level 16, State 4, Line 1
Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\business club_Log.LDF' may be incorrect.
Server: Msg 1813, Level 16, State 1, Line 1
Could not open new database 'business'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL\data\business club_Log.LDF' may be incorrect.
0
 
adatheladCommented:
Try looking here....a similar problem was raised a few days ago:

http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20561141.html
0
 
evrlghtAuthor Commented:
Okay I've restored the database from a backup...

and now the database says continualy in the sql server enterprise manager database (loading)


I really need help guys...
0
 
arbertCommented:
When you restore the database, you have to make sure and tell SQL Server to "Leave the database operational.  No additional logs can be restored."  If you don't you will see the loading message...;.

Are you using Enterprise Manager to do the restore?  SQL Analyzer?  Veritas????

Brett
0
 
mnyeCommented:
Since your DB is already offline:

1. Run sp_reset_status
2. Restart SQL Services (if db comes back online BACKUP right away, you've probably got some corruption in your db)

If that doesnt work, run any DBCC with No_checkpoint.  If your dbcc is down, its time to head to the bar.

Last ditch effot, do an update on sysdatabases.status. back up your master, install SQL Server on another computer and DTS to transfer as much of the data out of their as posssible.

Attaching and Detaching will hang your server and when you restart you may not have database if the mdf is corrupt.

hth
late
matt
0
 
evrlghtAuthor Commented:
I'm using the manager to restore...

I'm a newbee with the sql server so...

It just came up one time database (loading) so I quess we had a power failer and this is the result...
0
 
mnyeCommented:
stop and restart you SQL Services
0
 
Eugene ZCommented:
If you have the db backup.
Delete the 'loading DB'
And restore like new one + see arbert post
0
 
evrlghtAuthor Commented:
Guy's I had the have the solve...

I downloaded a shareware data restore program

For those who might need this program ever

MSSQL Recovery
0
 
arbertCommented:
You should award points or request this question be closed....
0
 
CleanupPingCommented:
evrlght:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0
 
moduloCommented:
PAQed, with points refunded (125)

modulo
Community Support Moderator
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 7
  • 3
  • 2
  • +5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now