Boot.ini file: single

Showing posts with label single. Show all posts

Sunday, February 19, 2012

Bringing up SQL Server 2000

Hi,
I was trying to test SQL Server 2000 master database restore and to do that
I stopped MSSQLSERVER service and tried to restart with a single user mode.
However, on typing the command "sqlservr.exe -m" in the Command window it
stops at the point where it says "Using 'xplog70.dll' version '2000.80.760'
to execute extended stored procedure 'xp_msver" and it just does not do
anything.
Then I started it with -m -f option and the last line in the command window
is "2007-03-29 14:18:16.24 spid3 Warning: override, autoexec procedures
skipped." and it does not do anything after that.
Am I doing something wrong? Thanks in advance.All is fine. Leave the command prompt as is, connect using OSQL and execute your RESTORE command.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:E80139B2-0AC7-4053-AD17-9907AD851B99@.microsoft.com...
> Hi,
> I was trying to test SQL Server 2000 master database restore and to do that
> I stopped MSSQLSERVER service and tried to restart with a single user mode.
> However, on typing the command "sqlservr.exe -m" in the Command window it
> stops at the point where it says "Using 'xplog70.dll' version '2000.80.760'
> to execute extended stored procedure 'xp_msver" and it just does not do
> anything.
> Then I started it with -m -f option and the last line in the command window
> is "2007-03-29 14:18:16.24 spid3 Warning: override, autoexec procedures
> skipped." and it does not do anything after that.
> Am I doing something wrong? Thanks in advance.|||Thanks for the response. Can you please let me know what commands are used to
run Restore through OSQL and do I run them in the Command Prompt window or
Query analyzer?
"Tibor Karaszi" wrote:
> All is fine. Leave the command prompt as is, connect using OSQL and execute your RESTORE command.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:E80139B2-0AC7-4053-AD17-9907AD851B99@.microsoft.com...
> > Hi,
> >
> > I was trying to test SQL Server 2000 master database restore and to do that
> > I stopped MSSQLSERVER service and tried to restart with a single user mode.
> > However, on typing the command "sqlservr.exe -m" in the Command window it
> > stops at the point where it says "Using 'xplog70.dll' version '2000.80.760'
> > to execute extended stored procedure 'xp_msver" and it just does not do
> > anything.
> >
> > Then I started it with -m -f option and the last line in the command window
> > is "2007-03-29 14:18:16.24 spid3 Warning: override, autoexec procedures
> > skipped." and it does not do anything after that.
> >
> > Am I doing something wrong? Thanks in advance.
>
>|||You can open another Command Prompt window (not the one you started SQL
Server in, just leave that alone until you're ready to stop the service) to
run osql or open Query Analyzer. The command to restore a database is
RESTORE DATABASE. You should look up the full syntax of the RESTORE DATABASE
command in the Books Online, study it a bit, and then feel free to ask more
questions.
--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:EE86914A-42FD-4485-8C33-E5C02400B0EC@.microsoft.com...
> Thanks for the response. Can you please let me know what commands are used
> to
> run Restore through OSQL and do I run them in the Command Prompt window or
> Query analyzer?
> "Tibor Karaszi" wrote:
>> All is fine. Leave the command prompt as is, connect using OSQL and
>> execute your RESTORE command.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "sharman" <sharman@.discussions.microsoft.com> wrote in message
>> news:E80139B2-0AC7-4053-AD17-9907AD851B99@.microsoft.com...
>> > Hi,
>> >
>> > I was trying to test SQL Server 2000 master database restore and to do
>> > that
>> > I stopped MSSQLSERVER service and tried to restart with a single user
>> > mode.
>> > However, on typing the command "sqlservr.exe -m" in the Command window
>> > it
>> > stops at the point where it says "Using 'xplog70.dll' version
>> > '2000.80.760'
>> > to execute extended stored procedure 'xp_msver" and it just does not do
>> > anything.
>> >
>> > Then I started it with -m -f option and the last line in the command
>> > window
>> > is "2007-03-29 14:18:16.24 spid3 Warning: override, autoexec
>> > procedures
>> > skipped." and it does not do anything after that.
>> >
>> > Am I doing something wrong? Thanks in advance.
>>

Thursday, February 16, 2012

Bringing up SQL Server 2000

Tuesday, February 14, 2012

Breaking data into 1500 byte chunks

Hi,

I have a text file (5 MB). It appears as a single line in a text editor. But actually it has records of 1500 byte length each.

I want to strip it down to 1500 byte records. So 1500*3500 = 5 MB (approx). The record size is always 1500 bytes.

Does anyone have a script that I can run on this file to achieve this break.

ThanksYou have 1 row of 5,000,000 bytes?

There is no CR LF chars?

Are there any delimiters?|||No there are no delimiters. All I know is they are 1500 byte records. Each record has fixed column length. But all on a single line.|||Where did the file come from?

An lrecl of 5mb?

Tell them to fix the file...

I guess you would need to write a pearl script or something...

Friday, February 10, 2012

Boost SQL Priority Pros and Cons

hello,
I have a single, dual-processor SQL server running our companies primary
application for 60 users. We are running SQL 2000 sp4 on 2000 Server, sp4.
Server access via the application seems sluggish at times and I am wondering
if boosting the SQL Priority will help in this regard.
Can someone provide some details on the pro's and con's of enabling this?
Also, what benefit would adding the instance of SQL to Active Directory
provide?
--
Thanks, Jeff"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:3E28C261-C90B-4BA1-AD6A-898AEE7B09BF@.microsoft.com...
> hello,
> I have a single, dual-processor SQL server running our companies primary
> application for 60 users. We are running SQL 2000 sp4 on 2000 Server,
> sp4.
> Server access via the application seems sluggish at times and I am
> wondering
> if boosting the SQL Priority will help in this regard.
> Can someone provide some details on the pro's and con's of enabling this?
>
If there are no other applciations running on the server, booting priority
will do nothing. If there are other application running on the server using
lots of CPU, consider using Windows Server Resource Manager to allocate CPU.
It's much more flexible, smarter and safer than messing with process
priority. T
> Also, what benefit would adding the instance of SQL to Active Directory
> provide?
>
None.
David|||If you have performance problems, looking at changing
configuration settings is generally one of the last things
you would typically look at. Many of the times that people
change those settings, it just causes more harm than good.
It's pretty rare to ever need to change the priority.
The following is a pretty good short article on the
configuration settings:
How to determine proper SQL Server configuration settings
http://support.microsoft.com/?id=319942
-Sue
On Thu, 27 Jul 2006 15:04:01 -0700, Jeff
<Jeff@.discussions.microsoft.com> wrote:
>hello,
>I have a single, dual-processor SQL server running our companies primary
>application for 60 users. We are running SQL 2000 sp4 on 2000 Server, sp4.
>Server access via the application seems sluggish at times and I am wondering
>if boosting the SQL Priority will help in this regard.
>Can someone provide some details on the pro's and con's of enabling this?
>Also, what benefit would adding the instance of SQL to Active Directory
>provide?|||Jeff wrote:
> hello,
> I have a single, dual-processor SQL server running our companies primary
> application for 60 users. We are running SQL 2000 sp4 on 2000 Server, sp4.
> Server access via the application seems sluggish at times and I am wondering
> if boosting the SQL Priority will help in this regard.
> Can someone provide some details on the pro's and con's of enabling this?
> Also, what benefit would adding the instance of SQL to Active Directory
> provide?
>
More than likely, boosting the priority won't help you out at all. You
should start by looking at sysprocesses during one of the sluggish
periods to see what it running. You could be experiencing blocking, or
just a poorly optimized query that is slowing things down.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thank you all for the responses, I appreciate the input. Sounds like it is
not worth my time.
Our server only runs SQL server and an instance of Backup Exec in SQL, other
than that, it runs nothing.
I think it is more due to the application than the server portion now anyway.
--
Thanks, Jeff
"Tracy McKibben" wrote:
> Jeff wrote:
> > hello,
> >
> > I have a single, dual-processor SQL server running our companies primary
> > application for 60 users. We are running SQL 2000 sp4 on 2000 Server, sp4.
> > Server access via the application seems sluggish at times and I am wondering
> > if boosting the SQL Priority will help in this regard.
> >
> > Can someone provide some details on the pro's and con's of enabling this?
> >
> > Also, what benefit would adding the instance of SQL to Active Directory
> > provide?
> >
> >
> More than likely, boosting the priority won't help you out at all. You
> should start by looking at sysprocesses during one of the sluggish
> periods to see what it running. You could be experiencing blocking, or
> just a poorly optimized query that is slowing things down.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>

Boost SQL Priority Pros and Cons

hello,
I have a single, dual-processor SQL server running our companies primary
application for 60 users. We are running SQL 2000 sp4 on 2000 Server, sp4.
Server access via the application seems sluggish at times and I am wondering
if boosting the SQL Priority will help in this regard.
Can someone provide some details on the pro's and con's of enabling this?
Also, what benefit would adding the instance of SQL to Active Directory
provide?
Thanks, Jeff"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:3E28C261-C90B-4BA1-AD6A-898AEE7B09BF@.microsoft.com...
> hello,
> I have a single, dual-processor SQL server running our companies primary
> application for 60 users. We are running SQL 2000 sp4 on 2000 Server,
> sp4.
> Server access via the application seems sluggish at times and I am
> wondering
> if boosting the SQL Priority will help in this regard.
> Can someone provide some details on the pro's and con's of enabling this?
>
If there are no other applciations running on the server, booting priority
will do nothing. If there are other application running on the server using
lots of CPU, consider using Windows Server Resource Manager to allocate CPU.
It's much more flexible, smarter and safer than messing with process
priority. T

> Also, what benefit would adding the instance of SQL to Active Directory
> provide?
>
None.
David|||If you have performance problems, looking at changing
configuration settings is generally one of the last things
you would typically look at. Many of the times that people
change those settings, it just causes more harm than good.
It's pretty rare to ever need to change the priority.
The following is a pretty good short article on the
configuration settings:
How to determine proper SQL Server configuration settings
http://support.microsoft.com/?id=319942
-Sue
On Thu, 27 Jul 2006 15:04:01 -0700, Jeff
<Jeff@.discussions.microsoft.com> wrote:

>hello,
>I have a single, dual-processor SQL server running our companies primary
>application for 60 users. We are running SQL 2000 sp4 on 2000 Server, sp4.
>Server access via the application seems sluggish at times and I am wonderin
g
>if boosting the SQL Priority will help in this regard.
>Can someone provide some details on the pro's and con's of enabling this?
>Also, what benefit would adding the instance of SQL to Active Directory
>provide?|||Jeff wrote:
> hello,
> I have a single, dual-processor SQL server running our companies primary
> application for 60 users. We are running SQL 2000 sp4 on 2000 Server, sp4
.
> Server access via the application seems sluggish at times and I am wonderi
ng
> if boosting the SQL Priority will help in this regard.
> Can someone provide some details on the pro's and con's of enabling this?
> Also, what benefit would adding the instance of SQL to Active Directory
> provide?
>
More than likely, boosting the priority won't help you out at all. You
should start by looking at sysprocesses during one of the sluggish
periods to see what it running. You could be experiencing blocking, or
just a poorly optimized query that is slowing things down.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Thank you all for the responses, I appreciate the input. Sounds like it is
not worth my time.
Our server only runs SQL server and an instance of Backup Exec in SQL, other
than that, it runs nothing.
I think it is more due to the application than the server portion now anyway
.
Thanks, Jeff
"Tracy McKibben" wrote:

> Jeff wrote:
> More than likely, boosting the priority won't help you out at all. You
> should start by looking at sysprocesses during one of the sluggish
> periods to see what it running. You could be experiencing blocking, or
> just a poorly optimized query that is slowing things down.
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>

Sunday, February 19, 2012

Bringing up SQL Server 2000

Bringing up SQL Server 2000

Thursday, February 16, 2012

Bringing up SQL Server 2000

Tuesday, February 14, 2012

Breaking data into 1500 byte chunks

Friday, February 10, 2012

Boost SQL Priority Pros and Cons

Boost SQL Priority Pros and Cons

Boot.ini file

Blog Archive

About Me