Please any one can help me ?I have multiuser application ( VB 6.0 ) on SQL Server 2000 running.
Last night my Sql Server was writting info on the Log file of one database when the power accidentally shut down. In fact, the server was executing one Microsoft Data Transformation Service ( DTS ) which transfers data from one table to another.
This morning when the users tried to work with this database everything went wrong... I've not been able to attach MDF AND LDF files to SQL Server 2000 Desktop Engine.
Looking for what happened I found those Info/Error LOG events:
A)Starting up database 'pcserveis'.
B)ex_raise2: Exception raised, major=34, minor=48, severity=21, attempting to create symptom dump
C) "The transaction ( Process Id 5 ) was left in "interblockade" in Lock
resources with another process and was chosen as subject of the "interblockade". Execute the transaction again." ( Sorry about wrong words , i'm using a translation tool from spanish )
D) Could not undo log record (5019077:221:133), for transaction ID (0:15254626), on page (1:1917), database 'pcserveis' (database ID 11). Page information: LSN = (5019072:426:5), type = 1. Log information: OpCode = 2, context 1.. ( Error: 3448, Severity: 21, State: 1)
E)Error while undoing logged operation in database 'pcserveis'. Error at log record ID (5019077:221:133).. (Error: 9004, Severity: 23, State: 7)
F)An error occurred while processing the log for database 'pcserveis'..
What can i do to restore my database? ThanksYou log file is toasted because of the power outage. Create a new log file and attach it to you database. But all transactions in th log file cannot be recovered. The other choice you have is to restore the database from the backup file and reprocess everything, assuming you have a good backup.|||Obviously, this morning when the users noticed me the problem , i've restored last backup and they kept on working.
My request was about if could be possible to repair the database more than a problem of losing data.
Is there any solution or the only thing to do is to restore the last backUp?|||You will only lose the uncommitted data if you rebuild the log file. That is probably you best bet for not losing the data between the time the database crushed and the last backup run in this situation.|||Thanks for your assistance.
Showing posts with label critical. Show all posts
Showing posts with label critical. Show all posts
Wednesday, March 28, 2012
Friday, March 23, 2012
Please fix the post-SP1 excel export issue
Though it has been well-documented in the community since SP1 was released, I'd like to reiterate that many of us are having critical issues related to element hiding and excel export.
I, for one, have built a highly dynamic reporting system that relies heavily on the use visibility for showing/hiding subreports. My users require export to excel.
The question to Microsoft is: Can you fix this issue that was introduced in SP1? Please provide us with an SP1a update that will allow elements to be hidden & thus NOT show up in the excel export...just as it works in the HTML & PDF renderings.
Regards,
Todd SmartIt may be too much work to "re-tool", but have you considered DTS services?
However, I too, am waiting for a fix on Excel exporting!
-KB
"Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
news:5430232F-211C-439A-A4B0-F644AA68B740@.microsoft.com...
> Though it has been well-documented in the community since SP1 was
released, I'd like to reiterate that many of us are having critical issues
related to element hiding and excel export.
> I, for one, have built a highly dynamic reporting system that relies
heavily on the use visibility for showing/hiding subreports. My users
require export to excel.
> The question to Microsoft is: Can you fix this issue that was introduced
in SP1? Please provide us with an SP1a update that will allow elements to
be hidden & thus NOT show up in the excel export...just as it works in the
HTML & PDF renderings.
>
> Regards,
> Todd Smart|||I'm not sure what you want us to do. You would rather have items that are
hidden and can never be toggled?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
news:5430232F-211C-439A-A4B0-F644AA68B740@.microsoft.com...
> Though it has been well-documented in the community since SP1 was
> released, I'd like to reiterate that many of us are having critical issues
> related to element hiding and excel export.
> I, for one, have built a highly dynamic reporting system that relies
> heavily on the use visibility for showing/hiding subreports. My users
> require export to excel.
> The question to Microsoft is: Can you fix this issue that was introduced
> in SP1? Please provide us with an SP1a update that will allow elements to
> be hidden & thus NOT show up in the excel export...just as it works in the
> HTML & PDF renderings.
>
> Regards,
> Todd Smart|||Hi Brian,
If I have a subreport (or any other element for that matter) that is hidden due to an expression result of [True], that subreport should not be rendered in the Excel export. It should not even have an Excel cell associated with it.
In other words, I would want the render of Excel to work just like the HTML & PDF render works...and how it worked prior to SP1.
Regards,
Todd
"Brian Welcker [MSFT]" wrote:
> I'm not sure what you want us to do. You would rather have items that are
> hidden and can never be toggled?
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
> news:5430232F-211C-439A-A4B0-F644AA68B740@.microsoft.com...
> > Though it has been well-documented in the community since SP1 was
> > released, I'd like to reiterate that many of us are having critical issues
> > related to element hiding and excel export.
> >
> > I, for one, have built a highly dynamic reporting system that relies
> > heavily on the use visibility for showing/hiding subreports. My users
> > require export to excel.
> >
> > The question to Microsoft is: Can you fix this issue that was introduced
> > in SP1? Please provide us with an SP1a update that will allow elements to
> > be hidden & thus NOT show up in the excel export...just as it works in the
> > HTML & PDF renderings.
> >
> >
> > Regards,
> >
> > Todd Smart
>
>|||OK, we'll take a look at this and if it is a regression, we will fix it in
SP2.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
news:423C4612-1C70-4178-9DCA-321019F859E0@.microsoft.com...
> Hi Brian,
> If I have a subreport (or any other element for that matter) that is
> hidden due to an expression result of [True], that subreport should not be
> rendered in the Excel export. It should not even have an Excel cell
> associated with it.
> In other words, I would want the render of Excel to work just like the
> HTML & PDF render works...and how it worked prior to SP1.
>
> Regards,
> Todd
> "Brian Welcker [MSFT]" wrote:
>> I'm not sure what you want us to do. You would rather have items that are
>> hidden and can never be toggled?
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
>> news:5430232F-211C-439A-A4B0-F644AA68B740@.microsoft.com...
>> > Though it has been well-documented in the community since SP1 was
>> > released, I'd like to reiterate that many of us are having critical
>> > issues
>> > related to element hiding and excel export.
>> >
>> > I, for one, have built a highly dynamic reporting system that relies
>> > heavily on the use visibility for showing/hiding subreports. My users
>> > require export to excel.
>> >
>> > The question to Microsoft is: Can you fix this issue that was
>> > introduced
>> > in SP1? Please provide us with an SP1a update that will allow elements
>> > to
>> > be hidden & thus NOT show up in the excel export...just as it works in
>> > the
>> > HTML & PDF renderings.
>> >
>> >
>> > Regards,
>> >
>> > Todd Smart
>>|||Brian, are there any work arounds ? I am also finding that visible tables are
not being displayed in the export to excel, and the start of the table data
appears several rows down (80 rows) .
Regards
Stuart
"Brian Welcker [MSFT]" wrote:
> OK, we'll take a look at this and if it is a regression, we will fix it in
> SP2.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
> news:423C4612-1C70-4178-9DCA-321019F859E0@.microsoft.com...
> > Hi Brian,
> >
> > If I have a subreport (or any other element for that matter) that is
> > hidden due to an expression result of [True], that subreport should not be
> > rendered in the Excel export. It should not even have an Excel cell
> > associated with it.
> >
> > In other words, I would want the render of Excel to work just like the
> > HTML & PDF render works...and how it worked prior to SP1.
> >
> >
> > Regards,
> >
> > Todd
> >
> > "Brian Welcker [MSFT]" wrote:
> >
> >> I'm not sure what you want us to do. You would rather have items that are
> >> hidden and can never be toggled?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
> >> news:5430232F-211C-439A-A4B0-F644AA68B740@.microsoft.com...
> >> > Though it has been well-documented in the community since SP1 was
> >> > released, I'd like to reiterate that many of us are having critical
> >> > issues
> >> > related to element hiding and excel export.
> >> >
> >> > I, for one, have built a highly dynamic reporting system that relies
> >> > heavily on the use visibility for showing/hiding subreports. My users
> >> > require export to excel.
> >> >
> >> > The question to Microsoft is: Can you fix this issue that was
> >> > introduced
> >> > in SP1? Please provide us with an SP1a update that will allow elements
> >> > to
> >> > be hidden & thus NOT show up in the excel export...just as it works in
> >> > the
> >> > HTML & PDF renderings.
> >> >
> >> >
> >> > Regards,
> >> >
> >> > Todd Smart
> >>
> >>
> >>
>
>
I, for one, have built a highly dynamic reporting system that relies heavily on the use visibility for showing/hiding subreports. My users require export to excel.
The question to Microsoft is: Can you fix this issue that was introduced in SP1? Please provide us with an SP1a update that will allow elements to be hidden & thus NOT show up in the excel export...just as it works in the HTML & PDF renderings.
Regards,
Todd SmartIt may be too much work to "re-tool", but have you considered DTS services?
However, I too, am waiting for a fix on Excel exporting!
-KB
"Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
news:5430232F-211C-439A-A4B0-F644AA68B740@.microsoft.com...
> Though it has been well-documented in the community since SP1 was
released, I'd like to reiterate that many of us are having critical issues
related to element hiding and excel export.
> I, for one, have built a highly dynamic reporting system that relies
heavily on the use visibility for showing/hiding subreports. My users
require export to excel.
> The question to Microsoft is: Can you fix this issue that was introduced
in SP1? Please provide us with an SP1a update that will allow elements to
be hidden & thus NOT show up in the excel export...just as it works in the
HTML & PDF renderings.
>
> Regards,
> Todd Smart|||I'm not sure what you want us to do. You would rather have items that are
hidden and can never be toggled?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
news:5430232F-211C-439A-A4B0-F644AA68B740@.microsoft.com...
> Though it has been well-documented in the community since SP1 was
> released, I'd like to reiterate that many of us are having critical issues
> related to element hiding and excel export.
> I, for one, have built a highly dynamic reporting system that relies
> heavily on the use visibility for showing/hiding subreports. My users
> require export to excel.
> The question to Microsoft is: Can you fix this issue that was introduced
> in SP1? Please provide us with an SP1a update that will allow elements to
> be hidden & thus NOT show up in the excel export...just as it works in the
> HTML & PDF renderings.
>
> Regards,
> Todd Smart|||Hi Brian,
If I have a subreport (or any other element for that matter) that is hidden due to an expression result of [True], that subreport should not be rendered in the Excel export. It should not even have an Excel cell associated with it.
In other words, I would want the render of Excel to work just like the HTML & PDF render works...and how it worked prior to SP1.
Regards,
Todd
"Brian Welcker [MSFT]" wrote:
> I'm not sure what you want us to do. You would rather have items that are
> hidden and can never be toggled?
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
> news:5430232F-211C-439A-A4B0-F644AA68B740@.microsoft.com...
> > Though it has been well-documented in the community since SP1 was
> > released, I'd like to reiterate that many of us are having critical issues
> > related to element hiding and excel export.
> >
> > I, for one, have built a highly dynamic reporting system that relies
> > heavily on the use visibility for showing/hiding subreports. My users
> > require export to excel.
> >
> > The question to Microsoft is: Can you fix this issue that was introduced
> > in SP1? Please provide us with an SP1a update that will allow elements to
> > be hidden & thus NOT show up in the excel export...just as it works in the
> > HTML & PDF renderings.
> >
> >
> > Regards,
> >
> > Todd Smart
>
>|||OK, we'll take a look at this and if it is a regression, we will fix it in
SP2.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
news:423C4612-1C70-4178-9DCA-321019F859E0@.microsoft.com...
> Hi Brian,
> If I have a subreport (or any other element for that matter) that is
> hidden due to an expression result of [True], that subreport should not be
> rendered in the Excel export. It should not even have an Excel cell
> associated with it.
> In other words, I would want the render of Excel to work just like the
> HTML & PDF render works...and how it worked prior to SP1.
>
> Regards,
> Todd
> "Brian Welcker [MSFT]" wrote:
>> I'm not sure what you want us to do. You would rather have items that are
>> hidden and can never be toggled?
>> --
>> Brian Welcker
>> Group Program Manager
>> SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
>> news:5430232F-211C-439A-A4B0-F644AA68B740@.microsoft.com...
>> > Though it has been well-documented in the community since SP1 was
>> > released, I'd like to reiterate that many of us are having critical
>> > issues
>> > related to element hiding and excel export.
>> >
>> > I, for one, have built a highly dynamic reporting system that relies
>> > heavily on the use visibility for showing/hiding subreports. My users
>> > require export to excel.
>> >
>> > The question to Microsoft is: Can you fix this issue that was
>> > introduced
>> > in SP1? Please provide us with an SP1a update that will allow elements
>> > to
>> > be hidden & thus NOT show up in the excel export...just as it works in
>> > the
>> > HTML & PDF renderings.
>> >
>> >
>> > Regards,
>> >
>> > Todd Smart
>>|||Brian, are there any work arounds ? I am also finding that visible tables are
not being displayed in the export to excel, and the start of the table data
appears several rows down (80 rows) .
Regards
Stuart
"Brian Welcker [MSFT]" wrote:
> OK, we'll take a look at this and if it is a regression, we will fix it in
> SP2.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
> news:423C4612-1C70-4178-9DCA-321019F859E0@.microsoft.com...
> > Hi Brian,
> >
> > If I have a subreport (or any other element for that matter) that is
> > hidden due to an expression result of [True], that subreport should not be
> > rendered in the Excel export. It should not even have an Excel cell
> > associated with it.
> >
> > In other words, I would want the render of Excel to work just like the
> > HTML & PDF render works...and how it worked prior to SP1.
> >
> >
> > Regards,
> >
> > Todd
> >
> > "Brian Welcker [MSFT]" wrote:
> >
> >> I'm not sure what you want us to do. You would rather have items that are
> >> hidden and can never be toggled?
> >>
> >> --
> >> Brian Welcker
> >> Group Program Manager
> >> SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "Todd Smart" <ToddSmart@.discussions.microsoft.com> wrote in message
> >> news:5430232F-211C-439A-A4B0-F644AA68B740@.microsoft.com...
> >> > Though it has been well-documented in the community since SP1 was
> >> > released, I'd like to reiterate that many of us are having critical
> >> > issues
> >> > related to element hiding and excel export.
> >> >
> >> > I, for one, have built a highly dynamic reporting system that relies
> >> > heavily on the use visibility for showing/hiding subreports. My users
> >> > require export to excel.
> >> >
> >> > The question to Microsoft is: Can you fix this issue that was
> >> > introduced
> >> > in SP1? Please provide us with an SP1a update that will allow elements
> >> > to
> >> > be hidden & thus NOT show up in the excel export...just as it works in
> >> > the
> >> > HTML & PDF renderings.
> >> >
> >> >
> >> > Regards,
> >> >
> >> > Todd Smart
> >>
> >>
> >>
>
>
Subscribe to:
Comments (Atom)