Dear Colleagues:
This is such an SQL newbie question its not even funny. To begin with,
please forgive my informality as well as my lack of any specific error
messages, etc.. . I think the questions are academic (the specific error
messages and notes are strewn about my desk at work).
Okay, so here I am, I have a shiny new Windows 2003 Advanced server. So I
want to set up a tiny sharepoint team services site, simple enough. Its the
lightweight version that is
included in the Front Page 2002 CD and pooft, instant sharepoint and badda
bing, you have a small website that small workgroups can use. Please note,
this is not a super confidential eyes only website, so if I had lax MSDE
security, it would not keep me awake at night.
So I download the MSDE from Microsoft and realize that I need to provide a
password for the sa account. A switch after setup.exe.
First, is there a way that I can forego this password, that is to say, that
there is a way for me to install MSDE without a service account password.
I provided the password, the install went great, but now I have issues
associating the sharepoint services site to the MSDE. Obviously, the MSDE
needs to know that sharepoint team services is a good boy.
My problem is that I do not see any configuration options in the small MSDE
engine, so the question here is, other than going to SQL 2000 full blown
where I can tweak things, is how to I tell MSDE that
the team services site, via IIS 6 (running in IIS5 mode) is okay to use it.
Ideally, my goal would be to install MSDE without having to provide a
password, but any advice that could be given would be appreciated.
Thanks,
Roger
If you are trying to "configure" the installation of MSDE you need to get a
copy of the enterprise manager from a SQL 2000 CD or something and you can
then use that to connect to the MSDE database and configure it. MSDE itself
does not come with these tools as it is the "lite" version of SQL, but the
enterprise tools can be used with it to configure it.
Hopefully you have an actual SQL 2000 Server on your network somewhere that
you can use to connect to your MSDE database...
HTH.
"Jolly Student" <jolly@.joy.com> wrote in message
news:ifr1d.8926$G03.2990374@.news4.srv.hcvlny.cv.ne t...
> Dear Colleagues:
> This is such an SQL newbie question its not even funny. To begin with,
> please forgive my informality as well as my lack of any specific error
> messages, etc.. . I think the questions are academic (the specific error
> messages and notes are strewn about my desk at work).
> Okay, so here I am, I have a shiny new Windows 2003 Advanced server. So I
> want to set up a tiny sharepoint team services site, simple enough. Its
the
> lightweight version that is
> included in the Front Page 2002 CD and pooft, instant sharepoint and badda
> bing, you have a small website that small workgroups can use. Please note,
> this is not a super confidential eyes only website, so if I had lax MSDE
> security, it would not keep me awake at night.
> So I download the MSDE from Microsoft and realize that I need to provide a
> password for the sa account. A switch after setup.exe.
> First, is there a way that I can forego this password, that is to say,
that
> there is a way for me to install MSDE without a service account password.
> I provided the password, the install went great, but now I have issues
> associating the sharepoint services site to the MSDE. Obviously, the MSDE
> needs to know that sharepoint team services is a good boy.
> My problem is that I do not see any configuration options in the small
MSDE
> engine, so the question here is, other than going to SQL 2000 full blown
> where I can tweak things, is how to I tell MSDE that
> the team services site, via IIS 6 (running in IIS5 mode) is okay to use
it.
> Ideally, my goal would be to install MSDE without having to provide a
> password, but any advice that could be given would be appreciated.
> Thanks,
> Roger
>
Showing posts with label dear. Show all posts
Showing posts with label dear. Show all posts
Tuesday, March 27, 2012
Basic MSDE Setup Question on Windows Server 2003
Dear Colleagues:
This is such an SQL newbie question its not even funny. To begin with,
please forgive my informality as well as my lack of any specific error
messages, etc.. . I think the questions are academic (the specific error
messages and notes are strewn about my desk at work).
Okay, so here I am, I have a shiny new Windows 2003 Advanced server. So I
want to set up a tiny sharepoint team services site, simple enough. Its the
lightweight version that is
included in the Front Page 2002 CD and pooft, instant sharepoint and badda
bing, you have a small website that small workgroups can use. Please note,
this is not a super confidential eyes only website, so if I had lax MSDE
security, it would not keep me awake at night.
So I download the MSDE from Microsoft and realize that I need to provide a
password for the sa account. A switch after setup.exe.
First, is there a way that I can forego this password, that is to say, that
there is a way for me to install MSDE without a service account password.
I provided the password, the install went great, but now I have issues
associating the sharepoint services site to the MSDE. Obviously, the MSDE
needs to know that sharepoint team services is a good boy.
My problem is that I do not see any configuration options in the small MSDE
engine, so the question here is, other than going to SQL 2000 full blown
where I can tweak things, is how to I tell MSDE that
the team services site, via IIS 6 (running in IIS5 mode) is okay to use it.
Ideally, my goal would be to install MSDE without having to provide a
password, but any advice that could be given would be appreciated.
Thanks,
Roger
To my knowledge, there is no way to install MSDE (or the full blown SQL Server, for that matter), without an sa password. It used to be that you could leave it blank, but that is obviously a security risk and that option has been eliminated.
As for your other question, it sounds like what you need to do is grant database access to the system account that your IIS server is running under. To do this, you can use the osql tool.
Go to a command prompt and type:
osql -U sa -S (local)
Note: If you provided an instance name during your installation, you should use (local)\<instance name>
You will be prompted for the password.
Next type the following 2 lines, replacing <account_name> with the name of the windown account that IIS is running under.
sp_grantlogin '<account_name>'
go
At this point, IIS should be able to connect to your MSDE installation. From there, it's hard to say what you might need to do. Presumably you need a database created within the database server. And after that is created you will need to grant database access to the login you created above. You can do that with something like:
sp_grantdbaccess 'Corporate\JeffL', 'Jeff'
GO
sp_addrolemember 'db_owner', 'Jeff'
GO
If you're not familiar with these types of operations, it might be best to install the full-blown SQL Server so that you can use the GUI interface to perform these operations.|||If you are trying to "configure" the installation of MSDE you need to get a
copy of the enterprise manager from a SQL 2000 CD or something and you can
then use that to connect to the MSDE database and configure it. MSDE itself
does not come with these tools as it is the "lite" version of SQL, but the
enterprise tools can be used with it to configure it.
Hopefully you have an actual SQL 2000 Server on your network somewhere that
you can use to connect to your MSDE database...
HTH.
"Jolly Student" <jolly@.joy.com> wrote in message
news:ifr1d.8926$G03.2990374@.news4.srv.hcvlny.cv.ne t...
> Dear Colleagues:
> This is such an SQL newbie question its not even funny. To begin with,
> please forgive my informality as well as my lack of any specific error
> messages, etc.. . I think the questions are academic (the specific error
> messages and notes are strewn about my desk at work).
> Okay, so here I am, I have a shiny new Windows 2003 Advanced server. So I
> want to set up a tiny sharepoint team services site, simple enough. Its
the
> lightweight version that is
> included in the Front Page 2002 CD and pooft, instant sharepoint and badda
> bing, you have a small website that small workgroups can use. Please note,
> this is not a super confidential eyes only website, so if I had lax MSDE
> security, it would not keep me awake at night.
> So I download the MSDE from Microsoft and realize that I need to provide a
> password for the sa account. A switch after setup.exe.
> First, is there a way that I can forego this password, that is to say,
that
> there is a way for me to install MSDE without a service account password.
> I provided the password, the install went great, but now I have issues
> associating the sharepoint services site to the MSDE. Obviously, the MSDE
> needs to know that sharepoint team services is a good boy.
> My problem is that I do not see any configuration options in the small
MSDE
> engine, so the question here is, other than going to SQL 2000 full blown
> where I can tweak things, is how to I tell MSDE that
> the team services site, via IIS 6 (running in IIS5 mode) is okay to use
it.
> Ideally, my goal would be to install MSDE without having to provide a
> password, but any advice that could be given would be appreciated.
> Thanks,
> Roger
>
This is such an SQL newbie question its not even funny. To begin with,
please forgive my informality as well as my lack of any specific error
messages, etc.. . I think the questions are academic (the specific error
messages and notes are strewn about my desk at work).
Okay, so here I am, I have a shiny new Windows 2003 Advanced server. So I
want to set up a tiny sharepoint team services site, simple enough. Its the
lightweight version that is
included in the Front Page 2002 CD and pooft, instant sharepoint and badda
bing, you have a small website that small workgroups can use. Please note,
this is not a super confidential eyes only website, so if I had lax MSDE
security, it would not keep me awake at night.
So I download the MSDE from Microsoft and realize that I need to provide a
password for the sa account. A switch after setup.exe.
First, is there a way that I can forego this password, that is to say, that
there is a way for me to install MSDE without a service account password.
I provided the password, the install went great, but now I have issues
associating the sharepoint services site to the MSDE. Obviously, the MSDE
needs to know that sharepoint team services is a good boy.
My problem is that I do not see any configuration options in the small MSDE
engine, so the question here is, other than going to SQL 2000 full blown
where I can tweak things, is how to I tell MSDE that
the team services site, via IIS 6 (running in IIS5 mode) is okay to use it.
Ideally, my goal would be to install MSDE without having to provide a
password, but any advice that could be given would be appreciated.
Thanks,
Roger
To my knowledge, there is no way to install MSDE (or the full blown SQL Server, for that matter), without an sa password. It used to be that you could leave it blank, but that is obviously a security risk and that option has been eliminated.
As for your other question, it sounds like what you need to do is grant database access to the system account that your IIS server is running under. To do this, you can use the osql tool.
Go to a command prompt and type:
osql -U sa -S (local)
Note: If you provided an instance name during your installation, you should use (local)\<instance name>
You will be prompted for the password.
Next type the following 2 lines, replacing <account_name> with the name of the windown account that IIS is running under.
sp_grantlogin '<account_name>'
go
At this point, IIS should be able to connect to your MSDE installation. From there, it's hard to say what you might need to do. Presumably you need a database created within the database server. And after that is created you will need to grant database access to the login you created above. You can do that with something like:
sp_grantdbaccess 'Corporate\JeffL', 'Jeff'
GO
sp_addrolemember 'db_owner', 'Jeff'
GO
If you're not familiar with these types of operations, it might be best to install the full-blown SQL Server so that you can use the GUI interface to perform these operations.|||If you are trying to "configure" the installation of MSDE you need to get a
copy of the enterprise manager from a SQL 2000 CD or something and you can
then use that to connect to the MSDE database and configure it. MSDE itself
does not come with these tools as it is the "lite" version of SQL, but the
enterprise tools can be used with it to configure it.
Hopefully you have an actual SQL 2000 Server on your network somewhere that
you can use to connect to your MSDE database...
HTH.
"Jolly Student" <jolly@.joy.com> wrote in message
news:ifr1d.8926$G03.2990374@.news4.srv.hcvlny.cv.ne t...
> Dear Colleagues:
> This is such an SQL newbie question its not even funny. To begin with,
> please forgive my informality as well as my lack of any specific error
> messages, etc.. . I think the questions are academic (the specific error
> messages and notes are strewn about my desk at work).
> Okay, so here I am, I have a shiny new Windows 2003 Advanced server. So I
> want to set up a tiny sharepoint team services site, simple enough. Its
the
> lightweight version that is
> included in the Front Page 2002 CD and pooft, instant sharepoint and badda
> bing, you have a small website that small workgroups can use. Please note,
> this is not a super confidential eyes only website, so if I had lax MSDE
> security, it would not keep me awake at night.
> So I download the MSDE from Microsoft and realize that I need to provide a
> password for the sa account. A switch after setup.exe.
> First, is there a way that I can forego this password, that is to say,
that
> there is a way for me to install MSDE without a service account password.
> I provided the password, the install went great, but now I have issues
> associating the sharepoint services site to the MSDE. Obviously, the MSDE
> needs to know that sharepoint team services is a good boy.
> My problem is that I do not see any configuration options in the small
MSDE
> engine, so the question here is, other than going to SQL 2000 full blown
> where I can tweak things, is how to I tell MSDE that
> the team services site, via IIS 6 (running in IIS5 mode) is okay to use
it.
> Ideally, my goal would be to install MSDE without having to provide a
> password, but any advice that could be given would be appreciated.
> Thanks,
> Roger
>
Basic MSDE Setup Question on Windows Server 2003
Dear Colleagues:
This is such an SQL newbie question its not even funny. To begin with,
please forgive my informality as well as my lack of any specific error
messages, etc.. . I think the questions are academic (the specific error
messages and notes are strewn about my desk at work).
Okay, so here I am, I have a shiny new Windows 2003 Advanced server. So I
want to set up a tiny sharepoint team services site, simple enough. Its the
lightweight version that is
included in the Front Page 2002 CD and pooft, instant sharepoint and badda
bing, you have a small website that small workgroups can use. Please note,
this is not a super confidential eyes only website, so if I had lax MSDE
security, it would not keep me awake at night.
So I download the MSDE from Microsoft and realize that I need to provide a
password for the sa account. A switch after setup.exe.
First, is there a way that I can forego this password, that is to say, that
there is a way for me to install MSDE without a service account password.
I provided the password, the install went great, but now I have issues
associating the sharepoint services site to the MSDE. Obviously, the MSDE
needs to know that sharepoint team services is a good boy.
My problem is that I do not see any configuration options in the small MSDE
engine, so the question here is, other than going to SQL 2000 full blown
where I can tweak things, is how to I tell MSDE that
the team services site, via IIS 6 (running in IIS5 mode) is okay to use it.
Ideally, my goal would be to install MSDE without having to provide a
password, but any advice that could be given would be appreciated.
Thanks,
Roger
If you are trying to "configure" the installation of MSDE you need to get a
copy of the enterprise manager from a SQL 2000 CD or something and you can
then use that to connect to the MSDE database and configure it. MSDE itself
does not come with these tools as it is the "lite" version of SQL, but the
enterprise tools can be used with it to configure it.
Hopefully you have an actual SQL 2000 Server on your network somewhere that
you can use to connect to your MSDE database...
HTH.
"Jolly Student" <jolly@.joy.com> wrote in message
news:ifr1d.8926$G03.2990374@.news4.srv.hcvlny.cv.ne t...
> Dear Colleagues:
> This is such an SQL newbie question its not even funny. To begin with,
> please forgive my informality as well as my lack of any specific error
> messages, etc.. . I think the questions are academic (the specific error
> messages and notes are strewn about my desk at work).
> Okay, so here I am, I have a shiny new Windows 2003 Advanced server. So I
> want to set up a tiny sharepoint team services site, simple enough. Its
the
> lightweight version that is
> included in the Front Page 2002 CD and pooft, instant sharepoint and badda
> bing, you have a small website that small workgroups can use. Please note,
> this is not a super confidential eyes only website, so if I had lax MSDE
> security, it would not keep me awake at night.
> So I download the MSDE from Microsoft and realize that I need to provide a
> password for the sa account. A switch after setup.exe.
> First, is there a way that I can forego this password, that is to say,
that
> there is a way for me to install MSDE without a service account password.
> I provided the password, the install went great, but now I have issues
> associating the sharepoint services site to the MSDE. Obviously, the MSDE
> needs to know that sharepoint team services is a good boy.
> My problem is that I do not see any configuration options in the small
MSDE
> engine, so the question here is, other than going to SQL 2000 full blown
> where I can tweak things, is how to I tell MSDE that
> the team services site, via IIS 6 (running in IIS5 mode) is okay to use
it.
> Ideally, my goal would be to install MSDE without having to provide a
> password, but any advice that could be given would be appreciated.
> Thanks,
> Roger
>
sql
This is such an SQL newbie question its not even funny. To begin with,
please forgive my informality as well as my lack of any specific error
messages, etc.. . I think the questions are academic (the specific error
messages and notes are strewn about my desk at work).
Okay, so here I am, I have a shiny new Windows 2003 Advanced server. So I
want to set up a tiny sharepoint team services site, simple enough. Its the
lightweight version that is
included in the Front Page 2002 CD and pooft, instant sharepoint and badda
bing, you have a small website that small workgroups can use. Please note,
this is not a super confidential eyes only website, so if I had lax MSDE
security, it would not keep me awake at night.
So I download the MSDE from Microsoft and realize that I need to provide a
password for the sa account. A switch after setup.exe.
First, is there a way that I can forego this password, that is to say, that
there is a way for me to install MSDE without a service account password.
I provided the password, the install went great, but now I have issues
associating the sharepoint services site to the MSDE. Obviously, the MSDE
needs to know that sharepoint team services is a good boy.
My problem is that I do not see any configuration options in the small MSDE
engine, so the question here is, other than going to SQL 2000 full blown
where I can tweak things, is how to I tell MSDE that
the team services site, via IIS 6 (running in IIS5 mode) is okay to use it.
Ideally, my goal would be to install MSDE without having to provide a
password, but any advice that could be given would be appreciated.
Thanks,
Roger
If you are trying to "configure" the installation of MSDE you need to get a
copy of the enterprise manager from a SQL 2000 CD or something and you can
then use that to connect to the MSDE database and configure it. MSDE itself
does not come with these tools as it is the "lite" version of SQL, but the
enterprise tools can be used with it to configure it.
Hopefully you have an actual SQL 2000 Server on your network somewhere that
you can use to connect to your MSDE database...
HTH.
"Jolly Student" <jolly@.joy.com> wrote in message
news:ifr1d.8926$G03.2990374@.news4.srv.hcvlny.cv.ne t...
> Dear Colleagues:
> This is such an SQL newbie question its not even funny. To begin with,
> please forgive my informality as well as my lack of any specific error
> messages, etc.. . I think the questions are academic (the specific error
> messages and notes are strewn about my desk at work).
> Okay, so here I am, I have a shiny new Windows 2003 Advanced server. So I
> want to set up a tiny sharepoint team services site, simple enough. Its
the
> lightweight version that is
> included in the Front Page 2002 CD and pooft, instant sharepoint and badda
> bing, you have a small website that small workgroups can use. Please note,
> this is not a super confidential eyes only website, so if I had lax MSDE
> security, it would not keep me awake at night.
> So I download the MSDE from Microsoft and realize that I need to provide a
> password for the sa account. A switch after setup.exe.
> First, is there a way that I can forego this password, that is to say,
that
> there is a way for me to install MSDE without a service account password.
> I provided the password, the install went great, but now I have issues
> associating the sharepoint services site to the MSDE. Obviously, the MSDE
> needs to know that sharepoint team services is a good boy.
> My problem is that I do not see any configuration options in the small
MSDE
> engine, so the question here is, other than going to SQL 2000 full blown
> where I can tweak things, is how to I tell MSDE that
> the team services site, via IIS 6 (running in IIS5 mode) is okay to use
it.
> Ideally, my goal would be to install MSDE without having to provide a
> password, but any advice that could be given would be appreciated.
> Thanks,
> Roger
>
sql
Monday, March 19, 2012
Bad parsing?
Dear all,
I have an xml code to parse automatically using sp_xml_preparedocument. It's
seemed to be correct, but there're some incomprehensible errors when it's
parsed.
XML:
<Body>
<sen:SigEnvelope xmlns:sen="urn:www-com:dsig:env:v1.0">
<sen:PrimarySig>
<dsig:SigValue
xmlns:dsig="urn:www-com:dsig:v1.0">RpxoZ6vnUXn9/nTSC9rkqeWtlNYTc+RxWZ5JbdFW6Vlg+ULhx7uDJFPRIdqxXJn IugF2xzlpgjCtmh4hz9tLAg==</dsig:SigValue>
</sen:PrimarySig>
<sen:ControlSig>
<dsig:SigValue
xmlns:dsig="urn:www-com:dsig:v1.0">i01zjNFRrTgxMbwnCmfHRE+MFmA6dq53xKt FPCQ9JBKI8YLPaCiSRL97WDe761bEELFtlFQ3O/H9GSmOCx+siw==</dsig:SigValue>
</sen:ControlSig>
<sen:Object>
<PacketEPD xmlns="urn:www-com:ed:v1.0" EDNo="1" EDDate="2003-04-14"
EDAuthor="4525545000" EDQuantity="2" Sum="1">
<ED101 xmlns="urn:www-com:ed:v1.0" EDNo="7" EDDate="2003-04-14">
<AccDoc AccDocNo="4" AccDocDate="2003-04-15" />
</ED101>
<ED101 xmlns="urn:www-com:ed:v1.0" EDNo="8" EDDate="2003-04-15">
<AccDoc AccDocNo="4" AccDocDate="2003-04-15" />
</ED101>
<ED101 xmlns="urn:www-com:ed:v1.0" EDNo="9" EDDate="2003-04-16">
<AccDoc AccDocNo="4" AccDocDate="2003-04-15" />
</ED101>
</PacketEPD>
</sen:Object>
</sen:SigEnvelope>
</Body>
SQL:
DECLARE @.ns VARCHAR(200)
SET @.ns = '<ROOT
xmlns:sen="urn:cbr-ru:dsig:env:v1.0"
xmlns:dsig="urn:cbr-ru:dsig:v1.0"
xmlns:obj="urn:cbr-ru:ed:v1.0"
/>'
exec sp_xml_preparedocument @.idoc OUTPUT, @.doc , @.ns
SELECT * FROM OPENXML (@.idoc, '//obj:ED101',8)
WITH (
PrimarySigvarchar(10) '//sen:PrimarySig',
ControlSigvarchar(10) '//sen:ControlSig' ,
PEPD_EDNovarchar(10)'//obj:PacketEPD/@.EDNo',
PEPD_EDAuthorvarchar(10)'//obj:PacketEPD/@.EDAuthor',
ED101_EDDatevarchar(10)'@.EDDate' ,
ED101_EDNovarchar(10)'@.EDNo'
)
exec sp_xml_removedocument @.idoc
When executing I got an error :
Server: Msg 6603, Level 16, State 1, Procedure sp_xml_preparedocument, Line 35
XML parsing error: The following tags were not closed: Body,
sen:SigEnvelope, sen:Object, PacketEPD, ED101.
But when I remain 2 <ED101 ...> blocks intead of 3 query runs correctly.
What is wrong?!
Thank you in advance,
alex
I am not seeing that error running against Microsoft SQL Server 2000 -
8.00.760.
What version of Sql Server are you using? And can you please send the
exact TSql script you are using?
Andrew Conrad
Microsoft Corp
http://blogs.msdn.com/aconrad
I have an xml code to parse automatically using sp_xml_preparedocument. It's
seemed to be correct, but there're some incomprehensible errors when it's
parsed.
XML:
<Body>
<sen:SigEnvelope xmlns:sen="urn:www-com:dsig:env:v1.0">
<sen:PrimarySig>
<dsig:SigValue
xmlns:dsig="urn:www-com:dsig:v1.0">RpxoZ6vnUXn9/nTSC9rkqeWtlNYTc+RxWZ5JbdFW6Vlg+ULhx7uDJFPRIdqxXJn IugF2xzlpgjCtmh4hz9tLAg==</dsig:SigValue>
</sen:PrimarySig>
<sen:ControlSig>
<dsig:SigValue
xmlns:dsig="urn:www-com:dsig:v1.0">i01zjNFRrTgxMbwnCmfHRE+MFmA6dq53xKt FPCQ9JBKI8YLPaCiSRL97WDe761bEELFtlFQ3O/H9GSmOCx+siw==</dsig:SigValue>
</sen:ControlSig>
<sen:Object>
<PacketEPD xmlns="urn:www-com:ed:v1.0" EDNo="1" EDDate="2003-04-14"
EDAuthor="4525545000" EDQuantity="2" Sum="1">
<ED101 xmlns="urn:www-com:ed:v1.0" EDNo="7" EDDate="2003-04-14">
<AccDoc AccDocNo="4" AccDocDate="2003-04-15" />
</ED101>
<ED101 xmlns="urn:www-com:ed:v1.0" EDNo="8" EDDate="2003-04-15">
<AccDoc AccDocNo="4" AccDocDate="2003-04-15" />
</ED101>
<ED101 xmlns="urn:www-com:ed:v1.0" EDNo="9" EDDate="2003-04-16">
<AccDoc AccDocNo="4" AccDocDate="2003-04-15" />
</ED101>
</PacketEPD>
</sen:Object>
</sen:SigEnvelope>
</Body>
SQL:
DECLARE @.ns VARCHAR(200)
SET @.ns = '<ROOT
xmlns:sen="urn:cbr-ru:dsig:env:v1.0"
xmlns:dsig="urn:cbr-ru:dsig:v1.0"
xmlns:obj="urn:cbr-ru:ed:v1.0"
/>'
exec sp_xml_preparedocument @.idoc OUTPUT, @.doc , @.ns
SELECT * FROM OPENXML (@.idoc, '//obj:ED101',8)
WITH (
PrimarySigvarchar(10) '//sen:PrimarySig',
ControlSigvarchar(10) '//sen:ControlSig' ,
PEPD_EDNovarchar(10)'//obj:PacketEPD/@.EDNo',
PEPD_EDAuthorvarchar(10)'//obj:PacketEPD/@.EDAuthor',
ED101_EDDatevarchar(10)'@.EDDate' ,
ED101_EDNovarchar(10)'@.EDNo'
)
exec sp_xml_removedocument @.idoc
When executing I got an error :
Server: Msg 6603, Level 16, State 1, Procedure sp_xml_preparedocument, Line 35
XML parsing error: The following tags were not closed: Body,
sen:SigEnvelope, sen:Object, PacketEPD, ED101.
But when I remain 2 <ED101 ...> blocks intead of 3 query runs correctly.
What is wrong?!
Thank you in advance,
alex
I am not seeing that error running against Microsoft SQL Server 2000 -
8.00.760.
What version of Sql Server are you using? And can you please send the
exact TSql script you are using?
Andrew Conrad
Microsoft Corp
http://blogs.msdn.com/aconrad
Bad parsing?
Dear all,
I have an xml code to parse automatically using sp_xml_preparedocument. It's
seemed to be correct, but there're some incomprehensible errors when it's
parsed.
XML:
<Body>
<sen:SigEnvelope xmlns:sen="urn:www-com:dsig:env:v1.0">
<sen:PrimarySig>
<dsig:SigValue
xmlns:dsig="urn:www-com:dsig:v1.0">RpxoZ6vnUXn9/nTSC9rkqeWtlNYTc+RxWZ5JbdFW6
Vlg+ULhx7uDJFPRIdqxXJnIugF2xzlpgjCtmh4hz
9tLAg==</dsig:SigValue>
</sen:PrimarySig>
<sen:ControlSig>
<dsig:SigValue
xmlns:dsig="urn:www-com:dsig:v1.0"> i01zjNFRrTgxMbwnCmfHRE+MFmA6dq53xKtFPCQ9
J
BKI8YLPaCiSRL97WDe761bEELFtlFQ3O/H9GSmOCx+siw==</dsig:SigValue>
</sen:ControlSig>
<sen:Object>
<PacketEPD xmlns="urn:www-com:ed:v1.0" EDNo="1" EDDate="2003-04-14"
EDAuthor="4525545000" EDQuantity="2" Sum="1">
<ED101 xmlns="urn:www-com:ed:v1.0" EDNo="7" EDDate="2003-04-14">
<AccDoc AccDocNo="4" AccDocDate="2003-04-15" />
</ED101>
<ED101 xmlns="urn:www-com:ed:v1.0" EDNo="8" EDDate="2003-04-15">
<AccDoc AccDocNo="4" AccDocDate="2003-04-15" />
</ED101>
<ED101 xmlns="urn:www-com:ed:v1.0" EDNo="9" EDDate="2003-04-16">
<AccDoc AccDocNo="4" AccDocDate="2003-04-15" />
</ED101>
</PacketEPD>
</sen:Object>
</sen:SigEnvelope>
</Body>
SQL:
DECLARE @.ns VARCHAR(200)
SET @.ns = '<ROOT
xmlns:sen="urn:cbr-ru:dsig:env:v1.0"
xmlns:dsig="urn:cbr-ru:dsig:v1.0"
xmlns:obj="urn:cbr-ru:ed:v1.0"
/>'
exec sp_xml_preparedocument @.idoc OUTPUT, @.doc , @.ns
SELECT * FROM OPENXML (@.idoc, '//obj:ED101',8)
WITH (
PrimarySig varchar(10) '//sen:PrimarySig',
ControlSig varchar(10) '//sen:ControlSig' ,
PEPD_EDNo varchar(10) '//obj:PacketEPD/@.EDNo',
PEPD_EDAuthor varchar(10) '//obj:PacketEPD/@.EDAuthor',
ED101_EDDate varchar(10) '@.EDDate' ,
ED101_EDNo varchar(10) '@.EDNo'
)
exec sp_xml_removedocument @.idoc
When executing I got an error :
Server: Msg 6603, Level 16, State 1, Procedure sp_xml_preparedocument, Line
35
XML parsing error: The following tags were not closed: Body,
sen:SigEnvelope, sen:Object, PacketEPD, ED101.
But when I remain 2 <ED101 ...> blocks intead of 3 query runs correctly.
What is wrong?!
Thank you in advance,
alexI am not seeing that error running against Microsoft SQL Server 2000 -
8.00.760.
What version of Sql Server are you using? And can you please send the
exact TSql script you are using?
Andrew Conrad
Microsoft Corp
http://blogs.msdn.com/aconrad
I have an xml code to parse automatically using sp_xml_preparedocument. It's
seemed to be correct, but there're some incomprehensible errors when it's
parsed.
XML:
<Body>
<sen:SigEnvelope xmlns:sen="urn:www-com:dsig:env:v1.0">
<sen:PrimarySig>
<dsig:SigValue
xmlns:dsig="urn:www-com:dsig:v1.0">RpxoZ6vnUXn9/nTSC9rkqeWtlNYTc+RxWZ5JbdFW6
Vlg+ULhx7uDJFPRIdqxXJnIugF2xzlpgjCtmh4hz
9tLAg==</dsig:SigValue>
</sen:PrimarySig>
<sen:ControlSig>
<dsig:SigValue
xmlns:dsig="urn:www-com:dsig:v1.0"> i01zjNFRrTgxMbwnCmfHRE+MFmA6dq53xKtFPCQ9
J
BKI8YLPaCiSRL97WDe761bEELFtlFQ3O/H9GSmOCx+siw==</dsig:SigValue>
</sen:ControlSig>
<sen:Object>
<PacketEPD xmlns="urn:www-com:ed:v1.0" EDNo="1" EDDate="2003-04-14"
EDAuthor="4525545000" EDQuantity="2" Sum="1">
<ED101 xmlns="urn:www-com:ed:v1.0" EDNo="7" EDDate="2003-04-14">
<AccDoc AccDocNo="4" AccDocDate="2003-04-15" />
</ED101>
<ED101 xmlns="urn:www-com:ed:v1.0" EDNo="8" EDDate="2003-04-15">
<AccDoc AccDocNo="4" AccDocDate="2003-04-15" />
</ED101>
<ED101 xmlns="urn:www-com:ed:v1.0" EDNo="9" EDDate="2003-04-16">
<AccDoc AccDocNo="4" AccDocDate="2003-04-15" />
</ED101>
</PacketEPD>
</sen:Object>
</sen:SigEnvelope>
</Body>
SQL:
DECLARE @.ns VARCHAR(200)
SET @.ns = '<ROOT
xmlns:sen="urn:cbr-ru:dsig:env:v1.0"
xmlns:dsig="urn:cbr-ru:dsig:v1.0"
xmlns:obj="urn:cbr-ru:ed:v1.0"
/>'
exec sp_xml_preparedocument @.idoc OUTPUT, @.doc , @.ns
SELECT * FROM OPENXML (@.idoc, '//obj:ED101',8)
WITH (
PrimarySig varchar(10) '//sen:PrimarySig',
ControlSig varchar(10) '//sen:ControlSig' ,
PEPD_EDNo varchar(10) '//obj:PacketEPD/@.EDNo',
PEPD_EDAuthor varchar(10) '//obj:PacketEPD/@.EDAuthor',
ED101_EDDate varchar(10) '@.EDDate' ,
ED101_EDNo varchar(10) '@.EDNo'
)
exec sp_xml_removedocument @.idoc
When executing I got an error :
Server: Msg 6603, Level 16, State 1, Procedure sp_xml_preparedocument, Line
35
XML parsing error: The following tags were not closed: Body,
sen:SigEnvelope, sen:Object, PacketEPD, ED101.
But when I remain 2 <ED101 ...> blocks intead of 3 query runs correctly.
What is wrong?!
Thank you in advance,
alexI am not seeing that error running against Microsoft SQL Server 2000 -
8.00.760.
What version of Sql Server are you using? And can you please send the
exact TSql script you are using?
Andrew Conrad
Microsoft Corp
http://blogs.msdn.com/aconrad
Thursday, March 8, 2012
Backup-to-file SQL2k Question/NT Tape Backups
Dear All,
Hello!
Now that I am running a maintenance backup-to-file from
within SQL2K, should I just be backing up these
backup-to-file to an NT backup job? Or should I also be
backing up the live databases & their transact logs?
Thanks!
CarlosNormal practice would be to backup the backup files from SQL to tape. If you
are taking regular SQL backups, there is no need to backup the actual
database files themselves (which would require stopping SQL anyway as they
are always in use)
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Carlos" <anonymous@.discussions.microsoft.com> wrote in message
news:10ef101c3f49b$fb627db0$a001280a@.phx.gbl...
> Dear All,
> Hello!
> Now that I am running a maintenance backup-to-file from
> within SQL2K, should I just be backing up these
> backup-to-file to an NT backup job? Or should I also be
> backing up the live databases & their transact logs?
> Thanks!
> Carlos
>|||You don't have to backup the mdf, ndf and ldf files if you let SQL Server do
database and possibly transaction log backup to disk and then backup those
files to tape.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Carlos" <anonymous@.discussions.microsoft.com> wrote in message
news:10ef101c3f49b$fb627db0$a001280a@.phx.gbl...
> Dear All,
> Hello!
> Now that I am running a maintenance backup-to-file from
> within SQL2K, should I just be backing up these
> backup-to-file to an NT backup job? Or should I also be
> backing up the live databases & their transact logs?
> Thanks!
> Carlos
>
Hello!
Now that I am running a maintenance backup-to-file from
within SQL2K, should I just be backing up these
backup-to-file to an NT backup job? Or should I also be
backing up the live databases & their transact logs?
Thanks!
CarlosNormal practice would be to backup the backup files from SQL to tape. If you
are taking regular SQL backups, there is no need to backup the actual
database files themselves (which would require stopping SQL anyway as they
are always in use)
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Carlos" <anonymous@.discussions.microsoft.com> wrote in message
news:10ef101c3f49b$fb627db0$a001280a@.phx.gbl...
> Dear All,
> Hello!
> Now that I am running a maintenance backup-to-file from
> within SQL2K, should I just be backing up these
> backup-to-file to an NT backup job? Or should I also be
> backing up the live databases & their transact logs?
> Thanks!
> Carlos
>|||You don't have to backup the mdf, ndf and ldf files if you let SQL Server do
database and possibly transaction log backup to disk and then backup those
files to tape.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Carlos" <anonymous@.discussions.microsoft.com> wrote in message
news:10ef101c3f49b$fb627db0$a001280a@.phx.gbl...
> Dear All,
> Hello!
> Now that I am running a maintenance backup-to-file from
> within SQL2K, should I just be backing up these
> backup-to-file to an NT backup job? Or should I also be
> backing up the live databases & their transact logs?
> Thanks!
> Carlos
>
Backup-to-file SQL2k Question/NT Tape Backups
Dear All,
Hello!
Now that I am running a maintenance backup-to-file from
within SQL2K, should I just be backing up these
backup-to-file to an NT backup job? Or should I also be
backing up the live databases & their transact logs?
Thanks!
CarlosNormal practice would be to backup the backup files from SQL to tape. If you
are taking regular SQL backups, there is no need to backup the actual
database files themselves (which would require stopping SQL anyway as they
are always in use)
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Carlos" <anonymous@.discussions.microsoft.com> wrote in message
news:10ef101c3f49b$fb627db0$a001280a@.phx
.gbl...
> Dear All,
> Hello!
> Now that I am running a maintenance backup-to-file from
> within SQL2K, should I just be backing up these
> backup-to-file to an NT backup job? Or should I also be
> backing up the live databases & their transact logs?
> Thanks!
> Carlos
>|||You don't have to backup the mdf, ndf and ldf files if you let SQL Server do
database and possibly transaction log backup to disk and then backup those
files to tape.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Carlos" <anonymous@.discussions.microsoft.com> wrote in message
news:10ef101c3f49b$fb627db0$a001280a@.phx
.gbl...
> Dear All,
> Hello!
> Now that I am running a maintenance backup-to-file from
> within SQL2K, should I just be backing up these
> backup-to-file to an NT backup job? Or should I also be
> backing up the live databases & their transact logs?
> Thanks!
> Carlos
>
Hello!
Now that I am running a maintenance backup-to-file from
within SQL2K, should I just be backing up these
backup-to-file to an NT backup job? Or should I also be
backing up the live databases & their transact logs?
Thanks!
CarlosNormal practice would be to backup the backup files from SQL to tape. If you
are taking regular SQL backups, there is no need to backup the actual
database files themselves (which would require stopping SQL anyway as they
are always in use)
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Carlos" <anonymous@.discussions.microsoft.com> wrote in message
news:10ef101c3f49b$fb627db0$a001280a@.phx
.gbl...
> Dear All,
> Hello!
> Now that I am running a maintenance backup-to-file from
> within SQL2K, should I just be backing up these
> backup-to-file to an NT backup job? Or should I also be
> backing up the live databases & their transact logs?
> Thanks!
> Carlos
>|||You don't have to backup the mdf, ndf and ldf files if you let SQL Server do
database and possibly transaction log backup to disk and then backup those
files to tape.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Carlos" <anonymous@.discussions.microsoft.com> wrote in message
news:10ef101c3f49b$fb627db0$a001280a@.phx
.gbl...
> Dear All,
> Hello!
> Now that I am running a maintenance backup-to-file from
> within SQL2K, should I just be backing up these
> backup-to-file to an NT backup job? Or should I also be
> backing up the live databases & their transact logs?
> Thanks!
> Carlos
>
Wednesday, March 7, 2012
Backups Failed
Dear All,
We recently changed our user for the SQL Agent. On Sunday
nights we backup all our databases and perform checks,
this Sunday they did not work. The error is as follows: -
'
Microsoft (R) SQLMaint Utility (Unicode), Version Logged
on to SQL Server 'INVESTMENTS1' as 'NT AUTHORITY\SYSTEM'
(trusted)
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 229:
[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT
permission denied on object 'sysdbmaintplans',
database 'msdb', owner 'dbo'.'
The odd thing however is we have other jobs that run on a
day by day basis that still work, can anyone help?
Thanks
PeterHi,
Check whether local administrators group on the machine still a member of
the
sysadmin server role? Else add it and verify the job.
Incase if you still have issues then,
Can you please add that user (User inwhich u start SQL Agent) to
buildin\administrators group and verify the execution.
or else give select permission on 'sysdbmaintplans' table to the user in
which you have started SQL Agent.
Thanks
Hari
MCDBA
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:a44e01c40a74$e3ee35e0$a601280a@.phx.gbl...
> Dear All,
> We recently changed our user for the SQL Agent. On Sunday
> nights we backup all our databases and perform checks,
> this Sunday they did not work. The error is as follows: -
> '
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged
> on to SQL Server 'INVESTMENTS1' as 'NT AUTHORITY\SYSTEM'
> (trusted)
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 229:
> [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT
> permission denied on object 'sysdbmaintplans',
> database 'msdb', owner 'dbo'.'
> The odd thing however is we have other jobs that run on a
> day by day basis that still work, can anyone help?
> Thanks
> Peter|||Thanks Hari,
Someone took out the Sysadmin access to the BUILTIN\Admin
right.
Peter
>--Original Message--
>Hi,
>Check whether local administrators group on the machine
still a member of
>the
>sysadmin server role? Else add it and verify the job.
>Incase if you still have issues then,
>Can you please add that user (User inwhich u start SQL
Agent) to
>buildin\administrators group and verify the execution.
>or else give select permission on 'sysdbmaintplans' table
to the user in
>which you have started SQL Agent.
>
>
>Thanks
>Hari
>MCDBA
>
>
>"Peter" <anonymous@.discussions.microsoft.com> wrote in
message
>news:a44e01c40a74$e3ee35e0$a601280a@.phx.gbl...
Sunday
follows: -
a
>
>.
>
We recently changed our user for the SQL Agent. On Sunday
nights we backup all our databases and perform checks,
this Sunday they did not work. The error is as follows: -
'
Microsoft (R) SQLMaint Utility (Unicode), Version Logged
on to SQL Server 'INVESTMENTS1' as 'NT AUTHORITY\SYSTEM'
(trusted)
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 229:
[Microsoft][ODBC SQL Server Driver][SQL Server]SELECT
permission denied on object 'sysdbmaintplans',
database 'msdb', owner 'dbo'.'
The odd thing however is we have other jobs that run on a
day by day basis that still work, can anyone help?
Thanks
PeterHi,
Check whether local administrators group on the machine still a member of
the
sysadmin server role? Else add it and verify the job.
Incase if you still have issues then,
Can you please add that user (User inwhich u start SQL Agent) to
buildin\administrators group and verify the execution.
or else give select permission on 'sysdbmaintplans' table to the user in
which you have started SQL Agent.
Thanks
Hari
MCDBA
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:a44e01c40a74$e3ee35e0$a601280a@.phx.gbl...
> Dear All,
> We recently changed our user for the SQL Agent. On Sunday
> nights we backup all our databases and perform checks,
> this Sunday they did not work. The error is as follows: -
> '
> Microsoft (R) SQLMaint Utility (Unicode), Version Logged
> on to SQL Server 'INVESTMENTS1' as 'NT AUTHORITY\SYSTEM'
> (trusted)
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 229:
> [Microsoft][ODBC SQL Server Driver][SQL Server]SELECT
> permission denied on object 'sysdbmaintplans',
> database 'msdb', owner 'dbo'.'
> The odd thing however is we have other jobs that run on a
> day by day basis that still work, can anyone help?
> Thanks
> Peter|||Thanks Hari,
Someone took out the Sysadmin access to the BUILTIN\Admin
right.
Peter
>--Original Message--
>Hi,
>Check whether local administrators group on the machine
still a member of
>the
>sysadmin server role? Else add it and verify the job.
>Incase if you still have issues then,
>Can you please add that user (User inwhich u start SQL
Agent) to
>buildin\administrators group and verify the execution.
>or else give select permission on 'sysdbmaintplans' table
to the user in
>which you have started SQL Agent.
>
>
>Thanks
>Hari
>MCDBA
>
>
>"Peter" <anonymous@.discussions.microsoft.com> wrote in
message
>news:a44e01c40a74$e3ee35e0$a601280a@.phx.gbl...
Sunday
follows: -
a
>
>.
>
Saturday, February 25, 2012
backups
Dear all,
I would like to know in what table the backups are stored.
I mean, I see in the SQL Server log registry these lines:
Database backed up: Database: DATA1, creation date(time):
2005/07/26(17:11:49), pages dumped: 63699, first LSN: 2724:195:1, last LSN:
2724:197:1, number of dump devices: 1, device information: (FILE=1,
TYPE=VIRTUAL_DEVICE: {'Legato#af0fc469-fcdc-4b4e-a05f-4a774487e651'}).
..
..
That's fine but from what table is retrieving SQL that information?
Best regards,Enric,
The info is scatted across a few tables in the msdb database.
Mainly backupset, but have a look at the others whose name starts with backu
p :)
Regards
AJ
"Enric" <Enric@.discussions.microsoft.com> wrote in message news:8AA0C8CB-9368-4C70-8883-444
2B4CAA10E@.microsoft.com...
> Dear all,
> I would like to know in what table the backups are stored.
> I mean, I see in the SQL Server log registry these lines:
> Database backed up: Database: DATA1, creation date(time):
> 2005/07/26(17:11:49), pages dumped: 63699, first LSN: 2724:195:1, last LSN
:
> 2724:197:1, number of dump devices: 1, device information: (FILE=1,
> TYPE=VIRTUAL_DEVICE: {'Legato#af0fc469-fcdc-4b4e-a05f-4a774487e651'}).
> ..
> ..
> That's fine but from what table is retrieving SQL that information?
> Best regards,
>
>|||Below four tables in the msdb database:
dbo.backupfile
dbo.backupmediafamily
dbo.backupmediaset
dbo.backupset
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:8AA0C8CB-9368-4C70-8883-4442B4CAA10E@.microsoft.com...
> Dear all,
> I would like to know in what table the backups are stored.
> I mean, I see in the SQL Server log registry these lines:
> Database backed up: Database: DATA1, creation date(time):
> 2005/07/26(17:11:49), pages dumped: 63699, first LSN: 2724:195:1, last LSN
:
> 2724:197:1, number of dump devices: 1, device information: (FILE=1,
> TYPE=VIRTUAL_DEVICE: {'Legato#af0fc469-fcdc-4b4e-a05f-4a774487e651'}).
> ..
> ..
> That's fine but from what table is retrieving SQL that information?
> Best regards,
>
>|||Thanks a lot to both,
"Tibor Karaszi" wrote:
> Below four tables in the msdb database:
> dbo.backupfile
> dbo.backupmediafamily
> dbo.backupmediaset
> dbo.backupset
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:8AA0C8CB-9368-4C70-8883-4442B4CAA10E@.microsoft.com...
>
I would like to know in what table the backups are stored.
I mean, I see in the SQL Server log registry these lines:
Database backed up: Database: DATA1, creation date(time):
2005/07/26(17:11:49), pages dumped: 63699, first LSN: 2724:195:1, last LSN:
2724:197:1, number of dump devices: 1, device information: (FILE=1,
TYPE=VIRTUAL_DEVICE: {'Legato#af0fc469-fcdc-4b4e-a05f-4a774487e651'}).
..
..
That's fine but from what table is retrieving SQL that information?
Best regards,Enric,
The info is scatted across a few tables in the msdb database.
Mainly backupset, but have a look at the others whose name starts with backu
p :)
Regards
AJ
"Enric" <Enric@.discussions.microsoft.com> wrote in message news:8AA0C8CB-9368-4C70-8883-444
2B4CAA10E@.microsoft.com...
> Dear all,
> I would like to know in what table the backups are stored.
> I mean, I see in the SQL Server log registry these lines:
> Database backed up: Database: DATA1, creation date(time):
> 2005/07/26(17:11:49), pages dumped: 63699, first LSN: 2724:195:1, last LSN
:
> 2724:197:1, number of dump devices: 1, device information: (FILE=1,
> TYPE=VIRTUAL_DEVICE: {'Legato#af0fc469-fcdc-4b4e-a05f-4a774487e651'}).
> ..
> ..
> That's fine but from what table is retrieving SQL that information?
> Best regards,
>
>|||Below four tables in the msdb database:
dbo.backupfile
dbo.backupmediafamily
dbo.backupmediaset
dbo.backupset
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:8AA0C8CB-9368-4C70-8883-4442B4CAA10E@.microsoft.com...
> Dear all,
> I would like to know in what table the backups are stored.
> I mean, I see in the SQL Server log registry these lines:
> Database backed up: Database: DATA1, creation date(time):
> 2005/07/26(17:11:49), pages dumped: 63699, first LSN: 2724:195:1, last LSN
:
> 2724:197:1, number of dump devices: 1, device information: (FILE=1,
> TYPE=VIRTUAL_DEVICE: {'Legato#af0fc469-fcdc-4b4e-a05f-4a774487e651'}).
> ..
> ..
> That's fine but from what table is retrieving SQL that information?
> Best regards,
>
>|||Thanks a lot to both,
"Tibor Karaszi" wrote:
> Below four tables in the msdb database:
> dbo.backupfile
> dbo.backupmediafamily
> dbo.backupmediaset
> dbo.backupset
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Enric" <Enric@.discussions.microsoft.com> wrote in message
> news:8AA0C8CB-9368-4C70-8883-4442B4CAA10E@.microsoft.com...
>
Subscribe to:
Posts (Atom)