Showing posts with label service. Show all posts
Showing posts with label service. Show all posts

Wednesday, March 28, 2012

Raid Array Failure/Rebuild SQL won''t run

Background... Server raid failed, rebuilt raid ran chkdsk but now I am
unable to run SQL service.

I've tried to manually start service but receive the following message

The MSSQLSERVER service on the local computer started and then stopped. Some
services stop automatically if they have no work to do.

Here's all I have in the error logs

2007-08-19 10:56:39.98 server Microsoft SQL Server 2000 - 8.00.2039
(Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2007-08-19 10:56:39.99 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-08-19 10:56:39.99 server All rights reserved.
2007-08-19 10:56:39.99 server Server Process ID is 1812.
2007-08-19 10:56:39.99 server Logging SQL Server messages in file
'f:\MSSQL\log\ERRORLOG'.
2007-08-19 10:56:40.01 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2007-08-19 10:56:40.15 server SQL Server configured for thread mode
processing.
2007-08-19 10:56:40.18 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2007-08-19 10:56:40.23 server Attempting to initialize Distributed
Transaction Coordinator.
2007-08-19 10:56:42.29 spid4 Starting up database 'master'.
2007-08-19 10:56:42.31 spid4 Error: 5172, Severity: 16, State: 15.
2007-08-19 10:56:42.31 spid4 Error: 5173, Severity: 16, State: 1.
2007-08-19 10:56:42.31 spid4 Error: 5180, Severity: 22, State: 1.

Is sql server running under a service account and did you change the pwd ? is there any specific info in the event viewer ?

|||

With some assistance I ran rebuildm.exe and was able to get sql up and running.

I have been able to go through the steps to create a new database of same name then copy originals, restart SQL and bring the databases back in suspect mode.

I'm trying to read up on how to set the databases to emergency mode, check for errors and hopefully bring back to working, normal state....

Raid Array Failure/Rebuild SQL won''t run

Background... Server raid failed, rebuilt raid ran chkdsk but now I am
unable to run SQL service.

I've tried to manually start service but receive the following message

The MSSQLSERVER service on the local computer started and then stopped. Some
services stop automatically if they have no work to do.

Here's all I have in the error logs

2007-08-19 10:56:39.98 server Microsoft SQL Server 2000 - 8.00.2039
(Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2007-08-19 10:56:39.99 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-08-19 10:56:39.99 server All rights reserved.
2007-08-19 10:56:39.99 server Server Process ID is 1812.
2007-08-19 10:56:39.99 server Logging SQL Server messages in file
'f:\MSSQL\log\ERRORLOG'.
2007-08-19 10:56:40.01 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2007-08-19 10:56:40.15 server SQL Server configured for thread mode
processing.
2007-08-19 10:56:40.18 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2007-08-19 10:56:40.23 server Attempting to initialize Distributed
Transaction Coordinator.
2007-08-19 10:56:42.29 spid4 Starting up database 'master'.
2007-08-19 10:56:42.31 spid4 Error: 5172, Severity: 16, State: 15.
2007-08-19 10:56:42.31 spid4 Error: 5173, Severity: 16, State: 1.
2007-08-19 10:56:42.31 spid4 Error: 5180, Severity: 22, State: 1.

Is sql server running under a service account and did you change the pwd ? is there any specific info in the event viewer ?

|||

With some assistance I ran rebuildm.exe and was able to get sql up and running.

I have been able to go through the steps to create a new database of same name then copy originals, restart SQL and bring the databases back in suspect mode.

I'm trying to read up on how to set the databases to emergency mode, check for errors and hopefully bring back to working, normal state....

Raid Array Failure/Rebuild SQL won''t run

Background... Server raid failed, rebuilt raid ran chkdsk but now I am
unable to run SQL service.

I've tried to manually start service but receive the following message

The MSSQLSERVER service on the local computer started and then stopped. Some
services stop automatically if they have no work to do.

Here's all I have in the error logs

2007-08-19 10:56:39.98 server Microsoft SQL Server 2000 - 8.00.2039
(Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2007-08-19 10:56:39.99 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-08-19 10:56:39.99 server All rights reserved.
2007-08-19 10:56:39.99 server Server Process ID is 1812.
2007-08-19 10:56:39.99 server Logging SQL Server messages in file
'f:\MSSQL\log\ERRORLOG'.
2007-08-19 10:56:40.01 server SQL Server is starting at priority class
'normal'(2 CPUs detected).
2007-08-19 10:56:40.15 server SQL Server configured for thread mode
processing.
2007-08-19 10:56:40.18 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2007-08-19 10:56:40.23 server Attempting to initialize Distributed
Transaction Coordinator.
2007-08-19 10:56:42.29 spid4 Starting up database 'master'.
2007-08-19 10:56:42.31 spid4 Error: 5172, Severity: 16, State: 15.
2007-08-19 10:56:42.31 spid4 Error: 5173, Severity: 16, State: 1.
2007-08-19 10:56:42.31 spid4 Error: 5180, Severity: 22, State: 1.

Is sql server running under a service account and did you change the pwd ? is there any specific info in the event viewer ?

|||

With some assistance I ran rebuildm.exe and was able to get sql up and running.

I have been able to go through the steps to create a new database of same name then copy originals, restart SQL and bring the databases back in suspect mode.

I'm trying to read up on how to set the databases to emergency mode, check for errors and hopefully bring back to working, normal state....

Monday, March 26, 2012

RAID & Drive Type for Server?

I'm shopping for a dedicated server service to host my web application that
uses SQL Server 2000 (eventually 2005) with everything on one box (IIS, COM+
application, etc.) although backups will go to a NAS unit. My database is
currently less than 300mb but I would certainly want to accommodate a 3gb+
database and accommodate ten or a hundred concurrent web users as my
business hopefully improves.
One of the hosting companies offers a number of RAID choices. Their choices
include RAID 0 (not fault tolerant - won't be using that), RAID 1 with two
drives, RAID 5 with three drives, and RAID 10 with four drives. There is
apparently NOT the luxury of further configuration options like more drives
using one RAID configuration, mixing RAID flavors with more drives, etc.
There is also the choice between using SATA II drives (7200 or 10000 rpm,
250 to 750gbs - about 200gb more than I will ever need) or SA-SCSI (10 or
15K rpm, 73gb only)
With these constrained choices, what would be your recommendations for the
best redundancy and best fault tolerance where the speed of read-writes is
less of an issue (because no user would ever notice the difference until the
server was running at 50% cpu or more)?
My thought is the more drives the better, the fast the rpm the better, but I
don't know enough about whether SATA drives is the next new thing compared
to SCSI technology, and I don't know whether the difference between RAID 5
or 10 would really make any difference (besides decreasing the chance of
failure with one more drive).
Thanks for any recommendations or thoughts.Given the small size of your database, I'd probably go with RAID 1. It would
give you enough space, less expensive than RAID 10, lower overhead than RAID
5, and better protection than RAID 0. And again given what you described, I'd
probably not want to explore any new(er) technologies, and I would just go
with the mature SCSI, have it set up, get it running and forget about it.
Linchi
"Don Miller" wrote:
> I'm shopping for a dedicated server service to host my web application that
> uses SQL Server 2000 (eventually 2005) with everything on one box (IIS, COM+
> application, etc.) although backups will go to a NAS unit. My database is
> currently less than 300mb but I would certainly want to accommodate a 3gb+
> database and accommodate ten or a hundred concurrent web users as my
> business hopefully improves.
> One of the hosting companies offers a number of RAID choices. Their choices
> include RAID 0 (not fault tolerant - won't be using that), RAID 1 with two
> drives, RAID 5 with three drives, and RAID 10 with four drives. There is
> apparently NOT the luxury of further configuration options like more drives
> using one RAID configuration, mixing RAID flavors with more drives, etc.
> There is also the choice between using SATA II drives (7200 or 10000 rpm,
> 250 to 750gbs - about 200gb more than I will ever need) or SA-SCSI (10 or
> 15K rpm, 73gb only)
> With these constrained choices, what would be your recommendations for the
> best redundancy and best fault tolerance where the speed of read-writes is
> less of an issue (because no user would ever notice the difference until the
> server was running at 50% cpu or more)?
> My thought is the more drives the better, the fast the rpm the better, but I
> don't know enough about whether SATA drives is the next new thing compared
> to SCSI technology, and I don't know whether the difference between RAID 5
> or 10 would really make any difference (besides decreasing the chance of
> failure with one more drive).
> Thanks for any recommendations or thoughts.
>
>|||I tend to agree with Linchi given the small size of the db. Most if not all
of the data should be in cache anyway so there should be very little disk
I/O on a constant basis.
--
Andrew J. Kelly SQL MVP
"Don Miller" <nospam@.nospam.com> wrote in message
news:eAH7N0W9GHA.3348@.TK2MSFTNGP03.phx.gbl...
> I'm shopping for a dedicated server service to host my web application
> that
> uses SQL Server 2000 (eventually 2005) with everything on one box (IIS,
> COM+
> application, etc.) although backups will go to a NAS unit. My database is
> currently less than 300mb but I would certainly want to accommodate a 3gb+
> database and accommodate ten or a hundred concurrent web users as my
> business hopefully improves.
> One of the hosting companies offers a number of RAID choices. Their
> choices
> include RAID 0 (not fault tolerant - won't be using that), RAID 1 with two
> drives, RAID 5 with three drives, and RAID 10 with four drives. There is
> apparently NOT the luxury of further configuration options like more
> drives
> using one RAID configuration, mixing RAID flavors with more drives, etc.
> There is also the choice between using SATA II drives (7200 or 10000 rpm,
> 250 to 750gbs - about 200gb more than I will ever need) or SA-SCSI (10 or
> 15K rpm, 73gb only)
> With these constrained choices, what would be your recommendations for the
> best redundancy and best fault tolerance where the speed of read-writes is
> less of an issue (because no user would ever notice the difference until
> the
> server was running at 50% cpu or more)?
> My thought is the more drives the better, the fast the rpm the better, but
> I
> don't know enough about whether SATA drives is the next new thing compared
> to SCSI technology, and I don't know whether the difference between RAID 5
> or 10 would really make any difference (besides decreasing the chance of
> failure with one more drive).
> Thanks for any recommendations or thoughts.
>|||One small caveat though, if a small database does a lot of writes, you can
still stress the I/O subsystem.
Linchi
"Andrew J. Kelly" wrote:
> I tend to agree with Linchi given the small size of the db. Most if not all
> of the data should be in cache anyway so there should be very little disk
> I/O on a constant basis.
> --
> Andrew J. Kelly SQL MVP
> "Don Miller" <nospam@.nospam.com> wrote in message
> news:eAH7N0W9GHA.3348@.TK2MSFTNGP03.phx.gbl...
> > I'm shopping for a dedicated server service to host my web application
> > that
> > uses SQL Server 2000 (eventually 2005) with everything on one box (IIS,
> > COM+
> > application, etc.) although backups will go to a NAS unit. My database is
> > currently less than 300mb but I would certainly want to accommodate a 3gb+
> > database and accommodate ten or a hundred concurrent web users as my
> > business hopefully improves.
> >
> > One of the hosting companies offers a number of RAID choices. Their
> > choices
> > include RAID 0 (not fault tolerant - won't be using that), RAID 1 with two
> > drives, RAID 5 with three drives, and RAID 10 with four drives. There is
> > apparently NOT the luxury of further configuration options like more
> > drives
> > using one RAID configuration, mixing RAID flavors with more drives, etc.
> >
> > There is also the choice between using SATA II drives (7200 or 10000 rpm,
> > 250 to 750gbs - about 200gb more than I will ever need) or SA-SCSI (10 or
> > 15K rpm, 73gb only)
> >
> > With these constrained choices, what would be your recommendations for the
> > best redundancy and best fault tolerance where the speed of read-writes is
> > less of an issue (because no user would ever notice the difference until
> > the
> > server was running at 50% cpu or more)?
> >
> > My thought is the more drives the better, the fast the rpm the better, but
> > I
> > don't know enough about whether SATA drives is the next new thing compared
> > to SCSI technology, and I don't know whether the difference between RAID 5
> > or 10 would really make any difference (besides decreasing the chance of
> > failure with one more drive).
> >
> > Thanks for any recommendations or thoughts.
> >
> >
>
>|||Thanks for the quick reply yesterday and for your thoughts.
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:A93579B9-CD81-4E39-89AA-8955C05CB114@.microsoft.com...
> One small caveat though, if a small database does a lot of writes, you can
> still stress the I/O subsystem.
> Linchi
> "Andrew J. Kelly" wrote:
> > I tend to agree with Linchi given the small size of the db. Most if not
all
> > of the data should be in cache anyway so there should be very little
disk
> > I/O on a constant basis.
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> > "Don Miller" <nospam@.nospam.com> wrote in message
> > news:eAH7N0W9GHA.3348@.TK2MSFTNGP03.phx.gbl...
> > > I'm shopping for a dedicated server service to host my web application
> > > that
> > > uses SQL Server 2000 (eventually 2005) with everything on one box
(IIS,
> > > COM+
> > > application, etc.) although backups will go to a NAS unit. My database
is
> > > currently less than 300mb but I would certainly want to accommodate a
3gb+
> > > database and accommodate ten or a hundred concurrent web users as my
> > > business hopefully improves.
> > >
> > > One of the hosting companies offers a number of RAID choices. Their
> > > choices
> > > include RAID 0 (not fault tolerant - won't be using that), RAID 1 with
two
> > > drives, RAID 5 with three drives, and RAID 10 with four drives. There
is
> > > apparently NOT the luxury of further configuration options like more
> > > drives
> > > using one RAID configuration, mixing RAID flavors with more drives,
etc.
> > >
> > > There is also the choice between using SATA II drives (7200 or 10000
rpm,
> > > 250 to 750gbs - about 200gb more than I will ever need) or SA-SCSI (10
or
> > > 15K rpm, 73gb only)
> > >
> > > With these constrained choices, what would be your recommendations for
the
> > > best redundancy and best fault tolerance where the speed of
read-writes is
> > > less of an issue (because no user would ever notice the difference
until
> > > the
> > > server was running at 50% cpu or more)?
> > >
> > > My thought is the more drives the better, the fast the rpm the better,
but
> > > I
> > > don't know enough about whether SATA drives is the next new thing
compared
> > > to SCSI technology, and I don't know whether the difference between
RAID 5
> > > or 10 would really make any difference (besides decreasing the chance
of
> > > failure with one more drive).
> > >
> > > Thanks for any recommendations or thoughts.
> > >
> > >
> >
> >
> >

Tuesday, March 20, 2012

quote in csv

I'm using the reporting services web service to export reports to csv files.
When I export to a csv, a quote mark is appended at the beginning and end of
each line. I'm using the default device info settings. This is not the
Qualifier, because I tried changing that from ["] to other characters in the
devinfo settings, and the ["] is still inserted.
How can I prevent the ["] from being inserted? It causes problems when I
open the file in Excel, because Excel thinks it means the whole row is one
field, and it gets truncated after 256 characters.
Thanks!
BillTwo different solutions depending on RS 2000 or RS 2005. Note, either you
need to be concerned with a merged cells problem when exporting CSV.
Solution 1:
Depending on how you design your reports you can do the following to export
to Excel. Or, what I do sometimes is make a copy of the report and clean it
up for data export and then hide it in list view. If you export from Report
Manager it puts CSV data in unicode which Excel puts all in one column. If
you export in ASCII then Excel does just as you want. To prevent a problem
with cells (Excel will object to sorting the data) you need to remove any
textboxes you have (for instance with a title, showing the parameters run
etc) and instead add additional header rows, merge the cells and put your
text in there instead. I add a link at the top of the report that says
Export Data. With RS 2005 you will be able to configure it to use ASCII
instead of Unicode.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
If you don't want to have it appear in a new window then do this in jump to
URL:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
Solution 2:
Do the above design change to avoid the merged cell problem with sorting in
Excel. Then modify rsreportserver.config. Reboot after the change. The below
shows commenting out the existing entry and putting in the needed change to
have CSV export as ASCII
. <!--
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/>
-->
<Extension Name="CSV"
Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering">
<Configuration>
<DeviceInfo>
<Encoding>ASCII</Encoding>
</DeviceInfo>
</Configuration>
</Extension>
Very nice and very fast.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"bill" <belgie@.datamti.com> wrote in message
news:%235tVqK7ZGHA.3684@.TK2MSFTNGP05.phx.gbl...
> I'm using the reporting services web service to export reports to csv
> files.
> When I export to a csv, a quote mark is appended at the beginning and end
> of each line. I'm using the default device info settings. This is not
> the Qualifier, because I tried changing that from ["] to other characters
> in the devinfo settings, and the ["] is still inserted.
> How can I prevent the ["] from being inserted? It causes problems when I
> open the file in Excel, because Excel thinks it means the whole row is one
> field, and it gets truncated after 256 characters.
> Thanks!
> Bill
>
>
>|||I just realized that the quotes are being added when I save the csv, and
aren't there when it is generated by the reporting service.
"bill" <belgie@.datamti.com> wrote in message
news:%235tVqK7ZGHA.3684@.TK2MSFTNGP05.phx.gbl...
> I'm using the reporting services web service to export reports to csv
> files.
> When I export to a csv, a quote mark is appended at the beginning and end
> of each line. I'm using the default device info settings. This is not
> the Qualifier, because I tried changing that from ["] to other characters
> in the devinfo settings, and the ["] is still inserted.
> How can I prevent the ["] from being inserted? It causes problems when I
> open the file in Excel, because Excel thinks it means the whole row is one
> field, and it gets truncated after 256 characters.
> Thanks!
> Bill
>
>
>

Quiescing Replication

I need to install a service pack on replicated servers. Server A replicates
to Server B and vice versa. From what I understand (but correct me if I'm
wrong), I'll need to "Quiesce" the servers and install the service packs
simultaneously. But what does that mean. I looked at a KB article, but
didn't really understand when it said stop all activity on published tables.
Does that mean the agent jobs? or does that mean to make sure noone
accesses the database from the application?
Thanks!
It means boot all your users off the box.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Sandra" <skong@.ap.org> wrote in message
news:OpfU9j7OGHA.740@.TK2MSFTNGP12.phx.gbl...
>I need to install a service pack on replicated servers. Server A
>replicates to Server B and vice versa. From what I understand (but correct
>me if I'm wrong), I'll need to "Quiesce" the servers and install the
>service packs simultaneously. But what does that mean. I looked at a KB
>article, but didn't really understand when it said stop all activity on
>published tables. Does that mean the agent jobs? or does that mean to make
>sure noone accesses the database from the application?
> Thanks!
>
|||Sandra,
you can use this type of statement to get the databases into a correct
state:
alter database mydb set single_user with rollback immediate.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Monday, March 12, 2012

Quick SQL Mail Question

Hi all,
Here is a simple one.
Can I setup SQL mail on a server where the SQL service and agent accounts
are using the local system account? I think I need to set these services to
a domain account, correct?
TIA,
JoeSave yourself some hassle...
http://www.aspfaq.com/2403
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:1AF9ACF1-068E-472E-A547-6A2B30CB25FB@.microsoft.com...
> Hi all,
> Here is a simple one.
> Can I setup SQL mail on a server where the SQL service and agent accounts
> are using the local system account? I think I need to set these services
> to
> a domain account, correct?
> TIA,
> Joe
>

Quick SQL Mail Question

Hi all,
Here is a simple one.
Can I setup SQL mail on a server where the SQL service and agent accounts
are using the local system account? I think I need to set these services to
a domain account, correct?
TIA,
Joe
Save yourself some hassle...
http://www.aspfaq.com/2403
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:1AF9ACF1-068E-472E-A547-6A2B30CB25FB@.microsoft.com...
> Hi all,
> Here is a simple one.
> Can I setup SQL mail on a server where the SQL service and agent accounts
> are using the local system account? I think I need to set these services
> to
> a domain account, correct?
> TIA,
> Joe
>

Monday, February 20, 2012

Questions with Reporting Service Development by C#.

I am going to develop a project with Reporting Service Delivery Extesions by c# (schedule,subscribe and send mail), but i did not have much know about these, does someone can help me or give me some pieces of advise?

Thanks so much. :)

Go to the MSDN web site at http://msdn2.microsoft.com/en-gb/sql/aa336316.aspx and work through the training material there.

|||

thanks, that's quite useful

Questions regarding Reporting Service SOAP

Hi,
I using reporting service SOAP in my application. I would like to know..

- what is the method for delete a report
- there is list children method for listing reports from certain folder but how to get list of catalog or list of folders from reporting service, but method to use.

Thanks and best regards!

Delete a report: DeleteItem( itempath )

List folders: Call ListChildren(parentpath) and filter the resulting CatalogItem collection for folders. There is no way to only return folders from ListChildren.

List catalog: This is not meaningful because any given Report Server has one and only one catalog.