<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
Administering
»
Change Database Status from Shutdown to...
25 posts, Page 2 of 3
««
1
2
3
»»
Change Database Status from Shutdown to Normal
Rate Topic
Display Mode
Topic Options
Author
Message
Elliott Whitlow
Elliott Whitlow
Posted Wednesday, October 19, 2011 1:57 PM
SSCertifiable
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854,
Visits: 4,873
I'd probably go with a detach/re-attach, then you could specify all the file locations. Gail? Your thoughts?
CEWII
Post #1193201
GilaMonster
GilaMonster
Posted Wednesday, October 19, 2011 2:15 PM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 2:45 PM
Points: 37,718,
Visits: 29,972
No. Never ever detach a suspect or recovery_pending database as it will not always reattach (suspect will never reattach)
Are you absolutely sure that file is there? Exact path, exact name.
Was there a drive problem that the drive came online later than SQL? If so, try restarting SQL Server.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1193216
R_S
R_S
Posted Wednesday, October 19, 2011 2:50 PM
SSC Journeyman
Group: General Forum Members
Last Login: Wednesday, February 20, 2013 10:17 AM
Points: 84,
Visits: 409
Is the file there in the location showing in the error logs.
Try to detach and reattach providing the new path.
Post #1193243
Lynn Pettis
Lynn Pettis
Posted Wednesday, October 19, 2011 3:09 PM
SSC-Insane
Group: General Forum Members
Last Login: Today @ 2:49 PM
Points: 21,612,
Visits: 27,443
R_S (10/19/2011)
Is the file there in the location showing in the error logs.
Try to detach and reattach providing the new path.
Read Gail's post just above.
Lynn Pettis
For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here
or
when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here
and
here
Managing Transaction Logs
SQL Musings from the Desert
Fountain Valley SQL
(My Mirror Blog)
Post #1193254
EjSQLme
EjSQLme
Posted Friday, October 21, 2011 8:16 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Friday, May 04, 2012 9:00 PM
Points: 102,
Visits: 431
Yes, I'm sure that the file is there b/c I checked it to make sure it is there when I saw the error message that I posted. I believe there was an issue with the server and did crash, but we have other DBs on the same SQL Server, and this is the only DB with this issue.
Post #1194417
GilaMonster
GilaMonster
Posted Friday, October 21, 2011 8:20 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 2:45 PM
Points: 37,718,
Visits: 29,972
Try taking the affected DB offline and then online (alter database ... set offline, alter database ... set online)
If that doesn't work, post any errors.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1194422
Elliott Whitlow
Elliott Whitlow
Posted Friday, October 21, 2011 9:29 AM
SSCertifiable
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854,
Visits: 4,873
GilaMonster (10/19/2011)
No. Never ever detach a suspect or recovery_pending database as it will not always reattach (suspect will never reattach)
Are you absolutely sure that file is there? Exact path, exact name.
Was there a drive problem that the drive came online later than SQL? If so, try restarting SQL Server.
I agree it won't always re-attach.. If all the files are there and in the exact same place then a restart probably won't hurt. If the files have moved I don't see much of a choice.. Luckily I don't have to deal with this kind of problem often..
CEWII
Post #1194496
GilaMonster
GilaMonster
Posted Friday, October 21, 2011 9:35 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 2:45 PM
Points: 37,718,
Visits: 29,972
Elliott Whitlow (10/21/2011)
If the files have moved I don't see much of a choice..
Move them back where they should be and offline/online or ALTER DATABASE ... MOVE then offline/online. Or restart SQL instead of the offline/online combo if there's nothing else running on the server.
I would be very, very cautious about detaching a database in anything other than Online state as if it doesn't reattach the situation's just got worse.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1194504
Elliott Whitlow
Elliott Whitlow
Posted Friday, October 21, 2011 10:05 AM
SSCertifiable
Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854,
Visits: 4,873
GilaMonster (10/21/2011)
Elliott Whitlow (10/21/2011)
If the files have moved I don't see much of a choice..
Move them back where they should be and offline/online or ALTER DATABASE ... MOVE then offline/online. Or restart SQL instead of the offline/online combo if there's nothing else running on the server.
I would be very, very cautious about detaching a database in anything other than Online state as if it doesn't reattach the situation's just got worse.
Provided moving them back is possible I would agree. My thought is damaged drive. But I agree with your point.
CEWII
Post #1194532
GilaMonster
GilaMonster
Posted Friday, October 21, 2011 10:25 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 2:45 PM
Points: 37,718,
Visits: 29,972
If the drive is damaged you're probably restoring from backup.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1194545
« Prev Topic
|
Next Topic »
25 posts, Page 2 of 3
««
1
2
3
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
