PowerPoint format possible?

Hello,

we plan to use Reporting Services in the company in the near future. However, management prefers power point reports, a format which reporting services does not support (please correct me if I am wrong here).

Is there a third party extenstion tool for RS available which can produce PPT reports?

Best regards,

Michael Fuchs

Hello,

I'm not aware of any third-party PowerPoint renderer.

Can you explain your scenario that calls for PowerPoint rendering? Any insight you can offer will help to justify the possibility of providing this functionality in the future.

Thanks,
Chris

|||

Hello,

Management presents the reports in periodic meetings, currently pdf slides are used (these pdfs don't come from RS but from a self developed program), but this is not desired by management anymore, as pdf is not optimal for a presentation. What we need is nothing too fancy, just a slide with some formatting options (i.e. different templates) and the relevant charts and data presented on the slide.

I heard that ppt output is planned anyway in the next version of reporting services and that it already is in the testing stage. Is that just a rumor or can you confirm that?

Thanks,

Michael

Power/Factorial not working

I am trying to get the value, 3 to the 2.2 power (3^2.222).
Can someone tell me how to do it? The literature says to use:
POWER(3,2.222)
however ths is rounding my values for some reason.Power (X, Y)

GOT IT!

and the key was x.

Power (1.0000, 1) will return 1.0000
Power (1.00, 1) will return 1.00

Hooah!

`Le

Power went out -- how to check consistency, etc.?

The power went out to a live SQL Server. UPS was being serviced (that
figures) and thus the server simply lost all power. Now what?
How do I check for consistency?
Will checking consistency take the database down (like some dbcc things)?
What else should I do/check?DBCC CHECKDB and DBCC CHEKCATALOG are what you want to run. By default they
are online operations. But I would want to know if there is damage or
corruption before I even let someone back in if possible.
--
Andrew J. Kelly SQL MVP
"HK" <replywithingroup@.notreal.com> wrote in message
news:7YFLf.472$xS5.132@.tornado.socal.rr.com...
> The power went out to a live SQL Server. UPS was being serviced (that
> figures) and thus the server simply lost all power. Now what?
> How do I check for consistency?
> Will checking consistency take the database down (like some dbcc things)?
> What else should I do/check?
>|||Traffic came back on its own when the system restarted. So too late to run
the check first. By "online", do you mean they will NOT interrupt live
transactions when I run them? (BOL doesn't really say). Also, which
repair option do you think I should use if it finds something?
REPAIR_ALLOW_DATA_LOSS or REPAIR_REBUILD
(assume I want good repairs and not fast ones)
Thanks
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%233R4L%23WOGHA.1216@.TK2MSFTNGP14.phx.gbl...
> DBCC CHECKDB and DBCC CHEKCATALOG are what you want to run. By default
they
> are online operations. But I would want to know if there is damage or
> corruption before I even let someone back in if possible.
> --
> Andrew J. Kelly SQL MVP
>
> "HK" <replywithingroup@.notreal.com> wrote in message
> news:7YFLf.472$xS5.132@.tornado.socal.rr.com...
> > The power went out to a live SQL Server. UPS was being serviced (that
> > figures) and thus the server simply lost all power. Now what?
> >
> > How do I check for consistency?
> > Will checking consistency take the database down (like some dbcc
things)?
> > What else should I do/check?
> >
> >
>|||Repair_Rebuild is pretty safe and any errors fixed by that should be fine.
If it doesn't fix some you may have to run with the allow data loss. But
obviously that has the potential to loose data and you won't know which is
lost. So if it comes down to that it is always recommended to restore from
your last known good backups.
--
Andrew J. Kelly SQL MVP
"HK" <replywithingroup@.notreal.com> wrote in message
news:eXILf.83$8l2.0@.tornado.socal.rr.com...
> Traffic came back on its own when the system restarted. So too late to
> run
> the check first. By "online", do you mean they will NOT interrupt live
> transactions when I run them? (BOL doesn't really say). Also, which
> repair option do you think I should use if it finds something?
> REPAIR_ALLOW_DATA_LOSS or REPAIR_REBUILD
> (assume I want good repairs and not fast ones)
> Thanks
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%233R4L%23WOGHA.1216@.TK2MSFTNGP14.phx.gbl...
>> DBCC CHECKDB and DBCC CHEKCATALOG are what you want to run. By default
> they
>> are online operations. But I would want to know if there is damage or
>> corruption before I even let someone back in if possible.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "HK" <replywithingroup@.notreal.com> wrote in message
>> news:7YFLf.472$xS5.132@.tornado.socal.rr.com...
>> > The power went out to a live SQL Server. UPS was being serviced (that
>> > figures) and thus the server simply lost all power. Now what?
>> >
>> > How do I check for consistency?
>> > Will checking consistency take the database down (like some dbcc
> things)?
>> > What else should I do/check?
>> >
>> >
>>
>sql

Power went out -- how to check consistency, etc.?

The power went out to a live SQL Server. UPS was being serviced (that
figures) and thus the server simply lost all power. Now what?
How do I check for consistency?
Will checking consistency take the database down (like some dbcc things)?
What else should I do/check?
DBCC CHECKDB and DBCC CHEKCATALOG are what you want to run. By default they
are online operations. But I would want to know if there is damage or
corruption before I even let someone back in if possible.
Andrew J. Kelly SQL MVP
"HK" <replywithingroup@.notreal.com> wrote in message
news:7YFLf.472$xS5.132@.tornado.socal.rr.com...
> The power went out to a live SQL Server. UPS was being serviced (that
> figures) and thus the server simply lost all power. Now what?
> How do I check for consistency?
> Will checking consistency take the database down (like some dbcc things)?
> What else should I do/check?
>
|||Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.server:425005
Traffic came back on its own when the system restarted. So too late to run
the check first. By "online", do you mean they will NOT interrupt live
transactions when I run them? (BOL doesn't really say). Also, which
repair option do you think I should use if it finds something?
REPAIR_ALLOW_DATA_LOSS or REPAIR_REBUILD
(assume I want good repairs and not fast ones)
Thanks
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%233R4L%23WOGHA.1216@.TK2MSFTNGP14.phx.gbl...
> DBCC CHECKDB and DBCC CHEKCATALOG are what you want to run. By default
they[vbcol=seagreen]
> are online operations. But I would want to know if there is damage or
> corruption before I even let someone back in if possible.
> --
> Andrew J. Kelly SQL MVP
>
> "HK" <replywithingroup@.notreal.com> wrote in message
> news:7YFLf.472$xS5.132@.tornado.socal.rr.com...
things)?
>
|||Repair_Rebuild is pretty safe and any errors fixed by that should be fine.
If it doesn't fix some you may have to run with the allow data loss. But
obviously that has the potential to loose data and you won't know which is
lost. So if it comes down to that it is always recommended to restore from
your last known good backups.
Andrew J. Kelly SQL MVP
"HK" <replywithingroup@.notreal.com> wrote in message
news:eXILf.83$8l2.0@.tornado.socal.rr.com...
> Traffic came back on its own when the system restarted. So too late to
> run
> the check first. By "online", do you mean they will NOT interrupt live
> transactions when I run them? (BOL doesn't really say). Also, which
> repair option do you think I should use if it finds something?
> REPAIR_ALLOW_DATA_LOSS or REPAIR_REBUILD
> (assume I want good repairs and not fast ones)
> Thanks
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%233R4L%23WOGHA.1216@.TK2MSFTNGP14.phx.gbl...
> they
> things)?
>

Power went out -- how to check consistency, etc.?

The power went out to a live SQL Server. UPS was being serviced (that
figures) and thus the server simply lost all power. Now what?
How do I check for consistency?
Will checking consistency take the database down (like some dbcc things)?
What else should I do/check?DBCC CHECKDB and DBCC CHEKCATALOG are what you want to run. By default they
are online operations. But I would want to know if there is damage or
corruption before I even let someone back in if possible.
Andrew J. Kelly SQL MVP
"HK" <replywithingroup@.notreal.com> wrote in message
news:7YFLf.472$xS5.132@.tornado.socal.rr.com...
> The power went out to a live SQL Server. UPS was being serviced (that
> figures) and thus the server simply lost all power. Now what?
> How do I check for consistency?
> Will checking consistency take the database down (like some dbcc things)?
> What else should I do/check?
>|||Xref: TK2MSFTNGP08.phx.gbl microsoft.public.sqlserver.server:425005
Traffic came back on its own when the system restarted. So too late to run
the check first. By "online", do you mean they will NOT interrupt live
transactions when I run them? (BOL doesn't really say). Also, which
repair option do you think I should use if it finds something?
REPAIR_ALLOW_DATA_LOSS or REPAIR_REBUILD
(assume I want good repairs and not fast ones)
Thanks
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%233R4L%23WOGHA.1216@.TK2MSFTNGP14.phx.gbl...
> DBCC CHECKDB and DBCC CHEKCATALOG are what you want to run. By default
they
> are online operations. But I would want to know if there is damage or
> corruption before I even let someone back in if possible.
> --
> Andrew J. Kelly SQL MVP
>
> "HK" <replywithingroup@.notreal.com> wrote in message
> news:7YFLf.472$xS5.132@.tornado.socal.rr.com...
things)?[vbcol=seagreen]
>|||Repair_Rebuild is pretty safe and any errors fixed by that should be fine.
If it doesn't fix some you may have to run with the allow data loss. But
obviously that has the potential to loose data and you won't know which is
lost. So if it comes down to that it is always recommended to restore from
your last known good backups.
Andrew J. Kelly SQL MVP
"HK" <replywithingroup@.notreal.com> wrote in message
news:eXILf.83$8l2.0@.tornado.socal.rr.com...
> Traffic came back on its own when the system restarted. So too late to
> run
> the check first. By "online", do you mean they will NOT interrupt live
> transactions when I run them? (BOL doesn't really say). Also, which
> repair option do you think I should use if it finds something?
> REPAIR_ALLOW_DATA_LOSS or REPAIR_REBUILD
> (assume I want good repairs and not fast ones)
> Thanks
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%233R4L%23WOGHA.1216@.TK2MSFTNGP14.phx.gbl...
> they
> things)?
>

Power user question

I want to create a user on SQL Server 2005 that needs to be able to
create databases, logins, and users, as well as create stored procs,
triggers, tables, etc. This user will be accessed from a vb.net
application. Is there anything less powerful than the 'sa' user that
will do the trick, or some kind of roll-my-own permissions? I really
haven't played around too much with assigning SQL Server permissions
before.
Cheers,
MarcusYou can grant the server role Database Creators to the user, and then grant
the fixed database role db_ddladmin for each existing database.
"Marcus" wrote:

> I want to create a user on SQL Server 2005 that needs to be able to
> create databases, logins, and users, as well as create stored procs,
> triggers, tables, etc. This user will be accessed from a vb.net
> application. Is there anything less powerful than the 'sa' user that
> will do the trick, or some kind of roll-my-own permissions? I really
> haven't played around too much with assigning SQL Server permissions
> before.
> Cheers,
> Marcus
>

Power user question

I want to create a user on SQL Server 2005 that needs to be able to
create databases, logins, and users, as well as create stored procs,
triggers, tables, etc. This user will be accessed from a vb.net
application. Is there anything less powerful than the 'sa' user that
will do the trick, or some kind of roll-my-own permissions? I really
haven't played around too much with assigning SQL Server permissions
before.
Cheers,
MarcusYou can grant the server role Database Creators to the user, and then grant
the fixed database role db_ddladmin for each existing database.
"Marcus" wrote:
> I want to create a user on SQL Server 2005 that needs to be able to
> create databases, logins, and users, as well as create stored procs,
> triggers, tables, etc. This user will be accessed from a vb.net
> application. Is there anything less powerful than the 'sa' user that
> will do the trick, or some kind of roll-my-own permissions? I really
> haven't played around too much with assigning SQL Server permissions
> before.
> Cheers,
> Marcus
>

Power Regression

I need to write some SQL to do a power regression for a trendline. I have 2 columns of data which represent my X, Y data and all I'm after is the a and the b for the function y=ax^b. Has anyone ran into this before? I know SSAS has a linear regression function but my data really only fits the power model.

I solved this guy by writing a CLR stored procedure that does the regression. I must say I have been immensely happy with both CTE's and CLR stored procedures.

|||You can do a least squares log-log regression on your data. Here's an example that adapts the least squares example at http://www.users.drew.edu/skass/sql/LeastSquares.sql.txt to do the log-log regression. Note that this may not be the precise definition of "best fit" you need, if a linear fit of the log-log data is not your objective. data. create table Bob ( i int identity(1,1) primary key, x float, y float ) declare @.j float set @.j = 1 while @.j < 100 begin set @.j = @.j + rand(checksum(newid())) insert into Bob select @.j, (3.27+rand())*power(@.j,5+rand()/3) end; declare @.b float, @.log_a float select @.b = (count(x)*sum(x*y)-sum(x)*sum(y)) /(count(x)*sum(x*x) - sum(x)*sum(x)), @.log_a = (sum(y)*sum(x*x) - sum(x)*sum(x*y)) /(count(x)*sum(x*x) - sum(x)*sum(x)) from ( select log(x) as x, log(y) as y from Bob ) as Bob select 'y = '+convert(varchar,exp(@.log_a))+'*x^'+convert(varchar,@.b) select x, y, exp(@.log_a)*power(x,@.b) as y_predicted from Bob go drop table Bob akula@.discussions.microsoft.com wrote:
> I need to write some SQL to do a power regression for a trendline. I
> have 2 columns of data which represent my X, Y data and all I'm after is
> the a and the b for the function y=ax^b. Has anyone ran into this
> before? I know SSAS has a linear regression function but my data
> really only fits the power model.
>
>|||Sorry - this is a better repro: create table Bob ( i int identity(1,1) primary key, x float, y float ) declare @.j float set @.j = 1 while @.j < 100 begin set @.j = @.j + rand(checksum(newid())) insert into Bob select @.j, (3.27+rand())*power(@.j,5+rand()/3) end; declare @.b float, @.log_a float select @.b = (count(x)*sum(x*y)-sum(x)*sum(y)) /(count(x)*sum(x*x) - sum(x)*sum(x)), @.log_a = (sum(y)*sum(x*x) - sum(x)*sum(x*y)) /(count(x)*sum(x*x) - sum(x)*sum(x)) from ( select log(x) as x, log(y) as y from Bob ) as Bob select 'y = '+convert(varchar,exp(@.log_a))+'*x^'+convert(varchar,@.b) select x, y, exp(@.log_a)*power(x,@.b) as y_predicted from Bob go drop table Bob Steve Kass Drew University akula@.discussions.microsoft.com wrote:
> I need to write some SQL to do a power regression for a trendline. I
> have 2 columns of data which represent my X, Y data and all I'm after is
> the a and the b for the function y=ax^b. Has anyone ran into this
> before? I know SSAS has a linear regression function but my data
> really only fits the power model.
>
>sql

Power Point Presentation

hi Gurus,
I need the resource where I can find the Power point presentation on various
topics of SQL server.
Thanks in advance
Ansari
Use link in my signature, check Technical Resources.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"M.M Ansari" <mudasar_ansari@.hotmail.com> wrote in message
news:%236r98J9kEHA.3648@.TK2MSFTNGP09.phx.gbl...
> hi Gurus,
> I need the resource where I can find the Power point presentation on
various
> topics of SQL server.
> Thanks in advance
> Ansari
>
>
|||Thanks a lot..
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message news:uEFAvW9kEHA.3520@.TK2MSFTNGP11.phx.gbl...
> Use link in my signature, check Technical Resources.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "M.M Ansari" <mudasar_ansari@.hotmail.com> wrote in message
> news:%236r98J9kEHA.3648@.TK2MSFTNGP09.phx.gbl...
> various
>

Power Point Presentation

hi Gurus,
I need the resource where I can find the Power point presentation on various
topics of SQL server.
Thanks in advance
AnsariUse link in my signature, check Technical Resources.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"M.M Ansari" <mudasar_ansari@.hotmail.com> wrote in message
news:%236r98J9kEHA.3648@.TK2MSFTNGP09.phx.gbl...
> hi Gurus,
> I need the resource where I can find the Power point presentation on
various
> topics of SQL server.
> Thanks in advance
> Ansari
>
>|||Thanks a lot.. :)
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:uEFAvW9kEHA.3520@.TK2MSFTNGP11.phx.gbl...
> Use link in my signature, check Technical Resources.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> Solid Quality Learning
> More than just Training
> www.SolidQualityLearning.com
> "M.M Ansari" <mudasar_ansari@.hotmail.com> wrote in message
> news:%236r98J9kEHA.3648@.TK2MSFTNGP09.phx.gbl...
> > hi Gurus,
> >
> > I need the resource where I can find the Power point presentation on
> various
> > topics of SQL server.
> >
> > Thanks in advance
> >
> > Ansari
> >
> >
> >
> >
>

power point

dear all

i have problem

when i copy presentation from pc to pc the bullets and numbering change

i use power point 2003

shall i found solution

Hello - you are in the SQL Server Documentation forum. You might find more information here:

http://office.microsoft.com/en-us/help/FX100485361033.aspx?pid=CL100605171033

Buck Woody

POWER function

Hello,

I'm trying to follow a specification here:

W1 = (W0^0.333 + G * D/1000)^3 (the ^ symbol means 'to the power')

In my stored procedure I have used the following test data with unexpected results. Can anyone tell me if I'm using POWER properly?

@.Value = POWER(((POWER(150,(1/3))+ 2)* 10/1000),3)

Thanks

I think you are adding parentheses that are forcing a different order of arguments than the original. Here is what the original equation looks like with parentheses:

W1 = ( W0^(1/3) + ( G * D/1000) )^3

Your equation is written like this:

Val = ( (150^(1/3) + 2) * 10/1000 ) ^3|||Thanks Darrell, you're right about the parentheses. However, even with the correction and replacing '1/3' with 0.3333 (which makes a difference) - the results are still out - we expect the @.Value to be 150+ and it's only 125+. But you think the nested POWER function is OK? Or should I do this in 2 seperate statements?|||

Do you have to multiply G with D before dividing it by 1000? Maybe you miss a parenthesis with G*D.

W1 = ( W0^(1/3) + ((G * D)/1000) )^3

|||

Thanks, but tried that with no improvement. I've read elsewhere that "SQL server does not have a datatype for fractions and instead uses an approximate datatype such as float, where rounding will occur. Float has a maximum precision of 15 digits." Does this mean that trying to get a cube root with POWER is indeterminate? Has anyone by any chance written a function for getting cube roots? At the moment POWER is giving me 5 as a cube root of 150 - which is way out.

set

@.value=POWER(150,1.00/3.00)|||

Here are the relevant links and by Microsoft docs there is no indication the POWER function in SQL Server is none deterministic and yes it is FLOAT dependent. The links below will take you in the right direction. Hope this helps.

http://msdn2.microsoft.com/en-us/library/ms173773.aspx
http://msdn2.microsoft.com/en-us/library/ms174276.aspx
http://msdn2.microsoft.com/en-us/library/ms177516.aspx

|||

Caddre,

I'm having a 'duh' moment! Thanks for that- making the value being acted on convertible to float (150.00 instead of 150) gave the result we were looking for.

|||

ashaig:

Caddre,

I'm having a 'duh' moment! Thanks for that- making the value being acted on convertible to float (150.00 instead of 150) gave the result we were looking for.

I am glad I could help and you are not alone most people don't know that most are FLOAT dependent.

|||

Try this one, you can always change the precision to max.

POWER(CONVERT(float, 150), 0.333)

Power failure->Sharepoint DB with torn page

Hi guys!
I'd really appreciate some help and directions about a sql server issue: I
had failure on my server (the fan of a cpu's got broken so the system
ungracefully stopped due to the overheat protection of the CPU). It's running
SBS 2003 premium with sharepoint on SQL 2000.
I was able to get the system back online (had some trobules with the RAID
array but got it fixed) and I was able to have a snapshot of the files just
in case I should be in need to get back to the "original" situation.
Due to the RAID unalignment, my DBs are someway corrupt and I've got a 106MB
sharepoint DB that I'd love to recover.
I already tried to ask for help in the italian sql server newsgroup but no
one was able to help me. What's more, I can't ask for microsoft online
support as they only support english platforms (perhaps I could give it a
try, I mean, the problem would still be exactly the same).
Now the situation is that I've got the mdf and ldf files (I can't use
backups as I need some recent data that still wasn't backed up) and the DB
has a torn page that I'm unable (don't know how) to recover from. Here's what
I get in the event viewer:
Tipo evento: Errore
Origine evento: MSSQL$SHAREPOINT
Categoria evento: (2)
ID evento: 17055
Data: 11/06/2005
Ora: 12.46.51
Utente: TIBERTI\Administrator
Computer: TWINTIB
Descrizione:
18052 :
Errore: 823, gravità : 24, stato: 2.
Per ulteriori informazioni, consultare la Guida in linea e supporto tecnico
all'indirizzo http://go.microsoft.com/fwlink/events.asp.
Dati:
0000: 84 46 00 00 10 00 00 00 â'F.....
0008: 13 00 00 00 54 00 57 00 ...T.W.
0010: 49 00 4e 00 54 00 49 00 I.N.T.I.
0018: 42 00 5c 00 53 00 48 00 B.\.S.H.
0020: 41 00 52 00 45 00 50 00 A.R.E.P.
0028: 4f 00 49 00 4e 00 54 00 O.I.N.T.
0030: 00 00 0a 00 00 00 6f 00 .....o.
0038: 6c 00 64 00 6d 00 61 00 l.d.m.a.
0040: 73 00 74 00 65 00 72 00 s.t.e.r.
0048: 00 00 ..
Tipo evento: Errore
Origine evento: MSSQL$SHAREPOINT
Categoria evento: (2)
ID evento: 17052
Data: 11/06/2005
Ora: 12.46.51
Utente: TIBERTI\Administrator
Computer: TWINTIB
Descrizione:
Errore: 823, gravità : 24, stato: 2
I/O error (torn page) detected during read at offset 0x00000000318000 in
file 'F:\Programmi\Microsoft SQL
Server\MSSQL$SHAREPOINT\Data\oldmaster.mdf'.
Per ulteriori informazioni, consultare la Guida in linea e supporto tecnico
all'indirizzo http://go.microsoft.com/fwlink/events.asp.
Dati:
0000: 37 03 00 00 18 00 00 00 7......
0008: 13 00 00 00 54 00 57 00 ...T.W.
0010: 49 00 4e 00 54 00 49 00 I.N.T.I.
0018: 42 00 5c 00 53 00 48 00 B.\.S.H.
0020: 41 00 52 00 45 00 50 00 A.R.E.P.
0028: 4f 00 49 00 4e 00 54 00 O.I.N.T.
0030: 00 00 0a 00 00 00 6f 00 .....o.
0038: 6c 00 64 00 6d 00 61 00 l.d.m.a.
0040: 73 00 74 00 65 00 72 00 s.t.e.r.
0048: 00 00 ..
Tipo evento: Errore
Origine evento: MSSQL$SHAREPOINT
Categoria evento: (2)
ID evento: 17052
Data: 11/06/2005
Ora: 12.48.06
Utente: TIBERTI\Administrator
Computer: TWINTIB
Descrizione:
Errore: 823, gravità : 24, stato: 6
I/O error (torn page) detected during read at offset 0000000000000000 in
file 'F:\Programmi\Microsoft SQL
Server\MSSQL$SHAREPOINT\Data\STS_content.mdf'.
Per ulteriori informazioni, consultare la Guida in linea e supporto tecnico
all'indirizzo http://go.microsoft.com/fwlink/events.asp.
Dati:
0000: 37 03 00 00 18 00 00 00 7......
0008: 13 00 00 00 54 00 57 00 ...T.W.
0010: 49 00 4e 00 54 00 49 00 I.N.T.I.
0018: 42 00 5c 00 53 00 48 00 B.\.S.H.
0020: 41 00 52 00 45 00 50 00 A.R.E.P.
0028: 4f 00 49 00 4e 00 54 00 O.I.N.T.
0030: 00 00 07 00 00 00 6d 00 .....m.
0038: 61 00 73 00 74 00 65 00 a.s.t.e.
0040: 72 00 00 00 r...
I've already tried with tools to recover data from DBs (SQLRecovery) but it
obviusly wasn't able to recover the data saved from sharepoint...
What I'm looking for is: some directions (I am a system engineer even if I
don't work on databases but I can deal with that under correct guidance) on
how to fix this or how to obtain support from microsoft for an affordable
price (I'm a freelance consultant and MAPS subscriber and I already had to
spend much money for the RAID disks to get recovered and can't spend a
fortune on this).
thanks to you all!
AlessandroIt would be helfpul to know in more detail what you have done.
Is it really the master database which is corrupted or another
database?
Only the mdf file, not the ldf file right?
And you're unable to do any recovery of the file whatsoever?
Mark|||Hi Mark,
First of all thanks for answering. Coming to your questions to help me:
The master DB is not ok but that's not a problem. Once in the past I was
able to recover a sharepoint site from the DBs that conteined it just by
installing a new sql server with the same previous name, attaching the old
(good) content DB and make sharepoint point to it. And, I was able to
install a new instance of the SQL server, create a config and contents db
(those that are used by sharepoint), stop the sql server instance, replace
the "empty" files with the one I recovered and that's how I got into the
torn page error.
I have both the mdf and ldf files. I'm able to recover old copies of the DBs
(including the master) but in which the contents are not up to date.
If you should need further informations, please ask.
Greetings, and thank once again,
Alessandro
<markandersen@.evare.com> ha scritto nel messaggio
news:1120589924.726106.226510@.g44g2000cwa.googlegroups.com...
> It would be helfpul to know in more detail what you have done.
> Is it really the master database which is corrupted or another
> database?
> Only the mdf file, not the ldf file right?
> And you're unable to do any recovery of the file whatsoever?
> Mark
>|||What you should have done it to do regular transaction log backups. If you'd done that, you could
now just do a log backup, restore the most recent clean db backup and then all log backup. Zero data
loss.
In your situation, you could consider exporting all tables and objects to a new database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alessandro Tiberti" <Alessandro Tiberti@.discussions.microsoft.com> wrote in message
news:A3A7DE8B-5FFE-4BAE-987C-9B634CF6E219@.microsoft.com...
> Hi guys!
> I'd really appreciate some help and directions about a sql server issue: I
> had failure on my server (the fan of a cpu's got broken so the system
> ungracefully stopped due to the overheat protection of the CPU). It's running
> SBS 2003 premium with sharepoint on SQL 2000.
> I was able to get the system back online (had some trobules with the RAID
> array but got it fixed) and I was able to have a snapshot of the files just
> in case I should be in need to get back to the "original" situation.
> Due to the RAID unalignment, my DBs are someway corrupt and I've got a 106MB
> sharepoint DB that I'd love to recover.
> I already tried to ask for help in the italian sql server newsgroup but no
> one was able to help me. What's more, I can't ask for microsoft online
> support as they only support english platforms (perhaps I could give it a
> try, I mean, the problem would still be exactly the same).
> Now the situation is that I've got the mdf and ldf files (I can't use
> backups as I need some recent data that still wasn't backed up) and the DB
> has a torn page that I'm unable (don't know how) to recover from. Here's what
> I get in the event viewer:
> Tipo evento: Errore
> Origine evento: MSSQL$SHAREPOINT
> Categoria evento: (2)
> ID evento: 17055
> Data: 11/06/2005
> Ora: 12.46.51
> Utente: TIBERTI\Administrator
> Computer: TWINTIB
> Descrizione:
> 18052 :
> Errore: 823, gravità : 24, stato: 2.
>
> Per ulteriori informazioni, consultare la Guida in linea e supporto tecnico
> all'indirizzo http://go.microsoft.com/fwlink/events.asp.
> Dati:
> 0000: 84 46 00 00 10 00 00 00 â'F.....
> 0008: 13 00 00 00 54 00 57 00 ...T.W.
> 0010: 49 00 4e 00 54 00 49 00 I.N.T.I.
> 0018: 42 00 5c 00 53 00 48 00 B.\.S.H.
> 0020: 41 00 52 00 45 00 50 00 A.R.E.P.
> 0028: 4f 00 49 00 4e 00 54 00 O.I.N.T.
> 0030: 00 00 0a 00 00 00 6f 00 .....o.
> 0038: 6c 00 64 00 6d 00 61 00 l.d.m.a.
> 0040: 73 00 74 00 65 00 72 00 s.t.e.r.
> 0048: 00 00 ..
> Tipo evento: Errore
> Origine evento: MSSQL$SHAREPOINT
> Categoria evento: (2)
> ID evento: 17052
> Data: 11/06/2005
> Ora: 12.46.51
> Utente: TIBERTI\Administrator
> Computer: TWINTIB
> Descrizione:
> Errore: 823, gravità : 24, stato: 2
> I/O error (torn page) detected during read at offset 0x00000000318000 in
> file 'F:\Programmi\Microsoft SQL
> Server\MSSQL$SHAREPOINT\Data\oldmaster.mdf'.
> Per ulteriori informazioni, consultare la Guida in linea e supporto tecnico
> all'indirizzo http://go.microsoft.com/fwlink/events.asp.
> Dati:
> 0000: 37 03 00 00 18 00 00 00 7......
> 0008: 13 00 00 00 54 00 57 00 ...T.W.
> 0010: 49 00 4e 00 54 00 49 00 I.N.T.I.
> 0018: 42 00 5c 00 53 00 48 00 B.\.S.H.
> 0020: 41 00 52 00 45 00 50 00 A.R.E.P.
> 0028: 4f 00 49 00 4e 00 54 00 O.I.N.T.
> 0030: 00 00 0a 00 00 00 6f 00 .....o.
> 0038: 6c 00 64 00 6d 00 61 00 l.d.m.a.
> 0040: 73 00 74 00 65 00 72 00 s.t.e.r.
> 0048: 00 00 ..
> Tipo evento: Errore
> Origine evento: MSSQL$SHAREPOINT
> Categoria evento: (2)
> ID evento: 17052
> Data: 11/06/2005
> Ora: 12.48.06
> Utente: TIBERTI\Administrator
> Computer: TWINTIB
> Descrizione:
> Errore: 823, gravità : 24, stato: 6
> I/O error (torn page) detected during read at offset 0000000000000000 in
> file 'F:\Programmi\Microsoft SQL
> Server\MSSQL$SHAREPOINT\Data\STS_content.mdf'.
> Per ulteriori informazioni, consultare la Guida in linea e supporto tecnico
> all'indirizzo http://go.microsoft.com/fwlink/events.asp.
> Dati:
> 0000: 37 03 00 00 18 00 00 00 7......
> 0008: 13 00 00 00 54 00 57 00 ...T.W.
> 0010: 49 00 4e 00 54 00 49 00 I.N.T.I.
> 0018: 42 00 5c 00 53 00 48 00 B.\.S.H.
> 0020: 41 00 52 00 45 00 50 00 A.R.E.P.
> 0028: 4f 00 49 00 4e 00 54 00 O.I.N.T.
> 0030: 00 00 07 00 00 00 6d 00 .....m.
> 0038: 61 00 73 00 74 00 65 00 a.s.t.e.
> 0040: 72 00 00 00 r...
> I've already tried with tools to recover data from DBs (SQLRecovery) but it
> obviusly wasn't able to recover the data saved from sharepoint...
> What I'm looking for is: some directions (I am a system engineer even if I
> don't work on databases but I can deal with that under correct guidance) on
> how to fix this or how to obtain support from microsoft for an affordable
> price (I'm a freelance consultant and MAPS subscriber and I already had to
> spend much money for the RAID disks to get recovered and can't spend a
> fortune on this).
> thanks to you all!
> Alessandro|||as stated in a previous post in microsoft.public.it.sq
(http://groups.google.it/group/microsoft.public.it.sql/browse_frm/thread/4a416e2d1cbfdb89/bd56532ea25dab83?q=tiberti+sql&rnum=4&hl=it#bd56532ea25dab83),
I creted a new instance, created a new db in it with the STS_content name
(the same as the previous one), stopped the instance, replaced the new empty
files (mdf and ldf) with the old full ones, brought back sql service online
and then tried to remove the torn page check following the procedure
explained at
http://www.google.com/url?sa=D&q=http://www.google.it/groups%3Fselm%3D356mcjF4klli...%40individual.net
but I was unsuccesful:
USE master
GO
ALTER DATABASE STS_content
SET TORN_PAGE_DETECTION OFF
USE master
GO
sp_configure 'allow updates', 1
GO
RECONFIGURE WITH OVERRIDE
GO
sp_resetstatus STS_content
sp_configure 'allow updates', 0
GO
RECONFIGURE WITH OVERRIDE
GO
but the DB still remains in emergency status
I then received other directions to follow:
http://www.google.com/url?sa=D&q=http://www.google.it/groups%3Fselm%3Dbbo917%24bvd1...%40ID-154627.news.dfncis.de
but when a try to rebuild the DB I get:
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionChe­ckForData
(CheckforData()).
Server: messaggio 11, livello 16, stato 1, riga 0
Errore di rete generico. Controllare la documentazione della rete.
Connessione interrotta.
if you need the english translations of the messages, let me know.
<markandersen@.evare.com> ha scritto nel messaggio
news:1120589924.726106.226510@.g44g2000cwa.googlegroups.com...
> It would be helfpul to know in more detail what you have done.
> Is it really the master database which is corrupted or another
> database?
> Only the mdf file, not the ldf file right?
> And you're unable to do any recovery of the file whatsoever?
> Mark
>|||Tibor (hope that's your first name),
the problem is: being unexperienced with SQL I don't know how to get out
tables/objects from there... the only thing I was able to do following some
directions was to start the DB in emergency mode so the DB was accessible...
I had some mail exchange with Mark that I'd love to share (after getting his
permission BTW) with others hoping that could be of any help. Greetings,
Alessandro
Alessandro,
Enterprise Manager has a section entitled
"Management/DatabaseMaintenancePlans". If you simply upgraded, then I would
look there to see about backups.
You could search your harddrive for files based on how recent they are as
another tool to locating backups. They don't have any own suffix, although
.TRN is a default suffix to look for.
I am unfamiliar with sqlrecovery. When I searched for it I found
www.sql-server-repair.com which might be of interest to you. also
www.sqlrecovery.net. What is your sqlrecovery tool?
Mark Andersen
--Original Message--
From: Alessandro Tiberti [mailto:alessandro@.tiberti.it]
Sent: Friday, July 08, 2005 10:33 AM
To: Andersen, Mark
Subject: R: Power failure->Sharepoint DB with torn page
Sorry for bring so ignorant about that subject. i was using the basic
sharepoint db installation (which uses msde) and then upgraded to SQL. I don't
know if there were transaction logs backups or not, how can I check it?
Enterprise manager? Looking for files with particular extension?
Greetings,
Alessandro
PS: the pdf you saw is the report about the data that the recovery service
could export from the corrupt db using a quite common and well known
software called sqlrecovery divided DB by DB and I sent it to you just to
make you see the difference between the data they are able to export and the
size of the DB (most probably 'cause sqlrecovery doesn't recognize files
stored in the SQL db as they are probably stored in a proprietary
format/data type):
----
Da: Andersen, Mark [mailto:MarkA@.evare.com]
Inviato: venerdì 8 luglio 2005 16.15
A: Alessandro Tiberti
Oggetto: RE: Power failure->Sharepoint DB with torn page
You can share these emails.
I could not tell from the attachment what all those files are.
Did you have log backups running regularly on yoru server? You should
have had a dbmaintenance plan running (or some other script) every X hours
backing up the transaction logs. This is usually done more frequently than
a full backup.
The restore procedure is to get the last good full backup (not the .mdf
file but the sql backup!) and then restore it, followed by all log backups.
You can restore at least to the point of the torn page, perhaps further.
If you do not have any full or log backups and all you have is an mdf
file, the best I can suggest is that you go back to the last .mdf file which
you backed up. Presumably you backup the .mdf and .ldf files from time to
time. However, I am unsure that such a backup will really work unless sql
server was offline when the .mdf and .ldf file were backed up as you would
have two files which are not synchronized.
***
Do you have a full database backup? Do you have a series of transaction
log backups/dumps?
Mark Andersen
781-270-5501 (work)
781-307-1944 (cell)
--Original Message--
From: Alessandro Tiberti [mailto:alessandro@.tiberti.it]
Sent: Friday, July 08, 2005 5:26 AM
To: Andersen, Mark
Subject: R: Power failure->Sharepoint DB with torn page
First of all thanks for helping.
What I was actually trying to do is to start the db in emergency mode
and try to remove the torn page detection and try to access it just to
recover the data from sharepoint. Probably something would be missing but
most of them should be ok. but as I am not a SQL specialist I had troubles
following pthe procedures to fix that (I was only able to make the db in
emergency mode). Another chance would be to bring up the db in emergency
mode and copy all the data/tables/don't know what's the appropriate word
into another fresh db and then bring it up in place of the corrupted one.
These should be the things that most probably would help me stating to
what other italian sql MVPs told me. I also tried to ask for data recovery
but I saw that the data that can be restored is probably unuseful looking at
it's dimension (see the attached pdf file) as many picture images and other
files where in the sharepoint repository (so in the DB itself). Anyway,
2/3MBs out of 106 are nearly nothing, I would probably get more from the feb
backup.
Greetings once more!
Alessandro
PS: I'd like to share all this with the NG, would you mind as these were
private emails?
----
Da: Andersen, Mark [mailto:MarkA@.evare.com]
Inviato: giovedì 7 luglio 2005 22.05
A: Alessandro Tiberti
Oggetto: RE: Power failure->Sharepoint DB with torn page
Got the file. Yes, I get a torn page error trying to restore from the
.mdf file.
If that occurs, I believe you have to restore from your last known
backup and transaction logs. I guess that is what i thought you were going
to provide. Have you tried to restore from that?
If you don't have transaction log backups then you cannot restore.
There might be companies which could edit your file and try to restore it
that way, but that's a fairly specialized service.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> ha
scritto nel messaggio news:%23AKtRvfgFHA.2896@.TK2MSFTNGP09.phx.gbl...
> What you should have done it to do regular transaction log backups. If
> you'd done that, you could now just do a log backup, restore the most
> recent clean db backup and then all log backup. Zero data loss.
> In your situation, you could consider exporting all tables and objects to
> a new database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/sql

Power failure->Sharepoint DB with torn page

Hi guys!
I'd really appreciate some help and directions about a sql server issue: I
had failure on my server (the fan of a cpu's got broken so the system
ungracefully stopped due to the overheat protection of the CPU). It's running
SBS 2003 premium with sharepoint on SQL 2000.
I was able to get the system back online (had some trobules with the RAID
array but got it fixed) and I was able to have a snapshot of the files just
in case I should be in need to get back to the "original" situation.
Due to the RAID unalignment, my DBs are someway corrupt and I've got a 106MB
sharepoint DB that I'd love to recover.
I already tried to ask for help in the italian sql server newsgroup but no
one was able to help me. What's more, I can't ask for microsoft online
support as they only support english platforms (perhaps I could give it a
try, I mean, the problem would still be exactly the same).
Now the situation is that I've got the mdf and ldf files (I can't use
backups as I need some recent data that still wasn't backed up) and the DB
has a torn page that I'm unable (don't know how) to recover from. Here's what
I get in the event viewer:
Tipo evento: Errore
Origine evento: MSSQL$SHAREPOINT
Categoria evento: (2)
ID evento: 17055
Data: 11/06/2005
Ora: 12.46.51
Utente: TIBERTI\Administrator
Computer: TWINTIB
Descrizione:
18052 :
Errore: 823, gravitX: 24, stato: 2.
Per ulteriori informazioni, consultare la Guida in linea e supporto tecnico
all'indirizzo http://go.microsoft.com/fwlink/events.asp.
Dati:
0000: 84 46 00 00 10 00 00 00 ?F.....
0008: 13 00 00 00 54 00 57 00 ...T.W.
0010: 49 00 4e 00 54 00 49 00 I.N.T.I.
0018: 42 00 5c 00 53 00 48 00 B.\.S.H.
0020: 41 00 52 00 45 00 50 00 A.R.E.P.
0028: 4f 00 49 00 4e 00 54 00 O.I.N.T.
0030: 00 00 0a 00 00 00 6f 00 .....o.
0038: 6c 00 64 00 6d 00 61 00 l.d.m.a.
0040: 73 00 74 00 65 00 72 00 s.t.e.r.
0048: 00 00 ..
Tipo evento: Errore
Origine evento: MSSQL$SHAREPOINT
Categoria evento: (2)
ID evento: 17052
Data: 11/06/2005
Ora: 12.46.51
Utente: TIBERTI\Administrator
Computer: TWINTIB
Descrizione:
Errore: 823, gravitX: 24, stato: 2
I/O error (torn page) detected during read at offset 0x00000000318000 in
file 'F:\Programmi\Microsoft SQL
Server\MSSQL$SHAREPOINT\Data\oldmaster.mdf'.
Per ulteriori informazioni, consultare la Guida in linea e supporto tecnico
all'indirizzo http://go.microsoft.com/fwlink/events.asp.
Dati:
0000: 37 03 00 00 18 00 00 00 7......
0008: 13 00 00 00 54 00 57 00 ...T.W.
0010: 49 00 4e 00 54 00 49 00 I.N.T.I.
0018: 42 00 5c 00 53 00 48 00 B.\.S.H.
0020: 41 00 52 00 45 00 50 00 A.R.E.P.
0028: 4f 00 49 00 4e 00 54 00 O.I.N.T.
0030: 00 00 0a 00 00 00 6f 00 .....o.
0038: 6c 00 64 00 6d 00 61 00 l.d.m.a.
0040: 73 00 74 00 65 00 72 00 s.t.e.r.
0048: 00 00 ..
Tipo evento: Errore
Origine evento: MSSQL$SHAREPOINT
Categoria evento: (2)
ID evento: 17052
Data: 11/06/2005
Ora: 12.48.06
Utente: TIBERTI\Administrator
Computer: TWINTIB
Descrizione:
Errore: 823, gravitX: 24, stato: 6
I/O error (torn page) detected during read at offset 0000000000000000 in
file 'F:\Programmi\Microsoft SQL
Server\MSSQL$SHAREPOINT\Data\STS_content.mdf'.
Per ulteriori informazioni, consultare la Guida in linea e supporto tecnico
all'indirizzo http://go.microsoft.com/fwlink/events.asp.
Dati:
0000: 37 03 00 00 18 00 00 00 7......
0008: 13 00 00 00 54 00 57 00 ...T.W.
0010: 49 00 4e 00 54 00 49 00 I.N.T.I.
0018: 42 00 5c 00 53 00 48 00 B.\.S.H.
0020: 41 00 52 00 45 00 50 00 A.R.E.P.
0028: 4f 00 49 00 4e 00 54 00 O.I.N.T.
0030: 00 00 07 00 00 00 6d 00 .....m.
0038: 61 00 73 00 74 00 65 00 a.s.t.e.
0040: 72 00 00 00 r...
I've already tried with tools to recover data from DBs (SQLRecovery) but it
obviusly wasn't able to recover the data saved from sharepoint...
What I'm looking for is: some directions (I am a system engineer even if I
don't work on databases but I can deal with that under correct guidance) on
how to fix this or how to obtain support from microsoft for an affordable
price (I'm a freelance consultant and MAPS subscriber and I already had to
spend much money for the RAID disks to get recovered and can't spend a
fortune on this).
thanks to you all!
Alessandro
It would be helfpul to know in more detail what you have done.
Is it really the master database which is corrupted or another
database?
Only the mdf file, not the ldf file right?
And you're unable to do any recovery of the file whatsoever?
Mark
|||Hi Mark,
First of all thanks for answering. Coming to your questions to help me:
The master DB is not ok but that's not a problem. Once in the past I was
able to recover a sharepoint site from the DBs that conteined it just by
installing a new sql server with the same previous name, attaching the old
(good) content DB and make sharepoint point to it. And, I was able to
install a new instance of the SQL server, create a config and contents db
(those that are used by sharepoint), stop the sql server instance, replace
the "empty" files with the one I recovered and that's how I got into the
torn page error.
I have both the mdf and ldf files. I'm able to recover old copies of the DBs
(including the master) but in which the contents are not up to date.
If you should need further informations, please ask.
Greetings, and thank once again,
Alessandro
<markandersen@.evare.com> ha scritto nel messaggio
news:1120589924.726106.226510@.g44g2000cwa.googlegr oups.com...
> It would be helfpul to know in more detail what you have done.
> Is it really the master database which is corrupted or another
> database?
> Only the mdf file, not the ldf file right?
> And you're unable to do any recovery of the file whatsoever?
> Mark
>
|||What you should have done it to do regular transaction log backups. If you'd done that, you could
now just do a log backup, restore the most recent clean db backup and then all log backup. Zero data
loss.
In your situation, you could consider exporting all tables and objects to a new database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alessandro Tiberti" <Alessandro Tiberti@.discussions.microsoft.com> wrote in message
news:A3A7DE8B-5FFE-4BAE-987C-9B634CF6E219@.microsoft.com...
> Hi guys!
> I'd really appreciate some help and directions about a sql server issue: I
> had failure on my server (the fan of a cpu's got broken so the system
> ungracefully stopped due to the overheat protection of the CPU). It's running
> SBS 2003 premium with sharepoint on SQL 2000.
> I was able to get the system back online (had some trobules with the RAID
> array but got it fixed) and I was able to have a snapshot of the files just
> in case I should be in need to get back to the "original" situation.
> Due to the RAID unalignment, my DBs are someway corrupt and I've got a 106MB
> sharepoint DB that I'd love to recover.
> I already tried to ask for help in the italian sql server newsgroup but no
> one was able to help me. What's more, I can't ask for microsoft online
> support as they only support english platforms (perhaps I could give it a
> try, I mean, the problem would still be exactly the same).
> Now the situation is that I've got the mdf and ldf files (I can't use
> backups as I need some recent data that still wasn't backed up) and the DB
> has a torn page that I'm unable (don't know how) to recover from. Here's what
> I get in the event viewer:
> Tipo evento: Errore
> Origine evento: MSSQL$SHAREPOINT
> Categoria evento: (2)
> ID evento: 17055
> Data: 11/06/2005
> Ora: 12.46.51
> Utente: TIBERTI\Administrator
> Computer: TWINTIB
> Descrizione:
> 18052 :
> Errore: 823, gravitX: 24, stato: 2.
>
> Per ulteriori informazioni, consultare la Guida in linea e supporto tecnico
> all'indirizzo http://go.microsoft.com/fwlink/events.asp.
> Dati:
> 0000: 84 46 00 00 10 00 00 00 ?F.....
> 0008: 13 00 00 00 54 00 57 00 ...T.W.
> 0010: 49 00 4e 00 54 00 49 00 I.N.T.I.
> 0018: 42 00 5c 00 53 00 48 00 B.\.S.H.
> 0020: 41 00 52 00 45 00 50 00 A.R.E.P.
> 0028: 4f 00 49 00 4e 00 54 00 O.I.N.T.
> 0030: 00 00 0a 00 00 00 6f 00 .....o.
> 0038: 6c 00 64 00 6d 00 61 00 l.d.m.a.
> 0040: 73 00 74 00 65 00 72 00 s.t.e.r.
> 0048: 00 00 ..
> Tipo evento: Errore
> Origine evento: MSSQL$SHAREPOINT
> Categoria evento: (2)
> ID evento: 17052
> Data: 11/06/2005
> Ora: 12.46.51
> Utente: TIBERTI\Administrator
> Computer: TWINTIB
> Descrizione:
> Errore: 823, gravitX: 24, stato: 2
> I/O error (torn page) detected during read at offset 0x00000000318000 in
> file 'F:\Programmi\Microsoft SQL
> Server\MSSQL$SHAREPOINT\Data\oldmaster.mdf'.
> Per ulteriori informazioni, consultare la Guida in linea e supporto tecnico
> all'indirizzo http://go.microsoft.com/fwlink/events.asp.
> Dati:
> 0000: 37 03 00 00 18 00 00 00 7......
> 0008: 13 00 00 00 54 00 57 00 ...T.W.
> 0010: 49 00 4e 00 54 00 49 00 I.N.T.I.
> 0018: 42 00 5c 00 53 00 48 00 B.\.S.H.
> 0020: 41 00 52 00 45 00 50 00 A.R.E.P.
> 0028: 4f 00 49 00 4e 00 54 00 O.I.N.T.
> 0030: 00 00 0a 00 00 00 6f 00 .....o.
> 0038: 6c 00 64 00 6d 00 61 00 l.d.m.a.
> 0040: 73 00 74 00 65 00 72 00 s.t.e.r.
> 0048: 00 00 ..
> Tipo evento: Errore
> Origine evento: MSSQL$SHAREPOINT
> Categoria evento: (2)
> ID evento: 17052
> Data: 11/06/2005
> Ora: 12.48.06
> Utente: TIBERTI\Administrator
> Computer: TWINTIB
> Descrizione:
> Errore: 823, gravitX: 24, stato: 6
> I/O error (torn page) detected during read at offset 0000000000000000 in
> file 'F:\Programmi\Microsoft SQL
> Server\MSSQL$SHAREPOINT\Data\STS_content.mdf'.
> Per ulteriori informazioni, consultare la Guida in linea e supporto tecnico
> all'indirizzo http://go.microsoft.com/fwlink/events.asp.
> Dati:
> 0000: 37 03 00 00 18 00 00 00 7......
> 0008: 13 00 00 00 54 00 57 00 ...T.W.
> 0010: 49 00 4e 00 54 00 49 00 I.N.T.I.
> 0018: 42 00 5c 00 53 00 48 00 B.\.S.H.
> 0020: 41 00 52 00 45 00 50 00 A.R.E.P.
> 0028: 4f 00 49 00 4e 00 54 00 O.I.N.T.
> 0030: 00 00 07 00 00 00 6d 00 .....m.
> 0038: 61 00 73 00 74 00 65 00 a.s.t.e.
> 0040: 72 00 00 00 r...
> I've already tried with tools to recover data from DBs (SQLRecovery) but it
> obviusly wasn't able to recover the data saved from sharepoint...
> What I'm looking for is: some directions (I am a system engineer even if I
> don't work on databases but I can deal with that under correct guidance) on
> how to fix this or how to obtain support from microsoft for an affordable
> price (I'm a freelance consultant and MAPS subscriber and I already had to
> spend much money for the RAID disks to get recovered and can't spend a
> fortune on this).
> thanks to you all!
> Alessandro
|||as stated in a previous post in microsoft.public.it.sq
(http://groups.google.it/group/micros...53 2ea25dab83),
I creted a new instance, created a new db in it with the STS_content name
(the same as the previous one), stopped the instance, replaced the new empty
files (mdf and ldf) with the old full ones, brought back sql service online
and then tried to remove the torn page check following the procedure
explained at
http://www.google.com/url?sa=D&q=htt...individual.net
but I was unsuccesful:
USE master
GO
ALTER DATABASE STS_content
SET TORN_PAGE_DETECTION OFF
USE master
GO
sp_configure 'allow updates', 1
GO
RECONFIGURE WITH OVERRIDE
GO
sp_resetstatus STS_content
sp_configure 'allow updates', 0
GO
RECONFIGURE WITH OVERRIDE
GO
but the DB still remains in emergency status
I then received other directions to follow:
http://www.google.com/url?sa=D&q=htt...news.dfncis.de
but when a try to rebuild the DB I get:
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionCheXckForData
(CheckforData()).
Server: messaggio 11, livello 16, stato 1, riga 0
Errore di rete generico. Controllare la documentazione della rete.
Connessione interrotta.
if you need the english translations of the messages, let me know.
<markandersen@.evare.com> ha scritto nel messaggio
news:1120589924.726106.226510@.g44g2000cwa.googlegr oups.com...
> It would be helfpul to know in more detail what you have done.
> Is it really the master database which is corrupted or another
> database?
> Only the mdf file, not the ldf file right?
> And you're unable to do any recovery of the file whatsoever?
> Mark
>
|||Tibor (hope that's your first name),
the problem is: being unexperienced with SQL I don't know how to get out
tables/objects from there... the only thing I was able to do following some
directions was to start the DB in emergency mode so the DB was accessible...
I had some mail exchange with Mark that I'd love to share (after getting his
permission BTW) with others hoping that could be of any help. Greetings,
Alessandro
Alessandro,
Enterprise Manager has a section entitled
"Management/DatabaseMaintenancePlans". If you simply upgraded, then I would
look there to see about backups.
You could search your harddrive for files based on how recent they are as
another tool to locating backups. They don't have any own suffix, although
..TRN is a default suffix to look for.
I am unfamiliar with sqlrecovery. When I searched for it I found
www.sql-server-repair.com which might be of interest to you. also
www.sqlrecovery.net. What is your sqlrecovery tool?
Mark Andersen
--Original Message--
From: Alessandro Tiberti [mailto:alessandro@.tiberti.it]
Sent: Friday, July 08, 2005 10:33 AM
To: Andersen, Mark
Subject: R: Power failure->Sharepoint DB with torn page
Sorry for bring so ignorant about that subject. i was using the basic
sharepoint db installation (which uses msde) and then upgraded to SQL. I don't
know if there were transaction logs backups or not, how can I check it?
Enterprise manager? Looking for files with particular extension?
Greetings,
Alessandro
PS: the pdf you saw is the report about the data that the recovery service
could export from the corrupt db using a quite common and well known
software called sqlrecovery divided DB by DB and I sent it to you just to
make you see the difference between the data they are able to export and the
size of the DB (most probably 'cause sqlrecovery doesn't recognize files
stored in the SQL db as they are probably stored in a proprietary
format/data type):

Da: Andersen, Mark [mailto:MarkA@.evare.com]
Inviato: venerd 8 luglio 2005 16.15
A: Alessandro Tiberti
Oggetto: RE: Power failure->Sharepoint DB with torn page
You can share these emails.
I could not tell from the attachment what all those files are.
Did you have log backups running regularly on yoru server? You should
have had a dbmaintenance plan running (or some other script) every X hours
backing up the transaction logs. This is usually done more frequently than
a full backup.
The restore procedure is to get the last good full backup (not the .mdf
file but the sql backup!) and then restore it, followed by all log backups.
You can restore at least to the point of the torn page, perhaps further.
If you do not have any full or log backups and all you have is an mdf
file, the best I can suggest is that you go back to the last .mdf file which
you backed up. Presumably you backup the .mdf and .ldf files from time to
time. However, I am unsure that such a backup will really work unless sql
server was offline when the .mdf and .ldf file were backed up as you would
have two files which are not synchronized.
***
Do you have a full database backup? Do you have a series of transaction
log backups/dumps?
Mark Andersen
781-270-5501 (work)
781-307-1944 (cell)
--Original Message--
From: Alessandro Tiberti [mailto:alessandro@.tiberti.it]
Sent: Friday, July 08, 2005 5:26 AM
To: Andersen, Mark
Subject: R: Power failure->Sharepoint DB with torn page
First of all thanks for helping.
What I was actually trying to do is to start the db in emergency mode
and try to remove the torn page detection and try to access it just to
recover the data from sharepoint. Probably something would be missing but
most of them should be ok. but as I am not a SQL specialist I had troubles
following pthe procedures to fix that (I was only able to make the db in
emergency mode). Another chance would be to bring up the db in emergency
mode and copy all the data/tables/don't know what's the appropriate word
into another fresh db and then bring it up in place of the corrupted one.
These should be the things that most probably would help me stating to
what other italian sql MVPs told me. I also tried to ask for data recovery
but I saw that the data that can be restored is probably unuseful looking at
it's dimension (see the attached pdf file) as many picture images and other
files where in the sharepoint repository (so in the DB itself). Anyway,
2/3MBs out of 106 are nearly nothing, I would probably get more from the feb
backup.
Greetings once more!
Alessandro
PS: I'd like to share all this with the NG, would you mind as these were
private emails?

Da: Andersen, Mark [mailto:MarkA@.evare.com]
Inviato: gioved 7 luglio 2005 22.05
A: Alessandro Tiberti
Oggetto: RE: Power failure->Sharepoint DB with torn page
Got the file. Yes, I get a torn page error trying to restore from the
..mdf file.
If that occurs, I believe you have to restore from your last known
backup and transaction logs. I guess that is what i thought you were going
to provide. Have you tried to restore from that?
If you don't have transaction log backups then you cannot restore.
There might be companies which could edit your file and try to restore it
that way, but that's a fairly specialized service.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> ha
scritto nel messaggio news:%23AKtRvfgFHA.2896@.TK2MSFTNGP09.phx.gbl...
> What you should have done it to do regular transaction log backups. If
> you'd done that, you could now just do a log backup, restore the most
> recent clean db backup and then all log backup. Zero data loss.
> In your situation, you could consider exporting all tables and objects to
> a new database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/

Power failure->Sharepoint DB with torn page

Hi guys!
I'd really appreciate some help and directions about a sql server issue: I
had failure on my server (the fan of a cpu's got broken so the system
ungracefully stopped due to the overheat protection of the CPU). It's runnin
g
SBS 2003 premium with sharepoint on SQL 2000.
I was able to get the system back online (had some trobules with the RAID
array but got it fixed) and I was able to have a snapshot of the files just
in case I should be in need to get back to the "original" situation.
Due to the RAID unalignment, my DBs are someway corrupt and I've got a 106MB
sharepoint DB that I'd love to recover.
I already tried to ask for help in the italian sql server newsgroup but no
one was able to help me. What's more, I can't ask for microsoft online
support as they only support english platforms (perhaps I could give it a
try, I mean, the problem would still be exactly the same).
Now the situation is that I've got the mdf and ldf files (I can't use
backups as I need some recent data that still wasn't backed up) and the DB
has a torn page that I'm unable (don't know how) to recover from. Here's wha
t
I get in the event viewer:
Tipo evento: Errore
Origine evento: MSSQL$SHAREPOINT
Categoria evento: (2)
ID evento: 17055
Data: 11/06/2005
Ora: 12.46.51
Utente: TIBERTI\Administrator
Computer: TWINTIB
Descrizione:
18052 :
Errore: 823, gravit_: 24, stato: 2.
Per ulteriori informazioni, consultare la Guida in linea e supporto tecnico
all'indirizzo http://go.microsoft.com/fwlink/events.asp.
Dati:
0000: 84 46 00 00 10 00 00 00 ?F.....
0008: 13 00 00 00 54 00 57 00 ...T.W.
0010: 49 00 4e 00 54 00 49 00 I.N.T.I.
0018: 42 00 5c 00 53 00 48 00 B.\.S.H.
0020: 41 00 52 00 45 00 50 00 A.R.E.P.
0028: 4f 00 49 00 4e 00 54 00 O.I.N.T.
0030: 00 00 0a 00 00 00 6f 00 .....o.
0038: 6c 00 64 00 6d 00 61 00 l.d.m.a.
0040: 73 00 74 00 65 00 72 00 s.t.e.r.
0048: 00 00 ..
Tipo evento: Errore
Origine evento: MSSQL$SHAREPOINT
Categoria evento: (2)
ID evento: 17052
Data: 11/06/2005
Ora: 12.46.51
Utente: TIBERTI\Administrator
Computer: TWINTIB
Descrizione:
Errore: 823, gravit_: 24, stato: 2
I/O error (torn page) detected during read at offset 0x00000000318000 in
file 'F:\Programmi\Microsoft SQL
Server\MSSQL$SHAREPOINT\Data\oldmaster.mdf'.
Per ulteriori informazioni, consultare la Guida in linea e supporto tecnico
all'indirizzo http://go.microsoft.com/fwlink/events.asp.
Dati:
0000: 37 03 00 00 18 00 00 00 7......
0008: 13 00 00 00 54 00 57 00 ...T.W.
0010: 49 00 4e 00 54 00 49 00 I.N.T.I.
0018: 42 00 5c 00 53 00 48 00 B.\.S.H.
0020: 41 00 52 00 45 00 50 00 A.R.E.P.
0028: 4f 00 49 00 4e 00 54 00 O.I.N.T.
0030: 00 00 0a 00 00 00 6f 00 .....o.
0038: 6c 00 64 00 6d 00 61 00 l.d.m.a.
0040: 73 00 74 00 65 00 72 00 s.t.e.r.
0048: 00 00 ..
Tipo evento: Errore
Origine evento: MSSQL$SHAREPOINT
Categoria evento: (2)
ID evento: 17052
Data: 11/06/2005
Ora: 12.48.06
Utente: TIBERTI\Administrator
Computer: TWINTIB
Descrizione:
Errore: 823, gravit_: 24, stato: 6
I/O error (torn page) detected during read at offset 0000000000000000 in
file 'F:\Programmi\Microsoft SQL
Server\MSSQL$SHAREPOINT\Data\STS_content
.mdf'.
Per ulteriori informazioni, consultare la Guida in linea e supporto tecnico
all'indirizzo http://go.microsoft.com/fwlink/events.asp.
Dati:
0000: 37 03 00 00 18 00 00 00 7......
0008: 13 00 00 00 54 00 57 00 ...T.W.
0010: 49 00 4e 00 54 00 49 00 I.N.T.I.
0018: 42 00 5c 00 53 00 48 00 B.\.S.H.
0020: 41 00 52 00 45 00 50 00 A.R.E.P.
0028: 4f 00 49 00 4e 00 54 00 O.I.N.T.
0030: 00 00 07 00 00 00 6d 00 .....m.
0038: 61 00 73 00 74 00 65 00 a.s.t.e.
0040: 72 00 00 00 r...
I've already tried with tools to recover data from DBs (SQLRecovery) but it
obviusly wasn't able to recover the data saved from sharepoint...
What I'm looking for is: some directions (I am a system engineer even if I
don't work on databases but I can deal with that under correct guidance) on
how to fix this or how to obtain support from microsoft for an affordable
price (I'm a freelance consultant and MAPS subscriber and I already had to
spend much money for the RAID disks to get recovered and can't spend a
fortune on this).
thanks to you all!
AlessandroIt would be helfpul to know in more detail what you have done.
Is it really the master database which is corrupted or another
database?
Only the mdf file, not the ldf file right?
And you're unable to do any recovery of the file whatsoever?
Mark|||Hi Mark,
First of all thanks for answering. Coming to your questions to help me:
The master DB is not ok but that's not a problem. Once in the past I was
able to recover a sharepoint site from the DBs that conteined it just by
installing a new sql server with the same previous name, attaching the old
(good) content DB and make sharepoint point to it. And, I was able to
install a new instance of the SQL server, create a config and contents db
(those that are used by sharepoint), stop the sql server instance, replace
the "empty" files with the one I recovered and that's how I got into the
torn page error.
I have both the mdf and ldf files. I'm able to recover old copies of the DBs
(including the master) but in which the contents are not up to date.
If you should need further informations, please ask.
Greetings, and thank once again,
Alessandro
<markandersen@.evare.com> ha scritto nel messaggio
news:1120589924.726106.226510@.g44g2000cwa.googlegroups.com...
> It would be helfpul to know in more detail what you have done.
> Is it really the master database which is corrupted or another
> database?
> Only the mdf file, not the ldf file right?
> And you're unable to do any recovery of the file whatsoever?
> Mark
>|||What you should have done it to do regular transaction log backups. If you'd
done that, you could
now just do a log backup, restore the most recent clean db backup and then a
ll log backup. Zero data
loss.
In your situation, you could consider exporting all tables and objects to a
new database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Alessandro Tiberti" <Alessandro Tiberti@.discussions.microsoft.com> wrote in
message
news:A3A7DE8B-5FFE-4BAE-987C-9B634CF6E219@.microsoft.com...
> Hi guys!
> I'd really appreciate some help and directions about a sql server issue: I
> had failure on my server (the fan of a cpu's got broken so the system
> ungracefully stopped due to the overheat protection of the CPU). It's runn
ing
> SBS 2003 premium with sharepoint on SQL 2000.
> I was able to get the system back online (had some trobules with the RAID
> array but got it fixed) and I was able to have a snapshot of the files jus
t
> in case I should be in need to get back to the "original" situation.
> Due to the RAID unalignment, my DBs are someway corrupt and I've got a 106
MB
> sharepoint DB that I'd love to recover.
> I already tried to ask for help in the italian sql server newsgroup but no
> one was able to help me. What's more, I can't ask for microsoft online
> support as they only support english platforms (perhaps I could give it a
> try, I mean, the problem would still be exactly the same).
> Now the situation is that I've got the mdf and ldf files (I can't use
> backups as I need some recent data that still wasn't backed up) and the DB
> has a torn page that I'm unable (don't know how) to recover from. Here's w
hat
> I get in the event viewer:
> Tipo evento: Errore
> Origine evento: MSSQL$SHAREPOINT
> Categoria evento: (2)
> ID evento: 17055
> Data: 11/06/2005
> Ora: 12.46.51
> Utente: TIBERTI\Administrator
> Computer: TWINTIB
> Descrizione:
> 18052 :
> Errore: 823, gravit_: 24, stato: 2.
>
> Per ulteriori informazioni, consultare la Guida in linea e supporto tecnic
o
> all'indirizzo http://go.microsoft.com/fwlink/events.asp.
> Dati:
> 0000: 84 46 00 00 10 00 00 00 ?F.....
> 0008: 13 00 00 00 54 00 57 00 ...T.W.
> 0010: 49 00 4e 00 54 00 49 00 I.N.T.I.
> 0018: 42 00 5c 00 53 00 48 00 B.\.S.H.
> 0020: 41 00 52 00 45 00 50 00 A.R.E.P.
> 0028: 4f 00 49 00 4e 00 54 00 O.I.N.T.
> 0030: 00 00 0a 00 00 00 6f 00 .....o.
> 0038: 6c 00 64 00 6d 00 61 00 l.d.m.a.
> 0040: 73 00 74 00 65 00 72 00 s.t.e.r.
> 0048: 00 00 ..
> Tipo evento: Errore
> Origine evento: MSSQL$SHAREPOINT
> Categoria evento: (2)
> ID evento: 17052
> Data: 11/06/2005
> Ora: 12.46.51
> Utente: TIBERTI\Administrator
> Computer: TWINTIB
> Descrizione:
> Errore: 823, gravit_: 24, stato: 2
> I/O error (torn page) detected during read at offset 0x00000000318000 in
> file 'F:\Programmi\Microsoft SQL
> Server\MSSQL$SHAREPOINT\Data\oldmaster.mdf'.
> Per ulteriori informazioni, consultare la Guida in linea e supporto tecnic
o
> all'indirizzo http://go.microsoft.com/fwlink/events.asp.
> Dati:
> 0000: 37 03 00 00 18 00 00 00 7......
> 0008: 13 00 00 00 54 00 57 00 ...T.W.
> 0010: 49 00 4e 00 54 00 49 00 I.N.T.I.
> 0018: 42 00 5c 00 53 00 48 00 B.\.S.H.
> 0020: 41 00 52 00 45 00 50 00 A.R.E.P.
> 0028: 4f 00 49 00 4e 00 54 00 O.I.N.T.
> 0030: 00 00 0a 00 00 00 6f 00 .....o.
> 0038: 6c 00 64 00 6d 00 61 00 l.d.m.a.
> 0040: 73 00 74 00 65 00 72 00 s.t.e.r.
> 0048: 00 00 ..
> Tipo evento: Errore
> Origine evento: MSSQL$SHAREPOINT
> Categoria evento: (2)
> ID evento: 17052
> Data: 11/06/2005
> Ora: 12.48.06
> Utente: TIBERTI\Administrator
> Computer: TWINTIB
> Descrizione:
> Errore: 823, gravit_: 24, stato: 6
> I/O error (torn page) detected during read at offset 0000000000000000 in
> file 'F:\Programmi\Microsoft SQL
> Server\MSSQL$SHAREPOINT\Data\STS_content
.mdf'.
> Per ulteriori informazioni, consultare la Guida in linea e supporto tecnic
o
> all'indirizzo http://go.microsoft.com/fwlink/events.asp.
> Dati:
> 0000: 37 03 00 00 18 00 00 00 7......
> 0008: 13 00 00 00 54 00 57 00 ...T.W.
> 0010: 49 00 4e 00 54 00 49 00 I.N.T.I.
> 0018: 42 00 5c 00 53 00 48 00 B.\.S.H.
> 0020: 41 00 52 00 45 00 50 00 A.R.E.P.
> 0028: 4f 00 49 00 4e 00 54 00 O.I.N.T.
> 0030: 00 00 07 00 00 00 6d 00 .....m.
> 0038: 61 00 73 00 74 00 65 00 a.s.t.e.
> 0040: 72 00 00 00 r...
> I've already tried with tools to recover data from DBs (SQLRecovery) but i
t
> obviusly wasn't able to recover the data saved from sharepoint...
> What I'm looking for is: some directions (I am a system engineer even if I
> don't work on databases but I can deal with that under correct guidance) o
n
> how to fix this or how to obtain support from microsoft for an affordable
> price (I'm a freelance consultant and MAPS subscriber and I already had to
> spend much money for the RAID disks to get recovered and can't spend a
> fortune on this).
> thanks to you all!
> Alessandro|||as stated in a previous post in microsoft.public.it.sq
(http://groups.google.it/group/micro...d56532ea25dab83),
I creted a new instance, created a new db in it with the STS_content name
(the same as the previous one), stopped the instance, replaced the new empty
files (mdf and ldf) with the old full ones, brought back sql service online
and then tried to remove the torn page check following the procedure
explained at
http://www.google.com/url?sa=D&q=ht...0individual.net
but I was unsuccesful:
USE master
GO
ALTER DATABASE STS_content
SET TORN_PAGE_DETECTION OFF
USE master
GO
sp_configure 'allow updates', 1
GO
RECONFIGURE WITH OVERRIDE
GO
sp_resetstatus STS_content
sp_configure 'allow updates', 0
GO
RECONFIGURE WITH OVERRIDE
GO
but the DB still remains in emergency status
I then received other directions to follow:
http://www.google.com/url?sa=D&q=ht...news.dfncis.de
but when a try to rebuild the DB I get:
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionChe_ckFor
Data
(CheckforData()).
Server: messaggio 11, livello 16, stato 1, riga 0
Errore di rete generico. Controllare la documentazione della rete.
Connessione interrotta.
if you need the english translations of the messages, let me know.
<markandersen@.evare.com> ha scritto nel messaggio
news:1120589924.726106.226510@.g44g2000cwa.googlegroups.com...
> It would be helfpul to know in more detail what you have done.
> Is it really the master database which is corrupted or another
> database?
> Only the mdf file, not the ldf file right?
> And you're unable to do any recovery of the file whatsoever?
> Mark
>|||Tibor (hope that's your first name),
the problem is: being unexperienced with SQL I don't know how to get out
tables/objects from there... the only thing I was able to do following some
directions was to start the DB in emergency mode so the DB was accessible...
I had some mail exchange with Mark that I'd love to share (after getting his
permission BTW) with others hoping that could be of any help. Greetings,
Alessandro
Alessandro,
Enterprise Manager has a section entitled
"Management/DatabaseMaintenancePlans". If you simply upgraded, then I would
look there to see about backups.
You could search your harddrive for files based on how recent they are as
another tool to locating backups. They don't have any own suffix, although
.TRN is a default suffix to look for.
I am unfamiliar with sqlrecovery. When I searched for it I found
www.sql-server-repair.com which might be of interest to you. also
www.sqlrecovery.net. What is your sqlrecovery tool?
Mark Andersen
--Original Message--
From: Alessandro Tiberti [mailto:alessandro@.tiberti.it]
Sent: Friday, July 08, 2005 10:33 AM
To: Andersen, Mark
Subject: R: Power failure->Sharepoint DB with torn page
Sorry for bring so ignorant about that subject. i was using the basic
sharepoint db installation (which uses msde) and then upgraded to SQL. I don
't
know if there were transaction logs backups or not, how can I check it?
Enterprise manager? Looking for files with particular extension?
Greetings,
Alessandro
PS: the pdf you saw is the report about the data that the recovery service
could export from the corrupt db using a quite common and well known
software called sqlrecovery divided DB by DB and I sent it to you just to
make you see the difference between the data they are able to export and the
size of the DB (most probably 'cause sqlrecovery doesn't recognize files
stored in the SQL db as they are probably stored in a proprietary
format/data type):
----
--
Da: Andersen, Mark [mailto:MarkA@.evare.com]
Inviato: venerd 8 luglio 2005 16.15
A: Alessandro Tiberti
Oggetto: RE: Power failure->Sharepoint DB with torn page
You can share these emails.
I could not tell from the attachment what all those files are.
Did you have log backups running regularly on yoru server? You should
have had a dbmaintenance plan running (or some other script) every X hours
backing up the transaction logs. This is usually done more frequently than
a full backup.
The restore procedure is to get the last good full backup (not the .mdf
file but the sql backup!) and then restore it, followed by all log backups.
You can restore at least to the point of the torn page, perhaps further.
If you do not have any full or log backups and all you have is an mdf
file, the best I can suggest is that you go back to the last .mdf file which
you backed up. Presumably you backup the .mdf and .ldf files from time to
time. However, I am unsure that such a backup will really work unless sql
server was offline when the .mdf and .ldf file were backed up as you would
have two files which are not synchronized.
***
Do you have a full database backup? Do you have a series of transaction
log backups/dumps?
Mark Andersen
781-270-5501 (work)
781-307-1944 (cell)
--Original Message--
From: Alessandro Tiberti [mailto:alessandro@.tiberti.it]
Sent: Friday, July 08, 2005 5:26 AM
To: Andersen, Mark
Subject: R: Power failure->Sharepoint DB with torn page
First of all thanks for helping.
What I was actually trying to do is to start the db in emergency mode
and try to remove the torn page detection and try to access it just to
recover the data from sharepoint. Probably something would be missing but
most of them should be ok. but as I am not a SQL specialist I had troubles
following pthe procedures to fix that (I was only able to make the db in
emergency mode). Another chance would be to bring up the db in emergency
mode and copy all the data/tables/don't know what's the appropriate word
into another fresh db and then bring it up in place of the corrupted one.
These should be the things that most probably would help me stating to
what other italian sql MVPs told me. I also tried to ask for data recovery
but I saw that the data that can be restored is probably unuseful looking at
it's dimension (see the attached pdf file) as many picture images and other
files where in the sharepoint repository (so in the DB itself). Anyway,
2/3MBs out of 106 are nearly nothing, I would probably get more from the feb
backup.
Greetings once more!
Alessandro
PS: I'd like to share all this with the NG, would you mind as these were
private emails?
----
Da: Andersen, Mark [mailto:MarkA@.evare.com]
Inviato: gioved 7 luglio 2005 22.05
A: Alessandro Tiberti
Oggetto: RE: Power failure->Sharepoint DB with torn page
Got the file. Yes, I get a torn page error trying to restore from the
.mdf file.
If that occurs, I believe you have to restore from your last known
backup and transaction logs. I guess that is what i thought you were going
to provide. Have you tried to restore from that?
If you don't have transaction log backups then you cannot restore.
There might be companies which could edit your file and try to restore it
that way, but that's a fairly specialized service.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> ha
scritto nel messaggio news:%23AKtRvfgFHA.2896@.TK2MSFTNGP09.phx.gbl...
> What you should have done it to do regular transaction log backups. If
> you'd done that, you could now just do a log backup, restore the most
> recent clean db backup and then all log backup. Zero data loss.
> In your situation, you could consider exporting all tables and objects to
> a new database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/

Power failure using simple mode transaction Log

Any comments about what happens when we get a power failure using simple mode
transaction Log?
I had 3 Power failure and there has not been any problems with the data.
The auto recuperation informs that 5343 rows where commited and 0 rolled back.
Can I expect this behaviour in the future? (another power failure).
Note that I have a UPS, but I didn't have time to shutdown properly.
Run DBCC CHECKDB if you haven't already.
You should configure your UPS to shutdown the server automatically after N
minutes of power failure.
David Portas
SQL Server MVP
|||If you have hardware write cache, you need to make sure it is properly backed up, and follows a
certain set of rules. If it does, the database should not go corrupt because of a power failure. If
you don't have hardware write cache, then you probably don't have battery backup and you can see a
torn page. See http://www.microsoft.com/technet/pro...lIObasics.mspx for
full information.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"juan carlos via droptable.com" <forum@.droptable.com> wrote in message
news:51122050ED1E0@.droptable.com...
> Any comments about what happens when we get a power failure using simple mode
> transaction Log?
> I had 3 Power failure and there has not been any problems with the data.
> The auto recuperation informs that 5343 rows where commited and 0 rolled back.
>
> Can I expect this behaviour in the future? (another power failure).
> Note that I have a UPS, but I didn't have time to shutdown properly.

Power failure using simple mode transaction Log

Any comments about what happens when we get a power failure using simple mod
e
transaction Log?
I had 3 Power failure and there has not been any problems with the data.
The auto recuperation informs that 5343 rows where commited and 0 rolled bac
k.
Can I expect this behaviour in the future? (another power failure).
Note that I have a UPS, but I didn't have time to shutdown properly.Run DBCC CHECKDB if you haven't already.
You should configure your UPS to shutdown the server automatically after N
minutes of power failure.
David Portas
SQL Server MVP
--|||If you have hardware write cache, you need to make sure it is properly backe
d up, and follows a
certain set of rules. If it does, the database should not go corrupt because
of a power failure. If
you don't have hardware write cache, then you probably don't have battery ba
ckup and you can see a
torn page. See http://www.microsoft.com/technet/pr...>
Obasics.mspx for
full information.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"juan carlos via droptable.com" <forum@.droptable.com> wrote in message
news:51122050ED1E0@.droptable.com...
> Any comments about what happens when we get a power failure using simple m
ode
> transaction Log?
> I had 3 Power failure and there has not been any problems with the data.
> The auto recuperation informs that 5343 rows where commited and 0 rolled b
ack.
>
> Can I expect this behaviour in the future? (another power failure).
> Note that I have a UPS, but I didn't have time to shutdown properly.

Power failure using simple mode transaction Log

Any comments about what happens when we get a power failure using simple mode
transaction Log?
I had 3 Power failure and there has not been any problems with the data.
The auto recuperation informs that 5343 rows where commited and 0 rolled back.
Can I expect this behaviour in the future? (another power failure).
Note that I have a UPS, but I didn't have time to shutdown properly.Run DBCC CHECKDB if you haven't already.
You should configure your UPS to shutdown the server automatically after N
minutes of power failure.
--
David Portas
SQL Server MVP
--|||If you have hardware write cache, you need to make sure it is properly backed up, and follows a
certain set of rules. If it does, the database should not go corrupt because of a power failure. If
you don't have hardware write cache, then you probably don't have battery backup and you can see a
torn page. See http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx for
full information.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"juan carlos via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:51122050ED1E0@.SQLMonster.com...
> Any comments about what happens when we get a power failure using simple mode
> transaction Log?
> I had 3 Power failure and there has not been any problems with the data.
> The auto recuperation informs that 5343 rows where commited and 0 rolled back.
>
> Can I expect this behaviour in the future? (another power failure).
> Note that I have a UPS, but I didn't have time to shutdown properly.sql

Power Failure for SQL Server 2000

We encounter a power failure for about half an hour and
the SQL Server 2000 is back again.
For production databases, we use FULL Recovery Model with
Transaction Log backed up every half an hour. After power
is up, everything works properly.
I would like to know what happens to the SQL Server 2000
when the power fails and how the data is recovered when
power is up again.
ThanksRegardless of the recovery model, each database is automatically recovered
when the instance starts. Data are read from the transaction log since the
last checkpoint and applied to the database. Uncommitted transactions are
then rolled back. The end result is that the database is recovered to the
point of the failure, less uncommitted transactions.
Your FULL recovery model and log backups provide extra protection in the
event of media loss due to hardware failure or data corruption.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:01f401c5446e$a4183b70$a601280a@.phx.gbl...
> We encounter a power failure for about half an hour and
> the SQL Server 2000 is back again.
> For production databases, we use FULL Recovery Model with
> Transaction Log backed up every half an hour. After power
> is up, everything works properly.
> I would like to know what happens to the SQL Server 2000
> when the power fails and how the data is recovered when
> power is up again.
> Thanks|||Dear Dan,
Thank you for your advice.
However, for SIMPLE Recovery Model, there will be no
transaction log backup. To what state does the database
recovered to ?
Besides, would you mind to elaborate on the extra benefit
of using FULL Recovery Model ?
Thanks again.
>--Original Message--
>Regardless of the recovery model, each database is
automatically recovered
>when the instance starts. Data are read from the
transaction log since the
>last checkpoint and applied to the database. Uncommitted
transactions are
>then rolled back. The end result is that the database is
recovered to the
>point of the failure, less uncommitted transactions.
>Your FULL recovery model and log backups provide extra
protection in the
>event of media loss due to hardware failure or data
corruption.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"Peter" <anonymous@.discussions.microsoft.com> wrote in
message
>news:01f401c5446e$a4183b70$a601280a@.phx.gbl...
>> We encounter a power failure for about half an hour and
>> the SQL Server 2000 is back again.
>> For production databases, we use FULL Recovery Model
with
>> Transaction Log backed up every half an hour. After
power
>> is up, everything works properly.
>> I would like to know what happens to the SQL Server 2000
>> when the power fails and how the data is recovered when
>> power is up again.
>> Thanks
>
>.
>|||Peter
<http://vyaskn.tripod.com/sql_server_administration_best_practices.htm#Step1
> --administaiting best practices
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:077101c54475$9661ee70$a501280a@.phx.gbl...
> Dear Dan,
> Thank you for your advice.
> However, for SIMPLE Recovery Model, there will be no
> transaction log backup. To what state does the database
> recovered to ?
> Besides, would you mind to elaborate on the extra benefit
> of using FULL Recovery Model ?
> Thanks again.
> >--Original Message--
> >Regardless of the recovery model, each database is
> automatically recovered
> >when the instance starts. Data are read from the
> transaction log since the
> >last checkpoint and applied to the database. Uncommitted
> transactions are
> >then rolled back. The end result is that the database is
> recovered to the
> >point of the failure, less uncommitted transactions.
> >
> >Your FULL recovery model and log backups provide extra
> protection in the
> >event of media loss due to hardware failure or data
> corruption.
> >
> >--
> >Hope this helps.
> >
> >Dan Guzman
> >SQL Server MVP
> >
> >"Peter" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:01f401c5446e$a4183b70$a601280a@.phx.gbl...
> >> We encounter a power failure for about half an hour and
> >> the SQL Server 2000 is back again.
> >>
> >> For production databases, we use FULL Recovery Model
> with
> >> Transaction Log backed up every half an hour. After
> power
> >> is up, everything works properly.
> >>
> >> I would like to know what happens to the SQL Server 2000
> >> when the power fails and how the data is recovered when
> >> power is up again.
> >>
> >> Thanks
> >
> >
> >.
> >|||Automatic recovery (what happens when you start SQL Server) doesn't have anything to do with
backups. SQL Server records all modifications in the transaction log, regardless of recovery model.
In simple, SQL Server removes log records from the transaction log when they aren't needed anymore
for this automatic recovery.
Full recovery model allow you to backup transaction log. This has a lot of advantages, like backup
log even of the database becomes corrupt, point in time restore etc.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:077101c54475$9661ee70$a501280a@.phx.gbl...
> Dear Dan,
> Thank you for your advice.
> However, for SIMPLE Recovery Model, there will be no
> transaction log backup. To what state does the database
> recovered to ?
> Besides, would you mind to elaborate on the extra benefit
> of using FULL Recovery Model ?
> Thanks again.
>>--Original Message--
>>Regardless of the recovery model, each database is
> automatically recovered
>>when the instance starts. Data are read from the
> transaction log since the
>>last checkpoint and applied to the database. Uncommitted
> transactions are
>>then rolled back. The end result is that the database is
> recovered to the
>>point of the failure, less uncommitted transactions.
>>Your FULL recovery model and log backups provide extra
> protection in the
>>event of media loss due to hardware failure or data
> corruption.
>>--
>>Hope this helps.
>>Dan Guzman
>>SQL Server MVP
>>"Peter" <anonymous@.discussions.microsoft.com> wrote in
> message
>>news:01f401c5446e$a4183b70$a601280a@.phx.gbl...
>> We encounter a power failure for about half an hour and
>> the SQL Server 2000 is back again.
>> For production databases, we use FULL Recovery Model
> with
>> Transaction Log backed up every half an hour. After
> power
>> is up, everything works properly.
>> I would like to know what happens to the SQL Server 2000
>> when the power fails and how the data is recovered when
>> power is up again.
>> Thanks
>>
>>.|||To add to the other responses, automatic recovery will recover databases to
the same consistent state regardless of the recovery model.
Separately, database and transaction log backups reduce your vulnerability
to potential data loss. For example, if your power outage caused a hardware
problem that corrupted your log file, you could still restore from your most
recent database backup and then apply your log backups. At most, you would
lose one half hour of work. If only data files were lost, you could backup
the current log with NO_TRUNCATE and then restore your database and log
backups. No data would be lost in this case.
In the SIMPLE recovery model, your only recourse after losing data or log
files is to restore from your most recent database backup. All data
modifications since the backup would be lost.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:077101c54475$9661ee70$a501280a@.phx.gbl...
> Dear Dan,
> Thank you for your advice.
> However, for SIMPLE Recovery Model, there will be no
> transaction log backup. To what state does the database
> recovered to ?
> Besides, would you mind to elaborate on the extra benefit
> of using FULL Recovery Model ?
> Thanks again.
>>--Original Message--
>>Regardless of the recovery model, each database is
> automatically recovered
>>when the instance starts. Data are read from the
> transaction log since the
>>last checkpoint and applied to the database. Uncommitted
> transactions are
>>then rolled back. The end result is that the database is
> recovered to the
>>point of the failure, less uncommitted transactions.
>>Your FULL recovery model and log backups provide extra
> protection in the
>>event of media loss due to hardware failure or data
> corruption.
>>--
>>Hope this helps.
>>Dan Guzman
>>SQL Server MVP
>>"Peter" <anonymous@.discussions.microsoft.com> wrote in
> message
>>news:01f401c5446e$a4183b70$a601280a@.phx.gbl...
>> We encounter a power failure for about half an hour and
>> the SQL Server 2000 is back again.
>> For production databases, we use FULL Recovery Model
> with
>> Transaction Log backed up every half an hour. After
> power
>> is up, everything works properly.
>> I would like to know what happens to the SQL Server 2000
>> when the power fails and how the data is recovered when
>> power is up again.
>> Thanks
>>
>>.