Raster Catalog: mdf

Showing posts with label mdf. Show all posts

Monday, March 26, 2012

Read Only MDF LDF files

I have a couple of SQL database files, MDF and LDF, that were distributed on
CD media (they came w/ a Microsoft Press book).
I can attach the database, but it is read only. However, if I try to set
the DB to not read-only, I get an error:
Error 5105: Device activation error. They physical file name "C:\program
files\microsoft sql server\MSSQL$MYINSTANCE01\Data\Contacts.MDF" may be
incorrect.
Could not restart database "contactsdb". Reverting to old status.
ALTER DATABASE statement failed
sp_dboption command failed.
If I set the files to NOT read-only (they were read only since they were
copied from a CD), the DB gets marked suspect and/or I get the error 9003:
The LSN (12:32:1) passed to log scan in statbase "contacts" is invalid.
How am I supposed to attach this dataabase in a write-enabled mode?
--
Thanks,
Martin SchmidIt sounds like the files might be bad, and I don't think just marking them
readable in the file system would do that. You could try just copying the
MDF file to the local directory (leaving the LDF on the CD), changing the
file's readonly attribute, and then try attaching the mdf only (maybe with
sp_attach_single_file_db. It might be able to build a new log for you.
Good Luck
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Martin Schmid" <martinschmid@.sbcglobal.net.nospam> wrote in message
news:eA32Y5AeDHA.2304@.TK2MSFTNGP11.phx.gbl...
> I have a couple of SQL database files, MDF and LDF, that were distributed
on
> CD media (they came w/ a Microsoft Press book).
> I can attach the database, but it is read only. However, if I try to set
> the DB to not read-only, I get an error:
> Error 5105: Device activation error. They physical file name "C:\program
> files\microsoft sql server\MSSQL$MYINSTANCE01\Data\Contacts.MDF" may be
> incorrect.
> Could not restart database "contactsdb". Reverting to old status.
> ALTER DATABASE statement failed
> sp_dboption command failed.
> If I set the files to NOT read-only (they were read only since they were
> copied from a CD), the DB gets marked suspect and/or I get the error 9003:
> The LSN (12:32:1) passed to log scan in statbase "contacts" is invalid.
> How am I supposed to attach this dataabase in a write-enabled mode?
> --
> Thanks,
> Martin Schmid
>|||I DON'T want the DB read only... the file is marked read only because it was
copied from READ ONLY media.
--
Thanks,
Martin Schmid, EIT, CCSA, MCDBA, MCSE
"Jens Süßmeyer" <jsuessmeyer@.[REJECT_SPAM]web.de> wrote in message
news:euGR0OCeDHA.2436@.TK2MSFTNGP11.phx.gbl...
> Hi Martin !
> Even you want the database to be read-only. you cannot achieve it by
setting
> the attribute to read-only, because during normal database checkpoints are
> written to the LOG-Files and the database. What you can do is to copy the
DB
> set the attribute to writeable and set the database (logically) to
readonly,
> so that only records can be read.
> HTH, Jens Süßmeyer.
>
> "Martin Schmid" <martinschmid@.sbcglobal.net.nospam> schrieb im Newsbeitrag
> news:eA32Y5AeDHA.2304@.TK2MSFTNGP11.phx.gbl...
> > I have a couple of SQL database files, MDF and LDF, that were
distributed
> on
> > CD media (they came w/ a Microsoft Press book).
> >
> > I can attach the database, but it is read only. However, if I try to
set
> > the DB to not read-only, I get an error:
> > Error 5105: Device activation error. They physical file name
"C:\program
> > files\microsoft sql server\MSSQL$MYINSTANCE01\Data\Contacts.MDF" may be
> > incorrect.
> > Could not restart database "contactsdb". Reverting to old status.
> > ALTER DATABASE statement failed
> > sp_dboption command failed.
> >
> > If I set the files to NOT read-only (they were read only since they were
> > copied from a CD), the DB gets marked suspect and/or I get the error
9003:
> > The LSN (12:32:1) passed to log scan in statbase "contacts" is invalid.
> >
> > How am I supposed to attach this dataabase in a write-enabled mode?
> >
> > --
> > Thanks,
> > Martin Schmid
> >
> >
>|||Perfect! Thanks.
--
Thanks,
Martin Schmid, EIT, CCSA, MCDBA, MCSE
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:OgkrngBeDHA.1828@.TK2MSFTNGP10.phx.gbl...
> It sounds like the files might be bad, and I don't think just marking them
> readable in the file system would do that. You could try just copying the
> MDF file to the local directory (leaving the LDF on the CD), changing the
> file's readonly attribute, and then try attaching the mdf only (maybe with
> sp_attach_single_file_db. It might be able to build a new log for you.
> Good Luck
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Martin Schmid" <martinschmid@.sbcglobal.net.nospam> wrote in message
> news:eA32Y5AeDHA.2304@.TK2MSFTNGP11.phx.gbl...
> > I have a couple of SQL database files, MDF and LDF, that were
distributed
> on
> > CD media (they came w/ a Microsoft Press book).
> >
> > I can attach the database, but it is read only. However, if I try to
set
> > the DB to not read-only, I get an error:
> > Error 5105: Device activation error. They physical file name
"C:\program
> > files\microsoft sql server\MSSQL$MYINSTANCE01\Data\Contacts.MDF" may be
> > incorrect.
> > Could not restart database "contactsdb". Reverting to old status.
> > ALTER DATABASE statement failed
> > sp_dboption command failed.
> >
> > If I set the files to NOT read-only (they were read only since they were
> > copied from a CD), the DB gets marked suspect and/or I get the error
9003:
> > The LSN (12:32:1) passed to log scan in statbase "contacts" is invalid.
> >
> > How am I supposed to attach this dataabase in a write-enabled mode?
> >
> > --
> > Thanks,
> > Martin Schmid
> >
> >
>

Friday, March 23, 2012

Read MDF

is there any way of opening an MDf file into some sort of
readable format? we had our server crash on us and the
backup/ restore is not working. I only have the mdf file
for the database and was wondering if i could get this
into some sort of formatting i could open and manually add
our old database back in as it only had a few details in.
thanks
simonHi
No. Have you tried sp_attach_single_file_db?
Failing that, phone MS PSS.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Simon" <simon@.talktalk.net> wrote in message
news:13d001c515ac$a8337530$a401280a@.phx.gbl...
> is there any way of opening an MDf file into some sort of
> readable format? we had our server crash on us and the
> backup/ restore is not working. I only have the mdf file
> for the database and was wondering if i could get this
> into some sort of formatting i could open and manually add
> our old database back in as it only had a few details in.
> thanks
> simon|||thanks mike, i have tried sp_attach_single_file_db but
without joy.
we have had to reinstall the OS and SQL and this was the
only file we had a good copy of.
i will try Ms PSS thanks.
>--Original Message--
>Hi
>No. Have you tried sp_attach_single_file_db?
>Failing that, phone MS PSS.
>Regards
>--
>Mike Epprecht, Microsoft SQL Server MVP
>Zurich, Switzerland
>IM: mike@.epprecht.net
>MVP Program: http://www.microsoft.com/mvp
>Blog: http://www.msmvps.com/epprecht/
>"Simon" <simon@.talktalk.net> wrote in message
>news:13d001c515ac$a8337530$a401280a@.phx.gbl...
>> is there any way of opening an MDf file into some sort
of
>> readable format? we had our server crash on us and the
>> backup/ restore is not working. I only have the mdf file
>> for the database and was wondering if i could get this
>> into some sort of formatting i could open and manually
add
>> our old database back in as it only had a few details
in.
>> thanks
>> simon
>
>.
>|||Just out of curiosity, what problem do you encounter when you try to
re-attach the MDF? The following article explains other issues related to
restoring a DB on another server install:
http://support.microsoft.com/kb/314546#10
<anonymous@.discussions.microsoft.com> wrote in message
news:13f201c515b2$0691fd40$a401280a@.phx.gbl...
> thanks mike, i have tried sp_attach_single_file_db but
> without joy.
> we have had to reinstall the OS and SQL and this was the
> only file we had a good copy of.
> i will try Ms PSS thanks.
> >--Original Message--
> >Hi
> >
> >No. Have you tried sp_attach_single_file_db?
> >Failing that, phone MS PSS.
> >
> >Regards
> >--
> >Mike Epprecht, Microsoft SQL Server MVP
> >Zurich, Switzerland
> >
> >IM: mike@.epprecht.net
> >
> >MVP Program: http://www.microsoft.com/mvp
> >
> >Blog: http://www.msmvps.com/epprecht/
> >
> >"Simon" <simon@.talktalk.net> wrote in message
> >news:13d001c515ac$a8337530$a401280a@.phx.gbl...
> >> is there any way of opening an MDf file into some sort
> of
> >> readable format? we had our server crash on us and the
> >> backup/ restore is not working. I only have the mdf file
> >> for the database and was wondering if i could get this
> >> into some sort of formatting i could open and manually
> add
> >> our old database back in as it only had a few details
> in.
> >>
> >> thanks
> >>
> >> simon
> >
> >
> >.
> >|||Hi Johnny
An sp_attach_single_file_db is only guarenteed to work is
an sp_detach_db is used, otherwise its a bit of a lottery
whether it works or not.
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/tsqlref/ts_sp_ae-az_4wrm.asp
Peter
"I may be drunk, Miss, but in the morning I will be sober
and you will still be ugly."
Winston Churchill
>--Original Message--
>Just out of curiosity, what problem do you encounter when
you try to
>re-attach the MDF? The following article explains other
issues related to
>restoring a DB on another server install:
>http://support.microsoft.com/kb/314546#10
><anonymous@.discussions.microsoft.com> wrote in message
>news:13f201c515b2$0691fd40$a401280a@.phx.gbl...
>> thanks mike, i have tried sp_attach_single_file_db but
>> without joy.
>> we have had to reinstall the OS and SQL and this was the
>> only file we had a good copy of.
>> i will try Ms PSS thanks.
>> >--Original Message--
>> >Hi
>> >
>> >No. Have you tried sp_attach_single_file_db?
>> >Failing that, phone MS PSS.
>> >
>> >Regards
>> >--
>> >Mike Epprecht, Microsoft SQL Server MVP
>> >Zurich, Switzerland
>> >
>> >IM: mike@.epprecht.net
>> >
>> >MVP Program: http://www.microsoft.com/mvp
>> >
>> >Blog: http://www.msmvps.com/epprecht/
>> >
>> >"Simon" <simon@.talktalk.net> wrote in message
>> >news:13d001c515ac$a8337530$a401280a@.phx.gbl...
>> >> is there any way of opening an MDf file into some
sort
>> of
>> >> readable format? we had our server crash on us and
the
>> >> backup/ restore is not working. I only have the mdf
file
>> >> for the database and was wondering if i could get
this
>> >> into some sort of formatting i could open and
manually
>> add
>> >> our old database back in as it only had a few details
>> in.
>> >>
>> >> thanks
>> >>
>> >> simon
>> >
>> >
>> >.
>> >
>
>.
>

Read MDF

Wednesday, March 21, 2012

read *.mdf files

Hello,
I am new for MSDE.
Our ISA2004 server has report in *.mdf and *.ldf format.
We don't have SQL server. I installed MSDE on my workstation.
Is there any step-by-step instruction to show me, how to create Access
Project to view the ISA2004 report?
ThanksHi
Your mdf and ldf files are (probably) not a report but data and log files
for a SQL Server database. You can attach these to your MSDE instance with
the system stored procedure sp_attach_db see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp.
To call this stored procedure you will need to use the osql utility at a
command prompt see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_osql_1wxl.asp.
All this information is downloadable in Books Online which will allow you to
read and search for information at
http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en
This may help you get started with using Access as the from end for MSDE
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_msdeintro.asp.
There are also dedicated newsgroups for access (microsoft.public.access) and
MSDE (microsoft.public.sqlserver.msde), there are also other language
specific groups which you can search/browse at
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
John
"Newbie" wrote:
> Hello,
> I am new for MSDE.
> Our ISA2004 server has report in *.mdf and *.ldf format.
> We don't have SQL server. I installed MSDE on my workstation.
> Is there any step-by-step instruction to show me, how to create Access
> Project to view the ISA2004 report?
> Thanks
>|||Thanks
"John Bell" wrote:
> Hi
> Your mdf and ldf files are (probably) not a report but data and log files
> for a SQL Server database. You can attach these to your MSDE instance with
> the system stored procedure sp_attach_db see
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp.
> To call this stored procedure you will need to use the osql utility at a
> command prompt see
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_osql_1wxl.asp.
> All this information is downloadable in Books Online which will allow you to
> read and search for information at
> http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en
> This may help you get started with using Access as the from end for MSDE
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_msdeintro.asp.
> There are also dedicated newsgroups for access (microsoft.public.access) and
> MSDE (microsoft.public.sqlserver.msde), there are also other language
> specific groups which you can search/browse at
> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
> John
> "Newbie" wrote:
> > Hello,
> >
> > I am new for MSDE.
> >
> > Our ISA2004 server has report in *.mdf and *.ldf format.
> > We don't have SQL server. I installed MSDE on my workstation.
> >
> > Is there any step-by-step instruction to show me, how to create Access
> > Project to view the ISA2004 report?
> >
> > Thanks
> >
> >|||Hello John,
May I ask one more question?
1. I installed MSDE 2000 on ISA 2004 server.
2. I use Access 2003 to create a progect named ISA2004.adp connect to
ISA2004SQL. The connection test is OK. (I have 2 tables, FireWall and
WebProxy)
3. I use ODBC to create a DSN named ISA2004, ISA2004 use ISA2004SQL w/SQL
server driver. ('with Windows NT authentication using the network login ID'
checked)
4. I connect ISA 2004 server to this ODBC, then I got the error message.
The ISA Server Web filter was unable to open ODBC Data Source ISA2004,
Table: WebProxy, under User Name []. The ODBC Error description is:
[State=IM002][Error=0][Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified .
or with administrator login
The Microsoft Firewall was unable to open ODBC Data Source Isa2004, Table:
FireWall, under User Name [Server\Administrator]. The ODBC Error description
is: [State=IM002][Error=0][Microsoft][ODBC Driver Manager] Data source name
not found and no default driver specified .
Thanks
"John Bell" wrote:
> Hi
> Your mdf and ldf files are (probably) not a report but data and log files
> for a SQL Server database. You can attach these to your MSDE instance with
> the system stored procedure sp_attach_db see
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp.
> To call this stored procedure you will need to use the osql utility at a
> command prompt see
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_osql_1wxl.asp.
> All this information is downloadable in Books Online which will allow you to
> read and search for information at
> http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en
> This may help you get started with using Access as the from end for MSDE
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_msdeintro.asp.
> There are also dedicated newsgroups for access (microsoft.public.access) and
> MSDE (microsoft.public.sqlserver.msde), there are also other language
> specific groups which you can search/browse at
> http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
> John
> "Newbie" wrote:
> > Hello,
> >
> > I am new for MSDE.
> >
> > Our ISA2004 server has report in *.mdf and *.ldf format.
> > We don't have SQL server. I installed MSDE on my workstation.
> >
> > Is there any step-by-step instruction to show me, how to create Access
> > Project to view the ISA2004 report?
> >
> > Thanks
> >
> >|||Hi
From a command prompt can you use osql to connect to the instance and then
do select name from masters..sysdatabases
GO
If the name of your database does not appear then you will need to use
sp_attach_db as described in the previous links.
John
"Newbie" wrote:
> Hello John,
> May I ask one more question?
> 1. I installed MSDE 2000 on ISA 2004 server.
> 2. I use Access 2003 to create a progect named ISA2004.adp connect to
> ISA2004SQL. The connection test is OK. (I have 2 tables, FireWall and
> WebProxy)
> 3. I use ODBC to create a DSN named ISA2004, ISA2004 use ISA2004SQL w/SQL
> server driver. ('with Windows NT authentication using the network login ID'
> checked)
> 4. I connect ISA 2004 server to this ODBC, then I got the error message.
> The ISA Server Web filter was unable to open ODBC Data Source ISA2004,
> Table: WebProxy, under User Name []. The ODBC Error description is:
> [State=IM002][Error=0][Microsoft][ODBC Driver Manager] Data source name not
> found and no default driver specified .
> or with administrator login
> The Microsoft Firewall was unable to open ODBC Data Source Isa2004, Table:
> FireWall, under User Name [Server\Administrator]. The ODBC Error description
> is: [State=IM002][Error=0][Microsoft][ODBC Driver Manager] Data source name
> not found and no default driver specified .
> Thanks
>
> "John Bell" wrote:
> > Hi
> >
> > Your mdf and ldf files are (probably) not a report but data and log files
> > for a SQL Server database. You can attach these to your MSDE instance with
> > the system stored procedure sp_attach_db see
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp.
> > To call this stored procedure you will need to use the osql utility at a
> > command prompt see
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/coprompt/cp_osql_1wxl.asp.
> > All this information is downloadable in Books Online which will allow you to
> > read and search for information at
> > http://www.microsoft.com/downloads/details.aspx?familyid=a6f79cb1-a420-445f-8a4b-bd77a7da194b&displaylang=en
> >
> > This may help you get started with using Access as the from end for MSDE
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_msdeintro.asp.
> > There are also dedicated newsgroups for access (microsoft.public.access) and
> > MSDE (microsoft.public.sqlserver.msde), there are also other language
> > specific groups which you can search/browse at
> > http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
> >
> > John
> >
> > "Newbie" wrote:
> >
> > > Hello,
> > >
> > > I am new for MSDE.
> > >
> > > Our ISA2004 server has report in *.mdf and *.ldf format.
> > > We don't have SQL server. I installed MSDE on my workstation.
> > >
> > > Is there any step-by-step instruction to show me, how to create Access
> > > Project to view the ISA2004 report?
> > >
> > > Thanks
> > >
> > >

Monday, March 26, 2012

Read Only MDF LDF files

Friday, March 23, 2012

Read MDF

Read MDF

Read MDF

Wednesday, March 21, 2012

read *.mdf files

read *.mdf files

Raster Catalog

Blog Archive

About Me