disaster: How to recover

Today I did the most stupid step in all my working life ,i was working in our
cutomers LIVE DB (about 150 thounsand record) we have feild called bookId by
, and there is an urgent change to bookid number for books due to some
criteria from manager so i a have to change the bookid 252 to -1 to indicate
that is not available but by fault i make the following sql statent (UPDATE
BOOKS SET BOOKID = -1) without the where statment so I destryed my life and
there is no backup since 7 working days ,what should I do to recover from
this ? the daily transactions on book ids in hunderds ...what should i do
please to recover my data? all book id colmun be -1"Minimizing data loss when accidents happens "
http://www.karaszi.com/SQLServer/info_restore_log_several_times.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Raed Sawalha" <RaedSawalha@.discussions.microsoft.com> wrote in message
news:EA39374D-6F2A-48B5-810A-25ABC4B9E0C6@.microsoft.com...
> Today I did the most stupid step in all my working life ,i was working in our
> cutomers LIVE DB (about 150 thounsand record) we have feild called bookId by
> , and there is an urgent change to bookid number for books due to some
> criteria from manager so i a have to change the bookid 252 to -1 to indicate
> that is not available but by fault i make the following sql statent (UPDATE
> BOOKS SET BOOKID = -1) without the where statment so I destryed my life and
> there is no backup since 7 working days ,what should I do to recover from
> this ? the daily transactions on book ids in hunderds ...what should i do
> please to recover my data? all book id colmun be -1|||Raed Sawalha wrote:
> Today I did the most stupid step in all my working life ,i was working in our
> cutomers LIVE DB (about 150 thounsand record) we have feild called bookId by
> , and there is an urgent change to bookid number for books due to some
> criteria from manager so i a have to change the bookid 252 to -1 to indicate
> that is not available but by fault i make the following sql statent (UPDATE
> BOOKS SET BOOKID = -1) without the where statment so I destryed my life and
> there is no backup since 7 working days ,what should I do to recover from
> this ? the daily transactions on book ids in hunderds ...what should i do
> please to recover my data? all book id colmun be -1
is the database in simple recovery model or bulklogged or full?|||it is bulklogged
"Zarko Jovanovic" wrote:
> Raed Sawalha wrote:
> > Today I did the most stupid step in all my working life ,i was working in our
> > cutomers LIVE DB (about 150 thounsand record) we have feild called bookId by
> > , and there is an urgent change to bookid number for books due to some
> > criteria from manager so i a have to change the bookid 252 to -1 to indicate
> > that is not available but by fault i make the following sql statent (UPDATE
> > BOOKS SET BOOKID = -1) without the where statment so I destryed my life and
> > there is no backup since 7 working days ,what should I do to recover from
> > this ? the daily transactions on book ids in hunderds ...what should i do
> > please to recover my data? all book id colmun be -1
> is the database in simple recovery model or bulklogged or full?
>|||Normally, you would now do a transaction log backup. Then restore the most recent database backup
and all subsequent log backups. For the very last log backup (the one you just performed), you would
use the STOPAT option for the restore command to stop just before the accident.
Since you are in bulk logged mode, whether you can do point in time restore for the last log backup
depend on whether you have performed any minimally logged operations. If such have been done, no
point in time.
See the article I posted and Books Online for more information.
Also, a log reader program can be useful (again see my articles).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Raed Sawalha" <RaedSawalha@.discussions.microsoft.com> wrote in message
news:A4289B58-3111-4C4C-B028-29698E9945AB@.microsoft.com...
> it is bulklogged
> "Zarko Jovanovic" wrote:
>> Raed Sawalha wrote:
>> > Today I did the most stupid step in all my working life ,i was working in our
>> > cutomers LIVE DB (about 150 thounsand record) we have feild called bookId by
>> > , and there is an urgent change to bookid number for books due to some
>> > criteria from manager so i a have to change the bookid 252 to -1 to indicate
>> > that is not available but by fault i make the following sql statent (UPDATE
>> > BOOKS SET BOOKID = -1) without the where statment so I destryed my life and
>> > there is no backup since 7 working days ,what should I do to recover from
>> > this ? the daily transactions on book ids in hunderds ...what should i do
>> > please to recover my data? all book id colmun be -1
>> is the database in simple recovery model or bulklogged or full?

disaster: How to recover

Today I did the most stupid step in all my working life ,i was working in our
cutomers LIVE DB (about 150 thounsand record) we have feild called bookId by
, and there is an urgent change to bookid number for books due to some
criteria from manager so i a have to change the bookid 252 to -1 to indicate
that is not available but by fault i make the following sql statent (UPDATE
BOOKS SET BOOKID = -1) without the where statment so I destryed my life and
there is no backup since 7 working days ,what should I do to recover from
this ? the daily transactions on book ids in hunderds ...what should i do
please to recover my data? all book id colmun be -1
"Minimizing data loss when accidents happens "
http://www.karaszi.com/SQLServer/inf...eral_times.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Raed Sawalha" <RaedSawalha@.discussions.microsoft.com> wrote in message
news:EA39374D-6F2A-48B5-810A-25ABC4B9E0C6@.microsoft.com...
> Today I did the most stupid step in all my working life ,i was working in our
> cutomers LIVE DB (about 150 thounsand record) we have feild called bookId by
> , and there is an urgent change to bookid number for books due to some
> criteria from manager so i a have to change the bookid 252 to -1 to indicate
> that is not available but by fault i make the following sql statent (UPDATE
> BOOKS SET BOOKID = -1) without the where statment so I destryed my life and
> there is no backup since 7 working days ,what should I do to recover from
> this ? the daily transactions on book ids in hunderds ...what should i do
> please to recover my data? all book id colmun be -1
|||Raed Sawalha wrote:
> Today I did the most stupid step in all my working life ,i was working in our
> cutomers LIVE DB (about 150 thounsand record) we have feild called bookId by
> , and there is an urgent change to bookid number for books due to some
> criteria from manager so i a have to change the bookid 252 to -1 to indicate
> that is not available but by fault i make the following sql statent (UPDATE
> BOOKS SET BOOKID = -1) without the where statment so I destryed my life and
> there is no backup since 7 working days ,what should I do to recover from
> this ? the daily transactions on book ids in hunderds ...what should i do
> please to recover my data? all book id colmun be -1
is the database in simple recovery model or bulklogged or full?
|||it is bulklogged
"Zarko Jovanovic" wrote:

> Raed Sawalha wrote:
> is the database in simple recovery model or bulklogged or full?
>
|||Normally, you would now do a transaction log backup. Then restore the most recent database backup
and all subsequent log backups. For the very last log backup (the one you just performed), you would
use the STOPAT option for the restore command to stop just before the accident.
Since you are in bulk logged mode, whether you can do point in time restore for the last log backup
depend on whether you have performed any minimally logged operations. If such have been done, no
point in time.
See the article I posted and Books Online for more information.
Also, a log reader program can be useful (again see my articles).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Raed Sawalha" <RaedSawalha@.discussions.microsoft.com> wrote in message
news:A4289B58-3111-4C4C-B028-29698E9945AB@.microsoft.com...[vbcol=seagreen]
> it is bulklogged
> "Zarko Jovanovic" wrote:

disaster: How to recover

Today I did the most stupid step in all my working life ,i was working in ou
r
cutomers LIVE DB (about 150 thounsand record) we have feild called bookId by
, and there is an urgent change to bookid number for books due to some
criteria from manager so i a have to change the bookid 252 to -1 to indicate
that is not available but by fault i make the following sql statent (UPDATE
BOOKS SET BOOKID = -1) without the where statment so I destryed my life and
there is no backup since 7 working days ,what should I do to recover from
this ? the daily transactions on book ids in hunderds ...what should i do
please to recover my data? all book id colmun be -1"Minimizing data loss when accidents happens "
http://www.karaszi.com/SQLServer/in...veral_times.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Raed Sawalha" <RaedSawalha@.discussions.microsoft.com> wrote in message
news:EA39374D-6F2A-48B5-810A-25ABC4B9E0C6@.microsoft.com...
> Today I did the most stupid step in all my working life ,i was working in
our
> cutomers LIVE DB (about 150 thounsand record) we have feild called bookId
by
> , and there is an urgent change to bookid number for books due to some
> criteria from manager so i a have to change the bookid 252 to -1 to indica
te
> that is not available but by fault i make the following sql statent (UPDAT
E
> BOOKS SET BOOKID = -1) without the where statment so I destryed my life an
d
> there is no backup since 7 working days ,what should I do to recover from
> this ? the daily transactions on book ids in hunderds ...what should i do
> please to recover my data? all book id colmun be -1|||Raed Sawalha wrote:
> Today I did the most stupid step in all my working life ,i was working in
our
> cutomers LIVE DB (about 150 thounsand record) we have feild called bookId
by
> , and there is an urgent change to bookid number for books due to some
> criteria from manager so i a have to change the bookid 252 to -1 to indica
te
> that is not available but by fault i make the following sql statent (UPDAT
E
> BOOKS SET BOOKID = -1) without the where statment so I destryed my life an
d
> there is no backup since 7 working days ,what should I do to recover from
> this ? the daily transactions on book ids in hunderds ...what should i do
> please to recover my data? all book id colmun be -1
is the database in simple recovery model or bulklogged or full?|||it is bulklogged
"Zarko Jovanovic" wrote:

> Raed Sawalha wrote:
> is the database in simple recovery model or bulklogged or full?
>|||Normally, you would now do a transaction log backup. Then restore the most r
ecent database backup
and all subsequent log backups. For the very last log backup (the one you ju
st performed), you would
use the STOPAT option for the restore command to stop just before the accide
nt.
Since you are in bulk logged mode, whether you can do point in time restore
for the last log backup
depend on whether you have performed any minimally logged operations. If suc
h have been done, no
point in time.
See the article I posted and Books Online for more information.
Also, a log reader program can be useful (again see my articles).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Raed Sawalha" <RaedSawalha@.discussions.microsoft.com> wrote in message
news:A4289B58-3111-4C4C-B028-29698E9945AB@.microsoft.com...[vbcol=seagreen]
> it is bulklogged
> "Zarko Jovanovic" wrote:
>

Disappearing data elements in the header

I have created a number of reports where I need to display database elements in the Header record. I have been using the reportitems feature to get them to display there. When I preview the report the header looks fine; however, when the report is exported to pdf or printed out the header information completly disappears.

Any suggestions would be great.

Hi,

While displaying the data fileds in the Header you are using report items and using those in the text box of the Report header then the textbox has the Repeat With property.Set it to the data region with which the report item need to be repeated.Previously I tried this it is looking good in the preview When i am exporting the data fileds are displaying in the first page only not displaying in the consecutive pages of report.Can you try by setting the Repeat with property.

Thanks.

|||

Using RepeatWith property is not an ideal solution because the cause for a new page creation need not necessarily be the data region that spans more than 1 page. So create a new hidden report parameter and have the default value of that as the one which you have used in your hidden report item.

Shyam

Disabling 'Export to excel' option when record count >5000 in a re

Hi,
I have a report that has two drill downs that drill to about 5000 records
and due to this I am having time out problems while exporting to excel. For
now, we have worked around the timeout problem but what I would like to know
is whether or not there is a way to disable the excel option in the export
drop down list - only when the SQL report generates like more than 5000 rows.
The reason to disable being, the RS/RM is consuming CPU like crazy and its
repurcussions are unbearable.Hi,
The only thing you can do is to disable Excel export server wide. This you
can do in the RSReportServer.config and add Visible="false" to the element of
the Excel export.
Unfortunately it isn't possible to set it per report or even dynamic.
Jan Pieter Posthuma
"Jammer" wrote:
> Hi,
> I have a report that has two drill downs that drill to about 5000 records
> and due to this I am having time out problems while exporting to excel. For
> now, we have worked around the timeout problem but what I would like to know
> is whether or not there is a way to disable the excel option in the export
> drop down list - only when the SQL report generates like more than 5000 rows.
> The reason to disable being, the RS/RM is consuming CPU like crazy and its
> repurcussions are unbearable.|||"Jan Pieter Posthuma" <JanPieterPosthuma@.discussions.microsoft.com> wrote in
message news:B18CDAAB-35F2-4CA6-AC13-EC30640558EA@.microsoft.com...
> Hi,
> The only thing you can do is to disable Excel export server wide. This you
> can do in the RSReportServer.config and add Visible="false" to the element
> of
> the Excel export.
> Unfortunately it isn't possible to set it per report or even dynamic.
>
If you take a short peek into the generated script when you activate the
toolbar, you can create your own 'export' button with or without excel
export very easily (rs:format=EXCEL)
I modified the ReportViewer sample to display a small popup toolbar with:
export the Excel, PDF and Print on it (takes up way less space then the
standard toolbar)
Alfred|||Hey Alfred,
Can you tell me how you achieved creating your own export to excel bar:
Thanks
Balaji
"Smeenk, A.D." wrote:
> "Jan Pieter Posthuma" <JanPieterPosthuma@.discussions.microsoft.com> wrote in
> message news:B18CDAAB-35F2-4CA6-AC13-EC30640558EA@.microsoft.com...
> > Hi,
> >
> > The only thing you can do is to disable Excel export server wide. This you
> > can do in the RSReportServer.config and add Visible="false" to the element
> > of
> > the Excel export.
> >
> > Unfortunately it isn't possible to set it per report or even dynamic.
> >
> If you take a short peek into the generated script when you activate the
> toolbar, you can create your own 'export' button with or without excel
> export very easily (rs:format=EXCEL)
> I modified the ReportViewer sample to display a small popup toolbar with:
> export the Excel, PDF and Print on it (takes up way less space then the
> standard toolbar)
> Alfred
>
>|||"Balaji" <Balaji@.discussions.microsoft.com> wrote in message
news:29713B57-0C78-4AB9-B7BE-8E5234D59809@.microsoft.com...
> Hey Alfred,
> Can you tell me how you achieved creating your own export to excel bar:
>
Like I said, I modifed the ReportViewer sample, its (by default) installed
here:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\Samples\Applications\ReportViewer
I modified the properties and added 'small' to the ToolBar options, and when
selected I generate different code. I add an extra table around the iframe
and use a div to display a popup menu like when you hover over an image in
IE. The 'onclick' of the images activates a new window with the requested
export of the report (actually a re-render of the report I think, I didn't
add the session ID)
Alfred|||Instead of disabling export to Excel you might want to add a link at the top
of the page that says Export Data. Use jump to URL and specify CSV and ASCII
(the CSV export does Unicode and Excel doesn't handle unicode CSV). By
rendering in ASCII CSV Excel comes up automatically and this is very very
fast. I had an Excel export that took 5 minutes and brought the server to
its knees go to 10 seconds.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Smeenk, A.D." <alfreds@.dbs-at-nospam-at-nl> wrote in message
news:uX66yHuVFHA.2196@.TK2MSFTNGP09.phx.gbl...
> "Balaji" <Balaji@.discussions.microsoft.com> wrote in message
> news:29713B57-0C78-4AB9-B7BE-8E5234D59809@.microsoft.com...
>> Hey Alfred,
>> Can you tell me how you achieved creating your own export to excel bar:
> Like I said, I modifed the ReportViewer sample, its (by default) installed
> here:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\Samples\Applications\ReportViewer
> I modified the properties and added 'small' to the ToolBar options, and
> when selected I generate different code. I add an extra table around the
> iframe and use a div to display a popup menu like when you hover over an
> image in IE. The 'onclick' of the images activates a new window with the
> requested export of the report (actually a re-render of the report I
> think, I didn't add the session ID)
> Alfred
>|||"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23HdntxuVFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Instead of disabling export to Excel you might want to add a link at the
> top of the page that says Export Data. Use jump to URL and specify CSV and
> ASCII (the CSV export does Unicode and Excel doesn't handle unicode CSV).
> By rendering in ASCII CSV Excel comes up automatically and this is very
> very fast. I had an Excel export that took 5 minutes and brought the
> server to its knees go to 10 seconds.
>
That 'export to CSV' should 'officially' be on the right-click menu when you
view a table layout report part, now for some reason that does not function
on all machines... any idea's?
Yes same report, all machines Windows XP SP2, IE 6.
With one person the option re-appeared after a reset of the local intranet
security to default...
Alfred|||No idea about that. Note that the export to CSV you are talking about
exports as Unicode and Excel will bring it all together in a single column.
Bruce L-C
"Smeenk, A.D." <alfreds@.dbs-at-nospam-at-nl> wrote in message
news:OFAlFu4VFHA.1452@.TK2MSFTNGP14.phx.gbl...
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23HdntxuVFHA.2664@.TK2MSFTNGP15.phx.gbl...
>> Instead of disabling export to Excel you might want to add a link at the
>> top of the page that says Export Data. Use jump to URL and specify CSV
>> and ASCII (the CSV export does Unicode and Excel doesn't handle unicode
>> CSV). By rendering in ASCII CSV Excel comes up automatically and this is
>> very very fast. I had an Excel export that took 5 minutes and brought the
>> server to its knees go to 10 seconds.
> That 'export to CSV' should 'officially' be on the right-click menu when
> you view a table layout report part, now for some reason that does not
> function on all machines... any idea's?
> Yes same report, all machines Windows XP SP2, IE 6.
> With one person the option re-appeared after a reset of the local intranet
> security to default...
> Alfred
>|||Why don't you increase the timeout?
Farahmand
"Jammer" wrote:
> Hi,
> I have a report that has two drill downs that drill to about 5000 records
> and due to this I am having time out problems while exporting to excel. For
> now, we have worked around the timeout problem but what I would like to know
> is whether or not there is a way to disable the excel option in the export
> drop down list - only when the SQL report generates like more than 5000 rows.
> The reason to disable being, the RS/RM is consuming CPU like crazy and its
> repurcussions are unbearable.|||Why don't you increase the timeout?
Farahmand
"Jammer" wrote:
> Hi,
> I have a report that has two drill downs that drill to about 5000 records
> and due to this I am having time out problems while exporting to excel. For
> now, we have worked around the timeout problem but what I would like to know
> is whether or not there is a way to disable the excel option in the export
> drop down list - only when the SQL report generates like more than 5000 rows.
> The reason to disable being, the RS/RM is consuming CPU like crazy and its
> repurcussions are unbearable.

Disable Paging

Hi

Is there any way I can disable paging and show all record on one page?

Regards

Amit

You can set the report's InteractiveHeight to 0 to disable paging.

-Chris

|||

Sweet.. Thank you for your help Chris.

Regards

Amit