Any way to recover schema (thats it) from a mdf file

Ok, with sqlserver 2005, I've noticed my databases being marked as
suspect far more often than sql 2000. Anyway... after futzing around
with it for quite some time... I'd made no progress.
Now I am at the point where the database wasnt cleanly shutdown, and I
dont have a log file.
I am curious if theres anyway to grab schema from the mdf. I am
relatively sure that the mdf file is in fact in tact and not corrupt,
but I dont know where to go from here. sp_attach_single_file_db looks
like it'd work if it was cleanly shutdown.
Thanks in advance
WestonBefore I say anything else: this is worth a call to PSS, especially if this
is critical data. That being said...
You can start the database in EMERGENCY mode, which will start it without
attempting recovery. Given that all of the original data files are in place,
you can expert data out (although you aren't guaranteed as to transactional
consistency).
I would do that and then try the the sp_attach_single_file_db - at least you
can pump out info from the database first.
"Weston Weems" <wweemsNO_SPAM.PLEASE@.gmail.com> wrote in message
news:u2i2ZGdoGHA.4776@.TK2MSFTNGP03.phx.gbl...
> Ok, with sqlserver 2005, I've noticed my databases being marked as suspect
> far more often than sql 2000. Anyway... after futzing around with it for
> quite some time... I'd made no progress.
> Now I am at the point where the database wasnt cleanly shutdown, and I
> dont have a log file.
> I am curious if theres anyway to grab schema from the mdf. I am relatively
> sure that the mdf file is in fact in tact and not corrupt, but I dont know
> where to go from here. sp_attach_single_file_db looks like it'd work if it
> was cleanly shutdown.
>
> Thanks in advance
> Weston|||If you've got the MDF , do a reattach . Are you saying your log file has
disappeared?
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
"Weston Weems" <wweemsNO_SPAM.PLEASE@.gmail.com> wrote in message
news:u2i2ZGdoGHA.4776@.TK2MSFTNGP03.phx.gbl...
> Ok, with sqlserver 2005, I've noticed my databases being marked as
> suspect far more often than sql 2000. Anyway... after futzing around
> with it for quite some time... I'd made no progress.
> Now I am at the point where the database wasnt cleanly shutdown, and I
> dont have a log file.
> I am curious if theres anyway to grab schema from the mdf. I am
> relatively sure that the mdf file is in fact in tact and not corrupt,
> but I dont know where to go from here. sp_attach_single_file_db looks
> like it'd work if it was cleanly shutdown.
>
> Thanks in advance
> Weston|||On Fri, 07 Jul 2006 07:28:20 -0700, Weston Weems wrote:

>Ok, with sqlserver 2005, I've noticed my databases being marked as
>suspect far more often than sql 2000.
Hi Weston,
Having databases marked as suspect should not happen on a regular basis,
unless you're running on wacky hardware or you're doing wacky things.

>Now I am at the point where the database wasnt cleanly shutdown, and I
>dont have a log file.
Any idea what caused yoou to lose the log file? The cause of that might
be related to yoour high frequency of suspect databases.
Hugo Kornelis, SQL Server MVP

Any way to recover schema (thats it) from a mdf file

Ok, with sqlserver 2005, I've noticed my databases being marked as
suspect far more often than sql 2000. Anyway... after futzing around
with it for quite some time... I'd made no progress.
Now I am at the point where the database wasnt cleanly shutdown, and I
dont have a log file.
I am curious if theres anyway to grab schema from the mdf. I am
relatively sure that the mdf file is in fact in tact and not corrupt,
but I dont know where to go from here. sp_attach_single_file_db looks
like it'd work if it was cleanly shutdown.
Thanks in advance
WestonBefore I say anything else: this is worth a call to PSS, especially if this
is critical data. That being said...
You can start the database in EMERGENCY mode, which will start it without
attempting recovery. Given that all of the original data files are in place,
you can expert data out (although you aren't guaranteed as to transactional
consistency).
I would do that and then try the the sp_attach_single_file_db - at least you
can pump out info from the database first.
"Weston Weems" <wweemsNO_SPAM.PLEASE@.gmail.com> wrote in message
news:u2i2ZGdoGHA.4776@.TK2MSFTNGP03.phx.gbl...
> Ok, with sqlserver 2005, I've noticed my databases being marked as suspect
> far more often than sql 2000. Anyway... after futzing around with it for
> quite some time... I'd made no progress.
> Now I am at the point where the database wasnt cleanly shutdown, and I
> dont have a log file.
> I am curious if theres anyway to grab schema from the mdf. I am relatively
> sure that the mdf file is in fact in tact and not corrupt, but I dont know
> where to go from here. sp_attach_single_file_db looks like it'd work if it
> was cleanly shutdown.
>
> Thanks in advance
> Weston|||If you've got the MDF , do a reattach . Are you saying your log file has
disappeared?
--
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
"Weston Weems" <wweemsNO_SPAM.PLEASE@.gmail.com> wrote in message
news:u2i2ZGdoGHA.4776@.TK2MSFTNGP03.phx.gbl...
> Ok, with sqlserver 2005, I've noticed my databases being marked as
> suspect far more often than sql 2000. Anyway... after futzing around
> with it for quite some time... I'd made no progress.
> Now I am at the point where the database wasnt cleanly shutdown, and I
> dont have a log file.
> I am curious if theres anyway to grab schema from the mdf. I am
> relatively sure that the mdf file is in fact in tact and not corrupt,
> but I dont know where to go from here. sp_attach_single_file_db looks
> like it'd work if it was cleanly shutdown.
>
> Thanks in advance
> Weston|||On Fri, 07 Jul 2006 07:28:20 -0700, Weston Weems wrote:
>Ok, with sqlserver 2005, I've noticed my databases being marked as
>suspect far more often than sql 2000.
Hi Weston,
Having databases marked as suspect should not happen on a regular basis,
unless you're running on wacky hardware or you're doing wacky things.
>Now I am at the point where the database wasnt cleanly shutdown, and I
>dont have a log file.
Any idea what caused yoou to lose the log file? The cause of that might
be related to yoour high frequency of suspect databases.
--
Hugo Kornelis, SQL Server MVP

Any idea when the next version of SQL is out ?

I know the executives at MS have promised for a 2 year release moving
forward and if thats true, we should be having one in the coming year. But I
dont see any sight of the same happening. Can someone confirm ? I believe
the code name is Katmai.The code name is Katmai, that is correct. But no dates have been announced.
"Hassan" <Hassan@.hotmail.com> wrote in message
news:eclyo5RKHHA.1424@.TK2MSFTNGP04.phx.gbl...
>I know the executives at MS have promised for a 2 year release moving
>forward and if thats true, we should be having one in the coming year. But
>I dont see any sight of the same happening. Can someone confirm ? I believe
>the code name is Katmai.
>
>|||I never read about a promise per se. I read that it was a goal to have between 2-3 years between
releases.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hassan" <Hassan@.hotmail.com> wrote in message news:eclyo5RKHHA.1424@.TK2MSFTNGP04.phx.gbl...
>I know the executives at MS have promised for a 2 year release moving forward and if thats true, we
>should be having one in the coming year. But I dont see any sight of the same happening. Can
>someone confirm ? I believe the code name is Katmai.
>
>|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:O0wxuHTKHHA.4712@.TK2MSFTNGP04.phx.gbl...
>.
>I never read about a promise per se. I read that it was a goal to have
>between 2-3 years between releases.
It is absurd to put that kind of pressure on this company...I give you
Vista -:)
I am particularly looking forward to your discussions with users concerning
the fascinating interactions (that I forsee in my crystal ball) between the
User Account Control and sql server -:)
Best wishes for the new year,|||> It is absurd to put that kind of pressure on this company...I give you
> Vista -:)
My biggest problem with Vista has little to do with Microsoft: none of the
video card manufacturers have been able to provide an adequate driver that
supports all the features and doesn't blue screen!
My second complaint is a licensing issue, not a quality issue. I bought
Windows Live OneCare for an XP desktop. When I upgraded to Vista, my one
year license became a 3-month license that had now expired, because the
software refuses to run on Vista. They have some beta program for 1.5 but
since the system is already unstable (mostly due to video drivers as
mentioned above) I am not willing to try it.
I know, this is not the forum for these complaints, but you brought it up!
:-)|||Many companies purchase software assurance, specifically to take advantage
of regular upgrades.
Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood
"Steve Dassin" <steve@.nospamrac4sql.net> wrote in message
news:OMt6PiTKHHA.3552@.TK2MSFTNGP03.phx.gbl...
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:O0wxuHTKHHA.4712@.TK2MSFTNGP04.phx.gbl...
>>.
>>I never read about a promise per se. I read that it was a goal to have
>>between 2-3 years between releases.
> It is absurd to put that kind of pressure on this company...I give you
> Vista -:)
> I am particularly looking forward to your discussions with users
> concerning the fascinating interactions (that I forsee in my crystal ball)
> between the User Account Control and sql server -:)
> Best wishes for the new year,
>|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23lroFmTKHHA.5000@.TK2MSFTNGP03.phx.gbl...
>.
> I know, this is not the forum for these complaints, but you brought it up!
> :-)
Yes I did...somebody had to do it :)
IE7 is released as an unfinished product driving users to FF. OneCare is a
joke. They have no business releasing Vista now for many reasons. The mind
boggles at the price to be paid for using this OS with the security model
being a prime example. They are driving people to question their leadership
or lack thereof.
Best wishes for the new year,