December 18, 2008 at 5:14 am
Did you read the links that Pradeep provided?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 18, 2008 at 8:47 pm
Pradeep provides Good links but my problem is not solved.......
One Thing:
My .mdf, .log file names are
wowzzytest.mdf, wowzzytest.log files, error occured like
wowzzytest is not online, but when we are executing online querry it shows files are Online.
One thing in past my DBA has done one thing like my data base got a problem with log file.logfile exeding it's limit then my DBA detaches and reatach the files(mdf,log) after that Database problem is occured..... in that time my Data base having Fulltext catalogs.
December 18, 2008 at 9:29 pm
Very strange. Have you tried detaching and attaching here?
December 19, 2008 at 12:02 am
suresh.maddali (12/18/2008)
One thing in past my DBA has done one thing like my data base got a problem with log file.logfile exeding it's limit then my DBA detaches and reatach the files(mdf,log) after that Database problem is occured.
Yeah, that's a good way to really mess a database up. I would suggest that you recommend to the DBA not to delete log files. It's a really fast way of completely messing up a database, sometimes beyond what can be fixed.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2010 at 5:02 am
Even I have a problem with the same scenario. One of the file is not online, how can i make it online. Please help regarding this
Thanks in advance.
March 11, 2010 at 8:38 am
Please post new questions in a new thread please, giving as much detail as possible as to what's wrong.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2010 at 12:05 pm
suresh.maddali (12/18/2008)
Pradeep provides Good links but my problem is not solved.......One Thing:
My .mdf, .log file names are
wowzzytest.mdf, wowzzytest.log files, error occured like
wowzzytest is not online, but when we are executing online querry it shows files are Online.
One thing in past my DBA has done one thing like my data base got a problem with log file.logfile exeding it's limit then my DBA detaches and reatach the files(mdf,log) after that Database problem is occured..... in that time my Data base having Fulltext catalogs.
Is this in production? Did you try to bring database online with alter command?
March 11, 2010 at 12:09 pm
GTR (3/11/2010)
Is this in production? Did you try to bring database online with alter command?
Since the question is almost a year and a half old, I'm guessing it's not longer an issue.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 11, 2010 at 12:15 pm
GilaMonster (3/11/2010)
GTR (3/11/2010)
Is this in production? Did you try to bring database online with alter command?Since the question is almost a year and a half old, I'm guessing it's not longer an issue.
Ahh! Looks like OP replied again on 2\19\10.
March 11, 2010 at 8:29 pm
I come up with another solution like moving all the objects and data in to another data base for the corrupeted one. I have not used old data base.
March 16, 2010 at 11:44 pm
Hi Suresh!
Did you get solution how to make files online??. How did you resolve your problem. can you please explain the way how you did that ??
Thanks,
starterm
Viewing 11 posts - 16 through 25 (of 25 total)
You must be logged in to reply to this topic. Login to reply