Go Back   Computer Forums > General Computing > Software and Operating Systems
Click Here to Login
Join Computer forums Today


Reply
 
Thread Tools Search this Thread Display Modes
 
Old 12-10-2017, 07:32 AM   #1
Beta Member
 
LangGuanting's Avatar
 
Join Date: Dec 2017
Location: China
Posts: 1
Default No one of my friends couldn’t help me with database

Today very strange thing has happened with database on SQL Server 2005. I appealed to any kind of help to our tech support guys, but even they said me, that the problem is serious. My database unexpectedly stopped opening via SQL Server.
__________________

__________________
LangGuanting is offline   Reply With Quote
Old 12-10-2017, 07:47 AM   #2
Daemon Poster
 
Join Date: Nov 2014
Location: UK
Posts: 518
Default Re: No one of my friends couldn’t help me with database

Quote:
Originally Posted by LangGuanting View Post
Today very strange thing has happened with database on SQL Server 2005. I appealed to any kind of help to our tech support guys, but even they said me, that the problem is serious. My database unexpectedly stopped opening via SQL Server.
Sounds very serious.
__________________

__________________
pete.i is offline   Reply With Quote
Old 12-10-2017, 09:01 AM   #3
Fully Optimized
 
strollin's Avatar
 
Join Date: Mar 2011
Location: USA
Posts: 2,111
Default Re: No one of my friends couldn’t help me with database

Sounds like your database might have gotten corrupted. Hopefully, you have backups that you can restore so you won't lose too much of your data.

If the data is valuable, you might want to try some recovery software. Here's one I found (I have no personal experience with it). It's not cheap to buy though. http://www.officerecovery.com/mssql/...nformation.htm
__________________
strollin is offline   Reply With Quote
Old 12-10-2017, 11:00 AM   #4
Site Team
 
root's Avatar
 
Join Date: Mar 2004
Posts: 8,057
Default Re: No one of my friends couldn’t help me with database

you need to find out what the error messages are, both in the SQL event logs seen by the SQL agent, and the windows event logs that are relevant.
__________________
I didn’t fight my way to the top of the food chain to be a vegetarian…
Im sick of people saying 'dont waste paper'. If trees wanted to live, they'd all carry guns.
"The inherent vice of capitalism is the unequal sharing of blessings; The inherent vice of socialism is the equal sharing of miseries."
root is offline   Reply With Quote
Old 12-12-2017, 03:21 AM   #5
Beta Member
 
alvarocollazo's Avatar
 
Join Date: Dec 2017
Location: Mexico
Posts: 1
Default Re: No one of my friends couldn’t help me with database

Such method as say my friends is the most reliable, but sometimes you have to recover mdf by more ways that are powerful, see more about it there

https://www.techwalla.com/articles/h...agement-studio
https://www.mssqltips.com/sqlservert...storing-state/
__________________
alvarocollazo is offline   Reply With Quote
Old 01-02-2018, 09:37 PM   #6
Solid State Member
 
Justin_Time's Avatar
 
Join Date: Jan 2018
Location: USA
Posts: 14
Default Re: No one of my friends couldn’t help me with database

Can you tell us exactly specifically what happened? Since you have tech people I'm guessing you have your own server and not a paid service? Thanks
__________________

__________________
Justin_Time is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off



All times are GMT -5. The time now is 08:13 PM.


Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0