Help in Chosing the Software for Reporting Services

Hi All,

I have downloaded SQL Server 2005 Express Edition with Advanced Services SP2 from the following link

http://msdn.microsoft.com/vstudio/express/sql/download/

This I did after hearing Advanced Services provide Reporting Services tool with basic functionalities. After installion I am not able to find the SQL Server Business Intelligence Development Studio. Also there is no provision for installing the Reporting Services.

I already have Visual Studio Express installed.

Could someone tell me what else to download? Also it is asking for another software to be downloaded along with the existing one.

Regards

Karthik

In Visual Studio, when you try and create new projects, do you see a folder called "business intelligence"?|||

I am using Visual Web Developer 2005 Express Edition not Visual Studio. I don't have that option.

I was browsing through many other but couldn't understand clearly what is going wrong. Could you tell me the pre-requisites required for the installation?

|||http://www.microsoft.com/technet/prodtechnol/sql/2005/usingssrswithsqlexpress.mspx|||

Thanks for the link...

After lot of searching I figured out the option to install Reporting Services would not appear till IIS is installed. After doing this it is working fine now.

Could you please let me know if installation of SQL Server 2005 Express Edition with Advanced Services SP2 is possible in Vista Home Basic. Nowhere it is clearly explained if it can be done or not.

Help Import Export Wizard SQL Server 2005

Hi! I have XP sp2, with SQL server 2005 Developer Edition 9.00.3054.00 and also have Microsoft SQL Server Express Edition 9.00.3042.00, well my problem alway I want import data into any server from any data source I recive this message:

TITLE: SQL Server Import and Export Wizard

The operation could not be completed.

ADDITIONAL INFORMATION:

Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies. The system cannot find the file specified. (System.EnterpriseServices)

Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies. The system cannot find the file specified.

The system cannot find the file specified. (Exception from HRESULT: 0x80070002)

BUTTONS:

OK

I have this name space but, I try for many ways and I can't import data in my server, What can I do?

Thanks a lot.

Do you have your Dev edition and Express edition of SQL Server installed on the same machine?

This could be some sort of side by side problem. Could you try to install only the dev edition and then attempt the data import?

Thanks,

Bob

|||

Hi! I find the problem... Well I have install frameWork 1.1 2.0 and 3.0 but in Assemblie cache have System.EnterpriseServices.dll version 1.0 so... There are 2 solutions..

1.- Uninstall FrameWork 1.1 and reinstall 2.0

2.- Use gacutil and register System.EnterpriseServices.dll from version 2.0 <- this work for me.

Thans a lot for every one.

Help applying SP2 Beta

Help!!!
After applying SP2 beta to my Test Server I get the following message when
launching the Report Manager:
"The version of the report server database is either in a format that is not
valid, or it cannot be read. The found version is 'Unknown'. The expected
version is 'C.0.6.54'. To continue, update the version of the report server
database and verify access rights. (rsInvalidReportServerDatabase)"
Get Online Help URL:
http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
I tried following the Get Online Help link instructions without success.
I even uninstalled Report Server and re-installed my SP1 version!
Do I need to drop the Report Server Databases before re-installing?
I have back-up of the orignal tables
I need to acces some reports that I had created in the test environment.
--
Application Engineer / DBA
UCLA SOMMake sure that all of your SPs are in the dbo namespace.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marcial" <no_spam@.antispammer.com> wrote in message
news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
> Help!!!
> After applying SP2 beta to my Test Server I get the following message when
> launching the Report Manager:
> "The version of the report server database is either in a format that is
> not
> valid, or it cannot be read. The found version is 'Unknown'. The expected
> version is 'C.0.6.54'. To continue, update the version of the report
> server
> database and verify access rights. (rsInvalidReportServerDatabase)"
> Get Online Help URL:
> http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
> I tried following the Get Online Help link instructions without success.
> I even uninstalled Report Server and re-installed my SP1 version!
> Do I need to drop the Report Server Databases before re-installing?
> I have back-up of the orignal tables
> I need to acces some reports that I had created in the test environment.
> --
> Application Engineer / DBA
> UCLA SOM|||Thanks Daniel, could you be a bit morer specific on how to ensure SPs in dbo
namespace!
"Daniel Reib [MSFT]" wrote:
> Make sure that all of your SPs are in the dbo namespace.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Marcial" <no_spam@.antispammer.com> wrote in message
> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
> > Help!!!
> >
> > After applying SP2 beta to my Test Server I get the following message when
> > launching the Report Manager:
> >
> > "The version of the report server database is either in a format that is
> > not
> > valid, or it cannot be read. The found version is 'Unknown'. The expected
> > version is 'C.0.6.54'. To continue, update the version of the report
> > server
> > database and verify access rights. (rsInvalidReportServerDatabase)"
> >
> > Get Online Help URL:
> >
> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
> >
> > I tried following the Get Online Help link instructions without success.
> >
> > I even uninstalled Report Server and re-installed my SP1 version!
> > Do I need to drop the Report Server Databases before re-installing?
> >
> > I have back-up of the orignal tables
> >
> > I need to acces some reports that I had created in the test environment.
> >
> > --
> > Application Engineer / DBA
> > UCLA SOM
>
>|||If you go to enterprise manager, find the reportserver database and look at
it's SPs. Who is the owner of the SPs?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marcial" <no_spam@.antispammer.com> wrote in message
news:2759A2F2-7BE6-4C43-9745-3ADCEE9B4AF8@.microsoft.com...
> Thanks Daniel, could you be a bit morer specific on how to ensure SPs in
> dbo
> namespace!
> "Daniel Reib [MSFT]" wrote:
>> Make sure that all of your SPs are in the dbo namespace.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Marcial" <no_spam@.antispammer.com> wrote in message
>> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
>> > Help!!!
>> >
>> > After applying SP2 beta to my Test Server I get the following message
>> > when
>> > launching the Report Manager:
>> >
>> > "The version of the report server database is either in a format that
>> > is
>> > not
>> > valid, or it cannot be read. The found version is 'Unknown'. The
>> > expected
>> > version is 'C.0.6.54'. To continue, update the version of the report
>> > server
>> > database and verify access rights. (rsInvalidReportServerDatabase)"
>> >
>> > Get Online Help URL:
>> >
>> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
>> >
>> > I tried following the Get Online Help link instructions without
>> > success.
>> >
>> > I even uninstalled Report Server and re-installed my SP1 version!
>> > Do I need to drop the Report Server Databases before re-installing?
>> >
>> > I have back-up of the orignal tables
>> >
>> > I need to acces some reports that I had created in the test
>> > environment.
>> >
>> > --
>> > Application Engineer / DBA
>> > UCLA SOM
>>|||Ok... I have verified that the dbo is the owner or the Stored Procedures in
both the
ReportServer and ReportServerTembDB. There is also an RSExecute Role which
currently contains no users.
could this be the cause of the error?
I also need to metion that I had installed SQL SERVER SP4 beta.
Could this be cause problems with Reporting Services'
"Daniel Reib [MSFT]" wrote:
> If you go to enterprise manager, find the reportserver database and look at
> it's SPs. Who is the owner of the SPs?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Marcial" <no_spam@.antispammer.com> wrote in message
> news:2759A2F2-7BE6-4C43-9745-3ADCEE9B4AF8@.microsoft.com...
> > Thanks Daniel, could you be a bit morer specific on how to ensure SPs in
> > dbo
> > namespace!
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Make sure that all of your SPs are in the dbo namespace.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Marcial" <no_spam@.antispammer.com> wrote in message
> >> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
> >> > Help!!!
> >> >
> >> > After applying SP2 beta to my Test Server I get the following message
> >> > when
> >> > launching the Report Manager:
> >> >
> >> > "The version of the report server database is either in a format that
> >> > is
> >> > not
> >> > valid, or it cannot be read. The found version is 'Unknown'. The
> >> > expected
> >> > version is 'C.0.6.54'. To continue, update the version of the report
> >> > server
> >> > database and verify access rights. (rsInvalidReportServerDatabase)"
> >> >
> >> > Get Online Help URL:
> >> >
> >> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
> >> >
> >> > I tried following the Get Online Help link instructions without
> >> > success.
> >> >
> >> > I even uninstalled Report Server and re-installed my SP1 version!
> >> > Do I need to drop the Report Server Databases before re-installing?
> >> >
> >> > I have back-up of the orignal tables
> >> >
> >> > I need to acces some reports that I had created in the test
> >> > environment.
> >> >
> >> > --
> >> > Application Engineer / DBA
> >> > UCLA SOM
> >>
> >>
> >>
>
>|||Do you know what user you use to connect to the database server? You may
want to run rsconfig.exe to set the user to a specific user. You would then
need to manually add that user to each RSExecRole. There are four roles, on
in each of the following DB:
ReportServer
ReportServerTempDB
Master
Msdb
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Marcial" <no_spam@.antispammer.com> wrote in message
news:BC3682DA-89F6-41F4-9B29-98E63EC203D1@.microsoft.com...
> Ok... I have verified that the dbo is the owner or the Stored Procedures
> in
> both the
> ReportServer and ReportServerTembDB. There is also an RSExecute Role which
> currently contains no users.
> could this be the cause of the error?
> I also need to metion that I had installed SQL SERVER SP4 beta.
> Could this be cause problems with Reporting Services'
> "Daniel Reib [MSFT]" wrote:
>> If you go to enterprise manager, find the reportserver database and look
>> at
>> it's SPs. Who is the owner of the SPs?
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Marcial" <no_spam@.antispammer.com> wrote in message
>> news:2759A2F2-7BE6-4C43-9745-3ADCEE9B4AF8@.microsoft.com...
>> > Thanks Daniel, could you be a bit morer specific on how to ensure SPs
>> > in
>> > dbo
>> > namespace!
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> Make sure that all of your SPs are in the dbo namespace.
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Marcial" <no_spam@.antispammer.com> wrote in message
>> >> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
>> >> > Help!!!
>> >> >
>> >> > After applying SP2 beta to my Test Server I get the following
>> >> > message
>> >> > when
>> >> > launching the Report Manager:
>> >> >
>> >> > "The version of the report server database is either in a format
>> >> > that
>> >> > is
>> >> > not
>> >> > valid, or it cannot be read. The found version is 'Unknown'. The
>> >> > expected
>> >> > version is 'C.0.6.54'. To continue, update the version of the report
>> >> > server
>> >> > database and verify access rights. (rsInvalidReportServerDatabase)"
>> >> >
>> >> > Get Online Help URL:
>> >> >
>> >> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
>> >> >
>> >> > I tried following the Get Online Help link instructions without
>> >> > success.
>> >> >
>> >> > I even uninstalled Report Server and re-installed my SP1 version!
>> >> > Do I need to drop the Report Server Databases before re-installing?
>> >> >
>> >> > I have back-up of the orignal tables
>> >> >
>> >> > I need to acces some reports that I had created in the test
>> >> > environment.
>> >> >
>> >> > --
>> >> > Application Engineer / DBA
>> >> > UCLA SOM
>> >>
>> >>
>> >>
>>|||May I jump in here? I am having a similar problem, but my error originally
differed slightly.
Instead of "found version 'Unknown'", mine reported "found version
'T.0.6.51'. Cause apparently
due to me using RSCONFIG to try to change the credentials used to connect to
the RS SQL
Server databases. Commands I issued:
rsconfig -c -s KCBSGP12 -d ReportServer2000 -a sql -u RSAdmin -p xxxxxx
rsconfig -c -s KCBSGP12 -d ReportServer2000TempDB -a sql -u RSAdmin -p xxxxxx
RSAdmin was a created as user in ReportServer2000 and ReportServer2000TempDB
with same
permissions as the original account (an AD account versus SQL account, in
case that's important).
Restarted ReportServer service and got the error. Then realized from this
thread I had missed
MASTER and MSDB databases, so added RSAdmin user to those as well, then
issued "rsconfig"
commands as above for those two databases. NOW, the "found version" is
"Unknown", just
as Marcial is getting.
Hoping very much you can help! Thank you.
"Daniel Reib [MSFT]" wrote:
> Do you know what user you use to connect to the database server? You may
> want to run rsconfig.exe to set the user to a specific user. You would then
> need to manually add that user to each RSExecRole. There are four roles, on
> in each of the following DB:
> ReportServer
> ReportServerTempDB
> Master
> Msdb
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Marcial" <no_spam@.antispammer.com> wrote in message
> news:BC3682DA-89F6-41F4-9B29-98E63EC203D1@.microsoft.com...
> > Ok... I have verified that the dbo is the owner or the Stored Procedures
> > in
> > both the
> > ReportServer and ReportServerTembDB. There is also an RSExecute Role which
> > currently contains no users.
> > could this be the cause of the error?
> >
> > I also need to metion that I had installed SQL SERVER SP4 beta.
> > Could this be cause problems with Reporting Services'
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> If you go to enterprise manager, find the reportserver database and look
> >> at
> >> it's SPs. Who is the owner of the SPs?
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Marcial" <no_spam@.antispammer.com> wrote in message
> >> news:2759A2F2-7BE6-4C43-9745-3ADCEE9B4AF8@.microsoft.com...
> >> > Thanks Daniel, could you be a bit morer specific on how to ensure SPs
> >> > in
> >> > dbo
> >> > namespace!
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> Make sure that all of your SPs are in the dbo namespace.
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "Marcial" <no_spam@.antispammer.com> wrote in message
> >> >> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
> >> >> > Help!!!
> >> >> >
> >> >> > After applying SP2 beta to my Test Server I get the following
> >> >> > message
> >> >> > when
> >> >> > launching the Report Manager:
> >> >> >
> >> >> > "The version of the report server database is either in a format
> >> >> > that
> >> >> > is
> >> >> > not
> >> >> > valid, or it cannot be read. The found version is 'Unknown'. The
> >> >> > expected
> >> >> > version is 'C.0.6.54'. To continue, update the version of the report
> >> >> > server
> >> >> > database and verify access rights. (rsInvalidReportServerDatabase)"
> >> >> >
> >> >> > Get Online Help URL:
> >> >> >
> >> >> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
> >> >> >
> >> >> > I tried following the Get Online Help link instructions without
> >> >> > success.
> >> >> >
> >> >> > I even uninstalled Report Server and re-installed my SP1 version!
> >> >> > Do I need to drop the Report Server Databases before re-installing?
> >> >> >
> >> >> > I have back-up of the orignal tables
> >> >> >
> >> >> > I need to acces some reports that I had created in the test
> >> >> > environment.
> >> >> >
> >> >> > --
> >> >> > Application Engineer / DBA
> >> >> > UCLA SOM
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||You only want to issue rsconfig for the report server database, not for the
temp or any other. RSConfig.exe does NOT update the RSExecRole that is
present in the 4 databases that you mention, you must do this manually.
So, rerun rsconfig.exe, pointing it to ReportServer2000. Then manually add
RSAdmin to the rsexecrole in the 4 databases mentioned below.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"J Noble" <JNoble@.discussions.microsoft.com> wrote in message
news:FB973338-95DA-477D-ADB1-4CD33FF84582@.microsoft.com...
> May I jump in here? I am having a similar problem, but my error
> originally
> differed slightly.
> Instead of "found version 'Unknown'", mine reported "found version
> 'T.0.6.51'. Cause apparently
> due to me using RSCONFIG to try to change the credentials used to connect
> to
> the RS SQL
> Server databases. Commands I issued:
> rsconfig -c -s KCBSGP12 -d ReportServer2000 -a sql -u RSAdmin -p xxxxxx
> rsconfig -c -s KCBSGP12 -d ReportServer2000TempDB -a sql -u RSAdmin -p
> xxxxxx
> RSAdmin was a created as user in ReportServer2000 and
> ReportServer2000TempDB
> with same
> permissions as the original account (an AD account versus SQL account, in
> case that's important).
> Restarted ReportServer service and got the error. Then realized from this
> thread I had missed
> MASTER and MSDB databases, so added RSAdmin user to those as well, then
> issued "rsconfig"
> commands as above for those two databases. NOW, the "found version" is
> "Unknown", just
> as Marcial is getting.
> Hoping very much you can help! Thank you.
>
> "Daniel Reib [MSFT]" wrote:
>> Do you know what user you use to connect to the database server? You may
>> want to run rsconfig.exe to set the user to a specific user. You would
>> then
>> need to manually add that user to each RSExecRole. There are four roles,
>> on
>> in each of the following DB:
>> ReportServer
>> ReportServerTempDB
>> Master
>> Msdb
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Marcial" <no_spam@.antispammer.com> wrote in message
>> news:BC3682DA-89F6-41F4-9B29-98E63EC203D1@.microsoft.com...
>> > Ok... I have verified that the dbo is the owner or the Stored
>> > Procedures
>> > in
>> > both the
>> > ReportServer and ReportServerTembDB. There is also an RSExecute Role
>> > which
>> > currently contains no users.
>> > could this be the cause of the error?
>> >
>> > I also need to metion that I had installed SQL SERVER SP4 beta.
>> > Could this be cause problems with Reporting Services'
>> >
>> > "Daniel Reib [MSFT]" wrote:
>> >
>> >> If you go to enterprise manager, find the reportserver database and
>> >> look
>> >> at
>> >> it's SPs. Who is the owner of the SPs?
>> >>
>> >> --
>> >> -Daniel
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> rights.
>> >>
>> >>
>> >> "Marcial" <no_spam@.antispammer.com> wrote in message
>> >> news:2759A2F2-7BE6-4C43-9745-3ADCEE9B4AF8@.microsoft.com...
>> >> > Thanks Daniel, could you be a bit morer specific on how to ensure
>> >> > SPs
>> >> > in
>> >> > dbo
>> >> > namespace!
>> >> >
>> >> > "Daniel Reib [MSFT]" wrote:
>> >> >
>> >> >> Make sure that all of your SPs are in the dbo namespace.
>> >> >>
>> >> >> --
>> >> >> -Daniel
>> >> >> This posting is provided "AS IS" with no warranties, and confers no
>> >> >> rights.
>> >> >>
>> >> >>
>> >> >> "Marcial" <no_spam@.antispammer.com> wrote in message
>> >> >> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
>> >> >> > Help!!!
>> >> >> >
>> >> >> > After applying SP2 beta to my Test Server I get the following
>> >> >> > message
>> >> >> > when
>> >> >> > launching the Report Manager:
>> >> >> >
>> >> >> > "The version of the report server database is either in a format
>> >> >> > that
>> >> >> > is
>> >> >> > not
>> >> >> > valid, or it cannot be read. The found version is 'Unknown'. The
>> >> >> > expected
>> >> >> > version is 'C.0.6.54'. To continue, update the version of the
>> >> >> > report
>> >> >> > server
>> >> >> > database and verify access rights.
>> >> >> > (rsInvalidReportServerDatabase)"
>> >> >> >
>> >> >> > Get Online Help URL:
>> >> >> >
>> >> >> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
>> >> >> >
>> >> >> > I tried following the Get Online Help link instructions without
>> >> >> > success.
>> >> >> >
>> >> >> > I even uninstalled Report Server and re-installed my SP1 version!
>> >> >> > Do I need to drop the Report Server Databases before
>> >> >> > re-installing?
>> >> >> >
>> >> >> > I have back-up of the orignal tables
>> >> >> >
>> >> >> > I need to acces some reports that I had created in the test
>> >> >> > environment.
>> >> >> >
>> >> >> > --
>> >> >> > Application Engineer / DBA
>> >> >> > UCLA SOM
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Fantastic. Thanks very much.
Bad assumption on my part to initially run RSConfig against both db's. I see
some logic in the reported versions now, though. 'C' being the main db,
'T' being the Temp db, and 'Unknown' referring to Master and Msdb.
"Daniel Reib [MSFT]" wrote:
> You only want to issue rsconfig for the report server database, not for the
> temp or any other. RSConfig.exe does NOT update the RSExecRole that is
> present in the 4 databases that you mention, you must do this manually.
> So, rerun rsconfig.exe, pointing it to ReportServer2000. Then manually add
> RSAdmin to the rsexecrole in the 4 databases mentioned below.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "J Noble" <JNoble@.discussions.microsoft.com> wrote in message
> news:FB973338-95DA-477D-ADB1-4CD33FF84582@.microsoft.com...
> > May I jump in here? I am having a similar problem, but my error
> > originally
> > differed slightly.
> > Instead of "found version 'Unknown'", mine reported "found version
> > 'T.0.6.51'. Cause apparently
> > due to me using RSCONFIG to try to change the credentials used to connect
> > to
> > the RS SQL
> > Server databases. Commands I issued:
> > rsconfig -c -s KCBSGP12 -d ReportServer2000 -a sql -u RSAdmin -p xxxxxx
> > rsconfig -c -s KCBSGP12 -d ReportServer2000TempDB -a sql -u RSAdmin -p
> > xxxxxx
> > RSAdmin was a created as user in ReportServer2000 and
> > ReportServer2000TempDB
> > with same
> > permissions as the original account (an AD account versus SQL account, in
> > case that's important).
> > Restarted ReportServer service and got the error. Then realized from this
> > thread I had missed
> > MASTER and MSDB databases, so added RSAdmin user to those as well, then
> > issued "rsconfig"
> > commands as above for those two databases. NOW, the "found version" is
> > "Unknown", just
> > as Marcial is getting.
> >
> > Hoping very much you can help! Thank you.
> >
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> Do you know what user you use to connect to the database server? You may
> >> want to run rsconfig.exe to set the user to a specific user. You would
> >> then
> >> need to manually add that user to each RSExecRole. There are four roles,
> >> on
> >> in each of the following DB:
> >>
> >> ReportServer
> >> ReportServerTempDB
> >> Master
> >> Msdb
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "Marcial" <no_spam@.antispammer.com> wrote in message
> >> news:BC3682DA-89F6-41F4-9B29-98E63EC203D1@.microsoft.com...
> >> > Ok... I have verified that the dbo is the owner or the Stored
> >> > Procedures
> >> > in
> >> > both the
> >> > ReportServer and ReportServerTembDB. There is also an RSExecute Role
> >> > which
> >> > currently contains no users.
> >> > could this be the cause of the error?
> >> >
> >> > I also need to metion that I had installed SQL SERVER SP4 beta.
> >> > Could this be cause problems with Reporting Services'
> >> >
> >> > "Daniel Reib [MSFT]" wrote:
> >> >
> >> >> If you go to enterprise manager, find the reportserver database and
> >> >> look
> >> >> at
> >> >> it's SPs. Who is the owner of the SPs?
> >> >>
> >> >> --
> >> >> -Daniel
> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> rights.
> >> >>
> >> >>
> >> >> "Marcial" <no_spam@.antispammer.com> wrote in message
> >> >> news:2759A2F2-7BE6-4C43-9745-3ADCEE9B4AF8@.microsoft.com...
> >> >> > Thanks Daniel, could you be a bit morer specific on how to ensure
> >> >> > SPs
> >> >> > in
> >> >> > dbo
> >> >> > namespace!
> >> >> >
> >> >> > "Daniel Reib [MSFT]" wrote:
> >> >> >
> >> >> >> Make sure that all of your SPs are in the dbo namespace.
> >> >> >>
> >> >> >> --
> >> >> >> -Daniel
> >> >> >> This posting is provided "AS IS" with no warranties, and confers no
> >> >> >> rights.
> >> >> >>
> >> >> >>
> >> >> >> "Marcial" <no_spam@.antispammer.com> wrote in message
> >> >> >> news:47A78CC9-CF8F-457B-B45B-91D34EACE1E8@.microsoft.com...
> >> >> >> > Help!!!
> >> >> >> >
> >> >> >> > After applying SP2 beta to my Test Server I get the following
> >> >> >> > message
> >> >> >> > when
> >> >> >> > launching the Report Manager:
> >> >> >> >
> >> >> >> > "The version of the report server database is either in a format
> >> >> >> > that
> >> >> >> > is
> >> >> >> > not
> >> >> >> > valid, or it cannot be read. The found version is 'Unknown'. The
> >> >> >> > expected
> >> >> >> > version is 'C.0.6.54'. To continue, update the version of the
> >> >> >> > report
> >> >> >> > server
> >> >> >> > database and verify access rights.
> >> >> >> > (rsInvalidReportServerDatabase)"
> >> >> >> >
> >> >> >> > Get Online Help URL:
> >> >> >> >
> >> >> >> > http://www.microsoft.com/products/ee/transform.aspx?EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsInvalidReportServerDatabase&ProdName=Microsoft+SQL+Server+Reporting+Services&ProdVer=8.00
> >> >> >> >
> >> >> >> > I tried following the Get Online Help link instructions without
> >> >> >> > success.
> >> >> >> >
> >> >> >> > I even uninstalled Report Server and re-installed my SP1 version!
> >> >> >> > Do I need to drop the Report Server Databases before
> >> >> >> > re-installing?
> >> >> >> >
> >> >> >> > I have back-up of the orignal tables
> >> >> >> >
> >> >> >> > I need to acces some reports that I had created in the test
> >> >> >> > environment.
> >> >> >> >
> >> >> >> > --
> >> >> >> > Application Engineer / DBA
> >> >> >> > UCLA SOM
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>sql

HELP : all records of one table have been deleted!

For a reason that we don't know, one table consisting of about 1200 rows in
SQL Server 2005 Express SP2 shows to be empty at once. Since all records
were addded within this day, there is no suitable back-up of a couple of
hours ago, I don't know a way to restore the records.
1) Is this a known bug of SQL Server 2005 SP2?
1) Is there a way to find out the reason why this happened?
2) Is there a way to restore the deleted rows?
3) How can I prevent this to happen again?
"Oscar" <oku@.xs4all.nl> wrote in message
news:udXxjALcHHA.5052@.TK2MSFTNGP06.phx.gbl...
> For a reason that we don't know, one table consisting of about 1200 rows
> in SQL Server 2005 Express SP2 shows to be empty at once. Since all
> records were addded within this day, there is no suitable back-up of a
> couple of hours ago, I don't know a way to restore the records.
> 1) Is this a known bug of SQL Server 2005 SP2?
Not that I've heard.

> 1) Is there a way to find out the reason why this happened?
Possibly, but may not be entirely worth the effort.

> 2) Is there a way to restore the deleted rows?
MAYBE!
If you are in full-logging and not simple logging, you may be able to do the
following:
I assume you have a full backup from say last night?
Take a Transaction Log backup now. (I'd probably add a NO_TRUNCATE option so
that you don't truncate the log, just in case).
Anyway, do a RESTORE from the full backup to a different database name WITH
NORECOVERY.
Then a RESTORE LOG using the backup you just made and then WITH STOPATMARK =
<time>, STANDBY=filename.
This will restore the log to whatever time you want. The STANDBY will allow
you to put the database into read-only mode while you then do a select on
the table.
If the data is there, you can then select it back into your live database.
If not, do a new RESTORE LOG with an earlier STOPATMARK, etc.
HOWEVER, if you don't have FULL Recovery enabled, you're probably out of
luck.
If you need more help, let me know via email or here.

> 3) How can I prevent this to happen again?
Security.

>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
|||Hi Greg,
I am not that familiar with these items.
a) how can I find whether the configuration is full-logging or simple
logging?
b) what do you mean with 'Take a Transaction Log backup now'? How can I find
this?
c) how can I do a RESTORE LOG?
thanks for your help.
Oscar
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> schreef in
bericht news:%23qklnHLcHHA.4032@.TK2MSFTNGP02.phx.gbl...
> "Oscar" <oku@.xs4all.nl> wrote in message
> news:udXxjALcHHA.5052@.TK2MSFTNGP06.phx.gbl...
> Not that I've heard.
>
> Possibly, but may not be entirely worth the effort.
>
> MAYBE!
> If you are in full-logging and not simple logging, you may be able to do
> the following:
> I assume you have a full backup from say last night?
> Take a Transaction Log backup now. (I'd probably add a NO_TRUNCATE option
> so that you don't truncate the log, just in case).
> Anyway, do a RESTORE from the full backup to a different database name
> WITH NORECOVERY.
> Then a RESTORE LOG using the backup you just made and then WITH STOPATMARK
> = <time>, STANDBY=filename.
> This will restore the log to whatever time you want. The STANDBY will
> allow you to put the database into read-only mode while you then do a
> select on the table.
> If the data is there, you can then select it back into your live database.
> If not, do a new RESTORE LOG with an earlier STOPATMARK, etc.
> HOWEVER, if you don't have FULL Recovery enabled, you're probably out of
> luck.
> If you need more help, let me know via email or here.
>
> Security.
>
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>
|||"Oscar" <oku@.xs4all.nl> wrote in message
news:%23YSytULcHHA.4012@.TK2MSFTNGP03.phx.gbl...
> Hi Greg,
> I am not that familiar with these items.
> a) how can I find whether the configuration is full-logging or simple
> logging?
> b) what do you mean with 'Take a Transaction Log backup now'? How can I
> find this?
> c) how can I do a RESTORE LOG?
> thanks for your help.
> Oscar
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> schreef in
> bericht news:%23qklnHLcHHA.4032@.TK2MSFTNGP02.phx.gbl...
>
|||"Oscar" <oku@.xs4all.nl> wrote in message
news:%23YSytULcHHA.4012@.TK2MSFTNGP03.phx.gbl...
> Hi Greg,
> I am not that familiar with these items.
>
Ok, that'll make this a bit tougher, but let's see what we can do.

> a) how can I find whether the configuration is full-logging or simple
> logging?
Hmm, since you're running Express, you'll have to use SQLCMD to connect to
the database.
So, connect to your database and then type:
SELECT DATABASEPROPERTY('databasename', 'IsTruncLog');
GO
Let me know if this returns a 0 or a 1.
(You want a 0).
If this is 1, then there's very little if anything that can be done.
If it's 0, we might be able to help.

> b) what do you mean with 'Take a Transaction Log backup now'? How can I
> find this?
> c) how can I do a RESTORE LOG?
> thanks for your help.
> Oscar
>

>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
|||Meanwhile I've already started the first step to do a transaction log
backup.
However it shows now '(Restoring)' after the database name instead of the
back up.
It has run for almost an hour now and I don't know how long this will last.
I've also looked into another SQL server where almost the same database
resides for testing purposes.
After typing your selection query it shows one record with two fields. In
the first field it shows a '1' and in the second field it shows a 'NULL'
Oscar
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> schreef in
bericht news:umc6evLcHHA.4012@.TK2MSFTNGP03.phx.gbl...
> "Oscar" <oku@.xs4all.nl> wrote in message
> news:%23YSytULcHHA.4012@.TK2MSFTNGP03.phx.gbl...
> Ok, that'll make this a bit tougher, but let's see what we can do.
>
> Hmm, since you're running Express, you'll have to use SQLCMD to connect to
> the database.
> So, connect to your database and then type:
> SELECT DATABASEPROPERTY('databasename', 'IsTruncLog');
> GO
> Let me know if this returns a 0 or a 1.
> (You want a 0).
> If this is 1, then there's very little if anything that can be done.
> If it's 0, we might be able to help.
>
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>
|||"Oscar" <oku@.xs4all.nl> wrote in message
news:uNfZAOMcHHA.1244@.TK2MSFTNGP04.phx.gbl...
> Meanwhile I've already started the first step to do a transaction log
> backup.
> However it shows now '(Restoring)' after the database name instead of the
> back up.
> It has run for almost an hour now and I don't know how long this will
> last.
> I've also looked into another SQL server where almost the same database
> resides for testing purposes.
> After typing your selection query it shows one record with two fields. In
> the first field it shows a '1' and in the second field it shows a 'NULL'
> Oscar
>
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> schreef in
> bericht news:umc6evLcHHA.4012@.TK2MSFTNGP03.phx.gbl...
>
|||"Oscar" <oku@.xs4all.nl> wrote in message
news:uNfZAOMcHHA.1244@.TK2MSFTNGP04.phx.gbl...
> Meanwhile I've already started the first step to do a transaction log
> backup.
> However it shows now '(Restoring)' after the database name instead of the
> back up.
> It has run for almost an hour now and I don't know how long this will
> last.
> I've also looked into another SQL server where almost the same database
> resides for testing purposes.
> After typing your selection query it shows one record with two fields. In
> the first field it shows a '1' and in the second field it shows a 'NULL'
> Oscar
>
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> schreef in
> bericht news:umc6evLcHHA.4012@.TK2MSFTNGP03.phx.gbl...
>
|||"Oscar" <oku@.xs4all.nl> wrote in message
news:uNfZAOMcHHA.1244@.TK2MSFTNGP04.phx.gbl...
> Meanwhile I've already started the first step to do a transaction log
> backup.
If it's showing a 1, then it's doing SIMPLE RECOVERY mode and the log gets
truncated at each checkpoint so you're probably out of luck.

> However it shows now '(Restoring)' after the database name instead of the
> back up.
Can you type exactly what commands you used.
A BACKUP should NOT in any way change a database name to "restoring" so I
suspect you're doing something else here.

> It has run for almost an hour now and I don't know how long this will
> last.
> I've also looked into another SQL server where almost the same database
> resides for testing purposes.
> After typing your selection query it shows one record with two fields. In
> the first field it shows a '1' and in the second field it shows a 'NULL'
> Oscar
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
|||These are the steps :
Tasks -> Back-up
Configured : Backup type : Transaction Log
Options : Transaction Log : Back up the tail of the log and leave the
database in the restoring state (in order to deselect the option 'Trancate
the transaction log' as you advised me.
Then pressed OK after which is shows now 'Restoring'.
Since the mdf file is about 50 MB and the ldf file is about 23 MB only, I
think the process takes too much time (about three hours now), it could have
been crashed. Task Manager doesn't show any noticeable activity. Can/should
I stop this proces now?
with respect to the logging setting, the results of the query look like the
'1' responds to a record number and the second field is the value we're
looking for and it's 'null'.
Oscar
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> schreef in
bericht news:eQ8B2gMcHHA.1508@.TK2MSFTNGP06.phx.gbl...
> "Oscar" <oku@.xs4all.nl> wrote in message
> news:uNfZAOMcHHA.1244@.TK2MSFTNGP04.phx.gbl...
> If it's showing a 1, then it's doing SIMPLE RECOVERY mode and the log gets
> truncated at each checkpoint so you're probably out of luck.
>
> Can you type exactly what commands you used.
> A BACKUP should NOT in any way change a database name to "restoring" so I
> suspect you're doing something else here.
>
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>

HELP : all records of one table have been deleted!

For a reason that we don't know, one table consisting of about 1200 rows in
SQL Server 2005 Express SP2 shows to be empty at once. Since all records
were addded within this day, there is no suitable back-up of a couple of
hours ago, I don't know a way to restore the records.
1) Is this a known bug of SQL Server 2005 SP2?
1) Is there a way to find out the reason why this happened?
2) Is there a way to restore the deleted rows?
3) How can I prevent this to happen again?"Oscar" <oku@.xs4all.nl> wrote in message
news:udXxjALcHHA.5052@.TK2MSFTNGP06.phx.gbl...
> For a reason that we don't know, one table consisting of about 1200 rows
> in SQL Server 2005 Express SP2 shows to be empty at once. Since all
> records were addded within this day, there is no suitable back-up of a
> couple of hours ago, I don't know a way to restore the records.
> 1) Is this a known bug of SQL Server 2005 SP2?
> 1) Is there a way to find out the reason why this happened?
> 2) Is there a way to restore the deleted rows?
> 3) How can I prevent this to happen again?
>|||"Oscar" <oku@.xs4all.nl> wrote in message
news:udXxjALcHHA.5052@.TK2MSFTNGP06.phx.gbl...
> For a reason that we don't know, one table consisting of about 1200 rows
> in SQL Server 2005 Express SP2 shows to be empty at once. Since all
> records were addded within this day, there is no suitable back-up of a
> couple of hours ago, I don't know a way to restore the records.
> 1) Is this a known bug of SQL Server 2005 SP2?
Not that I've heard.
> 1) Is there a way to find out the reason why this happened?
Possibly, but may not be entirely worth the effort.
> 2) Is there a way to restore the deleted rows?
MAYBE!
If you are in full-logging and not simple logging, you may be able to do the
following:
I assume you have a full backup from say last night?
Take a Transaction Log backup now. (I'd probably add a NO_TRUNCATE option so
that you don't truncate the log, just in case).
Anyway, do a RESTORE from the full backup to a different database name WITH
NORECOVERY.
Then a RESTORE LOG using the backup you just made and then WITH STOPATMARK =<time>, STANDBY=filename.
This will restore the log to whatever time you want. The STANDBY will allow
you to put the database into read-only mode while you then do a select on
the table.
If the data is there, you can then select it back into your live database.
If not, do a new RESTORE LOG with an earlier STOPATMARK, etc.
HOWEVER, if you don't have FULL Recovery enabled, you're probably out of
luck.
If you need more help, let me know via email or here.
> 3) How can I prevent this to happen again?
Security.
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Hi Greg,
I am not that familiar with these items.
a) how can I find whether the configuration is full-logging or simple
logging?
b) what do you mean with 'Take a Transaction Log backup now'? How can I find
this?
c) how can I do a RESTORE LOG?
thanks for your help.
Oscar
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> schreef in
bericht news:%23qklnHLcHHA.4032@.TK2MSFTNGP02.phx.gbl...
> "Oscar" <oku@.xs4all.nl> wrote in message
> news:udXxjALcHHA.5052@.TK2MSFTNGP06.phx.gbl...
>> For a reason that we don't know, one table consisting of about 1200 rows
>> in SQL Server 2005 Express SP2 shows to be empty at once. Since all
>> records were addded within this day, there is no suitable back-up of a
>> couple of hours ago, I don't know a way to restore the records.
>> 1) Is this a known bug of SQL Server 2005 SP2?
> Not that I've heard.
>
>> 1) Is there a way to find out the reason why this happened?
> Possibly, but may not be entirely worth the effort.
>> 2) Is there a way to restore the deleted rows?
> MAYBE!
> If you are in full-logging and not simple logging, you may be able to do
> the following:
> I assume you have a full backup from say last night?
> Take a Transaction Log backup now. (I'd probably add a NO_TRUNCATE option
> so that you don't truncate the log, just in case).
> Anyway, do a RESTORE from the full backup to a different database name
> WITH NORECOVERY.
> Then a RESTORE LOG using the backup you just made and then WITH STOPATMARK
> = <time>, STANDBY=filename.
> This will restore the log to whatever time you want. The STANDBY will
> allow you to put the database into read-only mode while you then do a
> select on the table.
> If the data is there, you can then select it back into your live database.
> If not, do a new RESTORE LOG with an earlier STOPATMARK, etc.
> HOWEVER, if you don't have FULL Recovery enabled, you're probably out of
> luck.
> If you need more help, let me know via email or here.
>> 3) How can I prevent this to happen again?
> Security.
>>
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>|||"Oscar" <oku@.xs4all.nl> wrote in message
news:%23YSytULcHHA.4012@.TK2MSFTNGP03.phx.gbl...
> Hi Greg,
> I am not that familiar with these items.
> a) how can I find whether the configuration is full-logging or simple
> logging?
> b) what do you mean with 'Take a Transaction Log backup now'? How can I
> find this?
> c) how can I do a RESTORE LOG?
> thanks for your help.
> Oscar
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> schreef in
> bericht news:%23qklnHLcHHA.4032@.TK2MSFTNGP02.phx.gbl...
>> "Oscar" <oku@.xs4all.nl> wrote in message
>> news:udXxjALcHHA.5052@.TK2MSFTNGP06.phx.gbl...
>> For a reason that we don't know, one table consisting of about 1200 rows
>> in SQL Server 2005 Express SP2 shows to be empty at once. Since all
>> records were addded within this day, there is no suitable back-up of a
>> couple of hours ago, I don't know a way to restore the records.
>> 1) Is this a known bug of SQL Server 2005 SP2?
>> Not that I've heard.
>>
>> 1) Is there a way to find out the reason why this happened?
>> Possibly, but may not be entirely worth the effort.
>> 2) Is there a way to restore the deleted rows?
>> MAYBE!
>> If you are in full-logging and not simple logging, you may be able to do
>> the following:
>> I assume you have a full backup from say last night?
>> Take a Transaction Log backup now. (I'd probably add a NO_TRUNCATE option
>> so that you don't truncate the log, just in case).
>> Anyway, do a RESTORE from the full backup to a different database name
>> WITH NORECOVERY.
>> Then a RESTORE LOG using the backup you just made and then WITH
>> STOPATMARK = <time>, STANDBY=filename.
>> This will restore the log to whatever time you want. The STANDBY will
>> allow you to put the database into read-only mode while you then do a
>> select on the table.
>> If the data is there, you can then select it back into your live
>> database.
>> If not, do a new RESTORE LOG with an earlier STOPATMARK, etc.
>> HOWEVER, if you don't have FULL Recovery enabled, you're probably out of
>> luck.
>> If you need more help, let me know via email or here.
>> 3) How can I prevent this to happen again?
>> Security.
>>
>>
>>
>> --
>> Greg Moore
>> SQL Server DBA Consulting Remote and Onsite available!
>> Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
>>
>|||"Oscar" <oku@.xs4all.nl> wrote in message
news:%23YSytULcHHA.4012@.TK2MSFTNGP03.phx.gbl...
> Hi Greg,
> I am not that familiar with these items.
>
Ok, that'll make this a bit tougher, but let's see what we can do.
> a) how can I find whether the configuration is full-logging or simple
> logging?
Hmm, since you're running Express, you'll have to use SQLCMD to connect to
the database.
So, connect to your database and then type:
SELECT DATABASEPROPERTY('databasename', 'IsTruncLog');
GO
Let me know if this returns a 0 or a 1.
(You want a 0).
If this is 1, then there's very little if anything that can be done.
If it's 0, we might be able to help.
> b) what do you mean with 'Take a Transaction Log backup now'? How can I
> find this?
> c) how can I do a RESTORE LOG?
> thanks for your help.
> Oscar
>
>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Meanwhile I've already started the first step to do a transaction log
backup.
However it shows now '(Restoring)' after the database name instead of the
back up.
It has run for almost an hour now and I don't know how long this will last.
I've also looked into another SQL server where almost the same database
resides for testing purposes.
After typing your selection query it shows one record with two fields. In
the first field it shows a '1' and in the second field it shows a 'NULL'
Oscar
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> schreef in
bericht news:umc6evLcHHA.4012@.TK2MSFTNGP03.phx.gbl...
> "Oscar" <oku@.xs4all.nl> wrote in message
> news:%23YSytULcHHA.4012@.TK2MSFTNGP03.phx.gbl...
>> Hi Greg,
>> I am not that familiar with these items.
> Ok, that'll make this a bit tougher, but let's see what we can do.
>
>> a) how can I find whether the configuration is full-logging or simple
>> logging?
> Hmm, since you're running Express, you'll have to use SQLCMD to connect to
> the database.
> So, connect to your database and then type:
> SELECT DATABASEPROPERTY('databasename', 'IsTruncLog');
> GO
> Let me know if this returns a 0 or a 1.
> (You want a 0).
> If this is 1, then there's very little if anything that can be done.
> If it's 0, we might be able to help.
>
>> b) what do you mean with 'Take a Transaction Log backup now'? How can I
>> find this?
>> c) how can I do a RESTORE LOG?
>> thanks for your help.
>> Oscar
>>
>>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>|||"Oscar" <oku@.xs4all.nl> wrote in message
news:uNfZAOMcHHA.1244@.TK2MSFTNGP04.phx.gbl...
> Meanwhile I've already started the first step to do a transaction log
> backup.
> However it shows now '(Restoring)' after the database name instead of the
> back up.
> It has run for almost an hour now and I don't know how long this will
> last.
> I've also looked into another SQL server where almost the same database
> resides for testing purposes.
> After typing your selection query it shows one record with two fields. In
> the first field it shows a '1' and in the second field it shows a 'NULL'
> Oscar
>
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> schreef in
> bericht news:umc6evLcHHA.4012@.TK2MSFTNGP03.phx.gbl...
>> "Oscar" <oku@.xs4all.nl> wrote in message
>> news:%23YSytULcHHA.4012@.TK2MSFTNGP03.phx.gbl...
>> Hi Greg,
>> I am not that familiar with these items.
>>
>> Ok, that'll make this a bit tougher, but let's see what we can do.
>>
>> a) how can I find whether the configuration is full-logging or simple
>> logging?
>> Hmm, since you're running Express, you'll have to use SQLCMD to connect
>> to the database.
>> So, connect to your database and then type:
>> SELECT DATABASEPROPERTY('databasename', 'IsTruncLog');
>> GO
>> Let me know if this returns a 0 or a 1.
>> (You want a 0).
>> If this is 1, then there's very little if anything that can be done.
>> If it's 0, we might be able to help.
>>
>> b) what do you mean with 'Take a Transaction Log backup now'? How can I
>> find this?
>> c) how can I do a RESTORE LOG?
>> thanks for your help.
>> Oscar
>>
>>
>> --
>> Greg Moore
>> SQL Server DBA Consulting Remote and Onsite available!
>> Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
>>
>|||"Oscar" <oku@.xs4all.nl> wrote in message
news:uNfZAOMcHHA.1244@.TK2MSFTNGP04.phx.gbl...
> Meanwhile I've already started the first step to do a transaction log
> backup.
> However it shows now '(Restoring)' after the database name instead of the
> back up.
> It has run for almost an hour now and I don't know how long this will
> last.
> I've also looked into another SQL server where almost the same database
> resides for testing purposes.
> After typing your selection query it shows one record with two fields. In
> the first field it shows a '1' and in the second field it shows a 'NULL'
> Oscar
>
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> schreef in
> bericht news:umc6evLcHHA.4012@.TK2MSFTNGP03.phx.gbl...
>> "Oscar" <oku@.xs4all.nl> wrote in message
>> news:%23YSytULcHHA.4012@.TK2MSFTNGP03.phx.gbl...
>> Hi Greg,
>> I am not that familiar with these items.
>>
>> Ok, that'll make this a bit tougher, but let's see what we can do.
>>
>> a) how can I find whether the configuration is full-logging or simple
>> logging?
>> Hmm, since you're running Express, you'll have to use SQLCMD to connect
>> to the database.
>> So, connect to your database and then type:
>> SELECT DATABASEPROPERTY('databasename', 'IsTruncLog');
>> GO
>> Let me know if this returns a 0 or a 1.
>> (You want a 0).
>> If this is 1, then there's very little if anything that can be done.
>> If it's 0, we might be able to help.
>>
>> b) what do you mean with 'Take a Transaction Log backup now'? How can I
>> find this?
>> c) how can I do a RESTORE LOG?
>> thanks for your help.
>> Oscar
>>
>>
>> --
>> Greg Moore
>> SQL Server DBA Consulting Remote and Onsite available!
>> Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
>>
>|||"Oscar" <oku@.xs4all.nl> wrote in message
news:uNfZAOMcHHA.1244@.TK2MSFTNGP04.phx.gbl...
> Meanwhile I've already started the first step to do a transaction log
> backup.
If it's showing a 1, then it's doing SIMPLE RECOVERY mode and the log gets
truncated at each checkpoint so you're probably out of luck.
> However it shows now '(Restoring)' after the database name instead of the
> back up.
Can you type exactly what commands you used.
A BACKUP should NOT in any way change a database name to "restoring" so I
suspect you're doing something else here.
> It has run for almost an hour now and I don't know how long this will
> last.
> I've also looked into another SQL server where almost the same database
> resides for testing purposes.
> After typing your selection query it shows one record with two fields. In
> the first field it shows a '1' and in the second field it shows a 'NULL'
> Oscar
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||These are the steps :
Tasks -> Back-up
Configured : Backup type : Transaction Log
Options : Transaction Log : Back up the tail of the log and leave the
database in the restoring state (in order to deselect the option 'Trancate
the transaction log' as you advised me.
Then pressed OK after which is shows now 'Restoring'.
Since the mdf file is about 50 MB and the ldf file is about 23 MB only, I
think the process takes too much time (about three hours now), it could have
been crashed. Task Manager doesn't show any noticeable activity. Can/should
I stop this proces now?
with respect to the logging setting, the results of the query look like the
'1' responds to a record number and the second field is the value we're
looking for and it's 'null'.
Oscar
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> schreef in
bericht news:eQ8B2gMcHHA.1508@.TK2MSFTNGP06.phx.gbl...
> "Oscar" <oku@.xs4all.nl> wrote in message
> news:uNfZAOMcHHA.1244@.TK2MSFTNGP04.phx.gbl...
>> Meanwhile I've already started the first step to do a transaction log
>> backup.
> If it's showing a 1, then it's doing SIMPLE RECOVERY mode and the log gets
> truncated at each checkpoint so you're probably out of luck.
>
>> However it shows now '(Restoring)' after the database name instead of the
>> back up.
> Can you type exactly what commands you used.
> A BACKUP should NOT in any way change a database name to "restoring" so I
> suspect you're doing something else here.
>
>> It has run for almost an hour now and I don't know how long this will
>> last.
>> I've also looked into another SQL server where almost the same database
>> resides for testing purposes.
>> After typing your selection query it shows one record with two fields. In
>> the first field it shows a '1' and in the second field it shows a 'NULL'
>> Oscar
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>|||"Oscar" <oku@.xs4all.nl> wrote in message
news:OY2Xv6McHHA.4488@.TK2MSFTNGP03.phx.gbl...
> These are the steps :
> Tasks -> Back-up
> Configured : Backup type : Transaction Log
> Options : Transaction Log : Back up the tail of the log and leave the
> database in the restoring state (in order to deselect the option 'Trancate
> the transaction log' as you advised me.
> Then pressed OK after which is shows now 'Restoring'.
> Since the mdf file is about 50 MB and the ldf file is about 23 MB only, I
> think the process takes too much time (about three hours now), it could
> have been crashed. Task Manager doesn't show any noticeable activity.
> Can/should I stop this proces now?
Ok. Sounds like you're using the GUI. In cases like this I REALLY REALLY
recommend you don't and you execute the commands by hand. I'm not 100% sure
what GUI is doing under the covers. (Though I was able to replicate what you
did with the GUI and cause the same issue. And telling it to generate the
script, I can see what it was doing.)
Anyway, my guess is it completed the backup and you've covered the dialog
box with the OK button. It should take only a minute or two to do that
backup (or error out if it can't.)
> with respect to the logging setting, the results of the query look like
> the '1' responds to a record number and the second field is the value
> we're looking for and it's 'null'.
I'm not sure why you're getting two columns. You should be getting one.
Anyway, before we go further, did you have an existing full backup from last
night (or rather, what is your last full backup?)
> Oscar
>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Hi Greg,
my last full back up is of 2 days ago.
Any idea how I can stop or kill the (Restoring)?
Oscar
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> schreef in
bericht news:OwwZnONcHHA.4216@.TK2MSFTNGP02.phx.gbl...
> "Oscar" <oku@.xs4all.nl> wrote in message
> news:OY2Xv6McHHA.4488@.TK2MSFTNGP03.phx.gbl...
>> These are the steps :
>> Tasks -> Back-up
>> Configured : Backup type : Transaction Log
>> Options : Transaction Log : Back up the tail of the log and leave the
>> database in the restoring state (in order to deselect the option
>> 'Trancate the transaction log' as you advised me.
>> Then pressed OK after which is shows now 'Restoring'.
>> Since the mdf file is about 50 MB and the ldf file is about 23 MB only, I
>> think the process takes too much time (about three hours now), it could
>> have been crashed. Task Manager doesn't show any noticeable activity.
>> Can/should I stop this proces now?
> Ok. Sounds like you're using the GUI. In cases like this I REALLY REALLY
> recommend you don't and you execute the commands by hand. I'm not 100%
> sure what GUI is doing under the covers. (Though I was able to replicate
> what you did with the GUI and cause the same issue. And telling it to
> generate the script, I can see what it was doing.)
> Anyway, my guess is it completed the backup and you've covered the dialog
> box with the OK button. It should take only a minute or two to do that
> backup (or error out if it can't.)
>
>> with respect to the logging setting, the results of the query look like
>> the '1' responds to a record number and the second field is the value
>> we're looking for and it's 'null'.
> I'm not sure why you're getting two columns. You should be getting one.
> Anyway, before we go further, did you have an existing full backup from
> last night (or rather, what is your last full backup?)
>
>
>> Oscar
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>|||"Oscar" <oku@.xs4all.nl> wrote in message
news:e1kYIhNcHHA.4656@.TK2MSFTNGP06.phx.gbl...
> Hi Greg,
> my last full back up is of 2 days ago.
> Any idea how I can stop or kill the (Restoring)?
> Oscar
>
Can you email me at mooregr (at) greenms.com We can probably do this faster
off line.
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

HELP : all records of one table have been deleted!

For a reason that we don't know, one table consisting of about 1200 rows in
SQL Server 2005 Express SP2 shows to be empty at once. Since all records
were addded within this day, there is no suitable back-up of a couple of
hours ago, I don't know a way to restore the records.
1) Is this a known bug of SQL Server 2005 SP2?
1) Is there a way to find out the reason why this happened?
2) Is there a way to restore the deleted rows?
3) How can I prevent this to happen again?"Oscar" <oku@.xs4all.nl> wrote in message
news:udXxjALcHHA.5052@.TK2MSFTNGP06.phx.gbl...
> For a reason that we don't know, one table consisting of about 1200 rows
> in SQL Server 2005 Express SP2 shows to be empty at once. Since all
> records were addded within this day, there is no suitable back-up of a
> couple of hours ago, I don't know a way to restore the records.
> 1) Is this a known bug of SQL Server 2005 SP2?
Not that I've heard.

> 1) Is there a way to find out the reason why this happened?
Possibly, but may not be entirely worth the effort.

> 2) Is there a way to restore the deleted rows?
MAYBE!
If you are in full-logging and not simple logging, you may be able to do the
following:
I assume you have a full backup from say last night?
Take a Transaction Log backup now. (I'd probably add a NO_TRUNCATE option so
that you don't truncate the log, just in case).
Anyway, do a RESTORE from the full backup to a different database name WITH
NORECOVERY.
Then a RESTORE LOG using the backup you just made and then WITH STOPATMARK =
<time>, STANDBY=filename.
This will restore the log to whatever time you want. The STANDBY will allow
you to put the database into read-only mode while you then do a select on
the table.
If the data is there, you can then select it back into your live database.
If not, do a new RESTORE LOG with an earlier STOPATMARK, etc.
HOWEVER, if you don't have FULL Recovery enabled, you're probably out of
luck.
If you need more help, let me know via email or here.

> 3) How can I prevent this to happen again?
Security.

>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Hi Greg,
I am not that familiar with these items.
a) how can I find whether the configuration is full-logging or simple
logging?
b) what do you mean with 'Take a Transaction Log backup now'? How can I find
this?
c) how can I do a RESTORE LOG?
thanks for your help.
Oscar
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> schreef in
bericht news:%23qklnHLcHHA.4032@.TK2MSFTNGP02.phx.gbl...
> "Oscar" <oku@.xs4all.nl> wrote in message
> news:udXxjALcHHA.5052@.TK2MSFTNGP06.phx.gbl...
> Not that I've heard.
>
> Possibly, but may not be entirely worth the effort.
>
> MAYBE!
> If you are in full-logging and not simple logging, you may be able to do
> the following:
> I assume you have a full backup from say last night?
> Take a Transaction Log backup now. (I'd probably add a NO_TRUNCATE option
> so that you don't truncate the log, just in case).
> Anyway, do a RESTORE from the full backup to a different database name
> WITH NORECOVERY.
> Then a RESTORE LOG using the backup you just made and then WITH STOPATMARK
> = <time>, STANDBY=filename.
> This will restore the log to whatever time you want. The STANDBY will
> allow you to put the database into read-only mode while you then do a
> select on the table.
> If the data is there, you can then select it back into your live database.
> If not, do a new RESTORE LOG with an earlier STOPATMARK, etc.
> HOWEVER, if you don't have FULL Recovery enabled, you're probably out of
> luck.
> If you need more help, let me know via email or here.
>
> Security.
>
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>|||"Oscar" <oku@.xs4all.nl> wrote in message
news:%23YSytULcHHA.4012@.TK2MSFTNGP03.phx.gbl...
> Hi Greg,
> I am not that familiar with these items.
> a) how can I find whether the configuration is full-logging or simple
> logging?
> b) what do you mean with 'Take a Transaction Log backup now'? How can I
> find this?
> c) how can I do a RESTORE LOG?
> thanks for your help.
> Oscar
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> schreef in
> bericht news:%23qklnHLcHHA.4032@.TK2MSFTNGP02.phx.gbl...
>|||"Oscar" <oku@.xs4all.nl> wrote in message
news:%23YSytULcHHA.4012@.TK2MSFTNGP03.phx.gbl...
> Hi Greg,
> I am not that familiar with these items.
>
Ok, that'll make this a bit tougher, but let's see what we can do.

> a) how can I find whether the configuration is full-logging or simple
> logging?
Hmm, since you're running Express, you'll have to use SQLCMD to connect to
the database.
So, connect to your database and then type:
SELECT DATABASEPROPERTY('databasename', 'IsTruncLog');
GO
Let me know if this returns a 0 or a 1.
(You want a 0).
If this is 1, then there's very little if anything that can be done.
If it's 0, we might be able to help.

> b) what do you mean with 'Take a Transaction Log backup now'? How can I
> find this?
> c) how can I do a RESTORE LOG?
> thanks for your help.
> Oscar
>

>
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Meanwhile I've already started the first step to do a transaction log
backup.
However it shows now '(Restoring)' after the database name instead of the
back up.
It has run for almost an hour now and I don't know how long this will last.
I've also looked into another SQL server where almost the same database
resides for testing purposes.
After typing your selection query it shows one record with two fields. In
the first field it shows a '1' and in the second field it shows a 'NULL'
Oscar
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> schreef in
bericht news:umc6evLcHHA.4012@.TK2MSFTNGP03.phx.gbl...
> "Oscar" <oku@.xs4all.nl> wrote in message
> news:%23YSytULcHHA.4012@.TK2MSFTNGP03.phx.gbl...
> Ok, that'll make this a bit tougher, but let's see what we can do.
>
> Hmm, since you're running Express, you'll have to use SQLCMD to connect to
> the database.
> So, connect to your database and then type:
> SELECT DATABASEPROPERTY('databasename', 'IsTruncLog');
> GO
> Let me know if this returns a 0 or a 1.
> (You want a 0).
> If this is 1, then there's very little if anything that can be done.
> If it's 0, we might be able to help.
>
>
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>|||"Oscar" <oku@.xs4all.nl> wrote in message
news:uNfZAOMcHHA.1244@.TK2MSFTNGP04.phx.gbl...
> Meanwhile I've already started the first step to do a transaction log
> backup.
> However it shows now '(Restoring)' after the database name instead of the
> back up.
> It has run for almost an hour now and I don't know how long this will
> last.
> I've also looked into another SQL server where almost the same database
> resides for testing purposes.
> After typing your selection query it shows one record with two fields. In
> the first field it shows a '1' and in the second field it shows a 'NULL'
> Oscar
>
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> schreef in
> bericht news:umc6evLcHHA.4012@.TK2MSFTNGP03.phx.gbl...
>|||"Oscar" <oku@.xs4all.nl> wrote in message
news:uNfZAOMcHHA.1244@.TK2MSFTNGP04.phx.gbl...
> Meanwhile I've already started the first step to do a transaction log
> backup.
> However it shows now '(Restoring)' after the database name instead of the
> back up.
> It has run for almost an hour now and I don't know how long this will
> last.
> I've also looked into another SQL server where almost the same database
> resides for testing purposes.
> After typing your selection query it shows one record with two fields. In
> the first field it shows a '1' and in the second field it shows a 'NULL'
> Oscar
>
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> schreef in
> bericht news:umc6evLcHHA.4012@.TK2MSFTNGP03.phx.gbl...
>|||"Oscar" <oku@.xs4all.nl> wrote in message
news:uNfZAOMcHHA.1244@.TK2MSFTNGP04.phx.gbl...
> Meanwhile I've already started the first step to do a transaction log
> backup.
If it's showing a 1, then it's doing SIMPLE RECOVERY mode and the log gets
truncated at each checkpoint so you're probably out of luck.

> However it shows now '(Restoring)' after the database name instead of the
> back up.
Can you type exactly what commands you used.
A BACKUP should NOT in any way change a database name to "restoring" so I
suspect you're doing something else here.

> It has run for almost an hour now and I don't know how long this will
> last.
> I've also looked into another SQL server where almost the same database
> resides for testing purposes.
> After typing your selection query it shows one record with two fields. In
> the first field it shows a '1' and in the second field it shows a 'NULL'
> Oscar
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||These are the steps :
Tasks -> Back-up
Configured : Backup type : Transaction Log
Options : Transaction Log : Back up the tail of the log and leave the
database in the restoring state (in order to deselect the option 'Trancate
the transaction log' as you advised me.
Then pressed OK after which is shows now 'Restoring'.
Since the mdf file is about 50 MB and the ldf file is about 23 MB only, I
think the process takes too much time (about three hours now), it could have
been crashed. Task Manager doesn't show any noticeable activity. Can/should
I stop this proces now?
with respect to the logging setting, the results of the query look like the
'1' responds to a record number and the second field is the value we're
looking for and it's 'null'.
Oscar
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> schreef in
bericht news:eQ8B2gMcHHA.1508@.TK2MSFTNGP06.phx.gbl...
> "Oscar" <oku@.xs4all.nl> wrote in message
> news:uNfZAOMcHHA.1244@.TK2MSFTNGP04.phx.gbl...
> If it's showing a 1, then it's doing SIMPLE RECOVERY mode and the log gets
> truncated at each checkpoint so you're probably out of luck.
>
> Can you type exactly what commands you used.
> A BACKUP should NOT in any way change a database name to "restoring" so I
> suspect you're doing something else here.
>
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>

Help - DTS package crashing with broken connection?

All,
Windows XP SP2 + hotfixes
SQL Server 2000 SP3
Has anybody seen this one? And is there a fix/workaround for it?
I have a DTS package that loads data in from CSV formatted flat files. The
package executes Ok for two small tables however it crashes about 10,000
records into a transformation task which is loading a flat file of 230,000+
records. Here's the error:
Step 'DTSStep_DTSDataPumpTask_3' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Step Error Description:The number of failing rows exceeds the maximum
specified. (Microsoft OLE DB Provider for SQL Server (80004005): The
statement has been terminated.) (Microsoft OLE DB Provider for SQL Server
(80004005): Cannot insert duplicate key row in object 'Staff' with unique
index 'IX_StaffUserName'.)
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0
Step Execution Started: 9/9/2005 3:41:52 PM
Step Execution Completed: 9/9/2005 3:42:07 PM
Total Step Execution Time: 15.391 seconds
Progress count in Step: 42000
The task runs a VBScript and has 1 Lookup - a check to see if a row exists
before inserting. The Lookup is using the same connection as the Load {whic
h
I read is not good} but it must do so because the existence check is against
the table being loaded and loaded rows are not visible to other
connections...
Any ideas how I can a) circumvent this issue or b) allow load processing to
'quietly' fail on duplicate inserts but run to completion anyway?Look like you got a duplicate key problem when inserting data into Staff
table, violation against index IX_StaffUserName. Clean out your data before
import doing the import again or import those data into a staging table with
no restriction and then clean out your data before import to the main table.
Q
"Richard" wrote:

> All,
> Windows XP SP2 + hotfixes
> SQL Server 2000 SP3
> Has anybody seen this one? And is there a fix/workaround for it?
> I have a DTS package that loads data in from CSV formatted flat files. Th
e
> package executes Ok for two small tables however it crashes about 10,000
> records into a transformation task which is loading a flat file of 230,000
+
> records. Here's the error:
> Step 'DTSStep_DTSDataPumpTask_3' failed
> Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
> Step Error Description:The number of failing rows exceeds the maximum
> specified. (Microsoft OLE DB Provider for SQL Server (80004005): The
> statement has been terminated.) (Microsoft OLE DB Provider for SQL Server
> (80004005): Cannot insert duplicate key row in object 'Staff' with unique
> index 'IX_StaffUserName'.)
> Step Error code: 8004206A
> Step Error Help File:sqldts80.hlp
> Step Error Help Context ID:0
> Step Execution Started: 9/9/2005 3:41:52 PM
> Step Execution Completed: 9/9/2005 3:42:07 PM
> Total Step Execution Time: 15.391 seconds
> Progress count in Step: 42000
> The task runs a VBScript and has 1 Lookup - a check to see if a row exists
> before inserting. The Lookup is using the same connection as the Load {wh
ich
> I read is not good} but it must do so because the existence check is again
st
> the table being loaded and loaded rows are not visible to other
> connections...
> Any ideas how I can a) circumvent this issue or b) allow load processing t
o
> 'quietly' fail on duplicate inserts but run to completion anyway?
>
>|||I think this response from Louis was meanbt for you.
Chekc this KB article for the explanation:
http://support.microsoft.com/defaul...kb;en-us;329329
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:5A302543-FB5F-484B-9E7D-06943BEACC04@.microsoft.com...
> All,
> Windows XP SP2 + hotfixes
> SQL Server 2000 SP3
> Has anybody seen this one? And is there a fix/workaround for it?
> I have a DTS package that loads data in from CSV formatted flat files.
The
> package executes Ok for two small tables however it crashes about 10,000
> records into a transformation task which is loading a flat file of
230,000+
> records. Here's the error:
> Step 'DTSStep_DTSDataPumpTask_3' failed
> Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
> Step Error Description:The number of failing rows exceeds the maximum
> specified. (Microsoft OLE DB Provider for SQL Server (80004005): The
> statement has been terminated.) (Microsoft OLE DB Provider for SQL Server
> (80004005): Cannot insert duplicate key row in object 'Staff' with unique
> index 'IX_StaffUserName'.)
> Step Error code: 8004206A
> Step Error Help File:sqldts80.hlp
> Step Error Help Context ID:0
> Step Execution Started: 9/9/2005 3:41:52 PM
> Step Execution Completed: 9/9/2005 3:42:07 PM
> Total Step Execution Time: 15.391 seconds
> Progress count in Step: 42000
> The task runs a VBScript and has 1 Lookup - a check to see if a row exists
> before inserting. The Lookup is using the same connection as the Load
{which
> I read is not good} but it must do so because the existence check is
against
> the table being loaded and loaded rows are not visible to other
> connections...
> Any ideas how I can a) circumvent this issue or b) allow load processing
to
> 'quietly' fail on duplicate inserts but run to completion anyway?
>
>