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)?
>

Posting XMLA to AS from java without msmdpump.dll

I'm simply trying to invoke an Analysis Server CLR assembly procedure using MDX from a non windows machine in a a java environment. I also wish to require as little configuration on the SQL Server machine as possible.

Posting the request via HttpURLConnection as below works.

url = new URL("http://localhost//olap//msmdpump.dll ");
HttpURLConnection con = (HttpURLConnection) url.openConnection();

The question is I'd prefer not to have to require IIS plus the pump to be running on the AS server(msmdpump.dll). We know MS code is sending XMLA to the AS Database.

Why can we not use the same channel? It may not be http but I do not care. I'd rather have minimum stuff to do on the server.

Thanks in advance

Zub

I'd say in this stiuation you are probably better off using HTTP. On windows machine you can use naitive AS client : ADOMD.NET or AS OLEDB, and establish connection using TCP/IP , but coming from outside you will face quite a few problems. Configuring virtual direcory compared to ... for instance trying to figure out how to authenticate your non-windows user if by far easier task.

Hope that helps.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.