?
Solved

big problem microsoft sql server 8.00.382

Posted on 2003-03-28
19
Medium Priority
?
369 Views
Last Modified: 2007-12-19
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
Comment
Question by:evrlght
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 3
  • 2
  • +5
19 Comments
 
LVL 23

Expert Comment

by:adathelad
ID: 8225195
0
 
LVL 13

Expert Comment

by:ispaleny
ID: 8225196
Did you try sp_attach_single_file_db ?
0
 

Author Comment

by:evrlght
ID: 8225222
how do you use those sp_attach_single_file_db commands?
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

Author Comment

by:evrlght
ID: 8225242
how do you use those sp_attach_single_file_db commands?
0
 

Author Comment

by:evrlght
ID: 8225267
I get the error 9003 the LSN (...) passed to log.....

I cant restore it... and deleting the log doesnt help either
0
 
LVL 23

Expert Comment

by:adathelad
ID: 8225308
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
 

Author Comment

by:evrlght
ID: 8225873
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
 
LVL 23

Expert Comment

by:adathelad
ID: 8225918
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
 

Author Comment

by:evrlght
ID: 8226273
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
 
LVL 34

Expert Comment

by:arbert
ID: 8226551
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
 
LVL 7

Expert Comment

by:mnye
ID: 8226572
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
 

Author Comment

by:evrlght
ID: 8226637
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
 
LVL 7

Expert Comment

by:mnye
ID: 8226653
stop and restart you SQL Services
0
 
LVL 43

Expert Comment

by:Eugene Z
ID: 8228152
If you have the db backup.
Delete the 'loading DB'
And restore like new one + see arbert post
0
 

Author Comment

by:evrlght
ID: 8234731
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
 
LVL 34

Expert Comment

by:arbert
ID: 8724255
You should award points or request this question be closed....
0
 

Expert Comment

by:CleanupPing
ID: 9275465
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
 

Accepted Solution

by:
modulo earned 0 total points
ID: 11469384
PAQed, with points refunded (125)

modulo
Community Support Moderator
0

Featured Post

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question