Boot.ini file: bringing

Showing posts with label bringing. 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

Bringing text into a database

I have a report that is generated out of another system, that is 180
characters wide. It resembles the layout of an old COBOL type of report.
What I need to do to is to bring it into a database. I've set the field
to be 180 characters (have tried char, varchar, nvarchar, text) but when
I go to import the data, I notice that it gets truncated around position
150 or so, no matter what data type I choose.
What I want to do is to bring this report in, as a single field, and be
able to move it out as a single line.
What's the limit on varchar, char, text and so on? Why is the wizard
truncating the firstline around position 150?
Thanks,
BCThe limit is 8000. Perhaps the wizard is the issue. Can you create the DTS
package manually? It may be that the input row contains a character that's
supposed to be used as a delimiter.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Blasting Cap" <goober@.christian.net> wrote in message
news:%237EjS3KPGHA.2668@.tk2msftngp13.phx.gbl...
I have a report that is generated out of another system, that is 180
characters wide. It resembles the layout of an old COBOL type of report.
What I need to do to is to bring it into a database. I've set the field
to be 180 characters (have tried char, varchar, nvarchar, text) but when
I go to import the data, I notice that it gets truncated around position
150 or so, no matter what data type I choose.
What I want to do is to bring this report in, as a single field, and be
able to move it out as a single line.
What's the limit on varchar, char, text and so on? Why is the wizard
truncating the firstline around position 150?
Thanks,
BC|||Tom Moreau wrote:
> The limit is 8000. Perhaps the wizard is the issue. Can you create the D
TS
> package manually? It may be that the input row contains a character that'
s
> supposed to be used as a delimiter.
>
The wizard in DTS is the same wizard. Best I can figure is that a CRLF
is at the end of each line, and it varies as to what position it's in.
It appears that the first line of the report dictates where the "hard"
column end appears thoughout the rest of the report.
BC|||CRLF is the standard row terminator. You may need a hex editor to track
down exactly where it is.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Blasting Cap" <goober@.christian.net> wrote in message
news:%23RijHHLPGHA.1760@.TK2MSFTNGP10.phx.gbl...
Tom Moreau wrote:
> The limit is 8000. Perhaps the wizard is the issue. Can you create the
> DTS
> package manually? It may be that the input row contains a character
> that's
> supposed to be used as a delimiter.
>
The wizard in DTS is the same wizard. Best I can figure is that a CRLF
is at the end of each line, and it varies as to what position it's in.
It appears that the first line of the report dictates where the "hard"
column end appears thoughout the rest of the report.
BC

Bringing Standby server online when in "no recovery mode"

Hi,

I am trying to set up Log Shipping. Though I have the following problem...
I want to set up LS without any user being able to connect. As I understand, this means I have to select the "No recovery mode" in the "Add Destination Database" window when creating the Log Shipping Maintenance Plan.
This all works fine. I set this up, no user can connect to the database (it shows status: (Loading) ), perfect.

However, the problem I encounter is when I want to bring the Standby server online.
I run the 'sp_change_primary_role' SP on the primary server... works fine.
I run the 'sp_change_secondary_role' on the standby server... errors:

Server: Msg 927, Level 14, State 2, Line 1
Database 'Northwind' cannot be opened. It is in the middle of a restore.
Server: Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Server: Msg 14440, Level 16, State 1, Procedure sp_change_secondary_role, Line 49
Could not set single user mode.

So what am I doing wrong? Am I forgetting something? I think i must do. The only way to get the secondary (standby) online is to do a "detach - attach", as far as I know.
I can not check its Properties or do a restore or backup of this database either.

Any help would be very much appreciated.

Thanks in advance and kind regards,

Jan V.Run the following command, to open the database:

restore database (name of database) with recovery

This will trigger a recovery of the database, and reset the database to "open" from "loading"

bringing server into a different domain

Have a 2000 server running SQL 7.0.
This server is the DC of it's own domain and is the only
server on this domain.
I need to kill this domain and bring the server into a
different existing domain as a member server.
The server's name will also change.
SQL wise, what do I need to know/do to make this happen?Hi
Check out:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp
John
"Rocktiman" <anonymous@.discussions.microsoft.com> wrote in message
news:c16301c4383a$514791c0$a001280a@.phx.gbl...
> Have a 2000 server running SQL 7.0.
> This server is the DC of it's own domain and is the only
> server on this domain.
> I need to kill this domain and bring the server into a
> different existing domain as a member server.
> The server's name will also change.
> SQL wise, what do I need to know/do to make this happen?|||Thanks for the info John but this document talks about SQL
2000. I am running SQL 7.0. Does the same procedure
apply?
>--Original Message--
>Hi
>Check out:
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/instsql/in_afterinstall_5r8f.asp
>John
>"Rocktiman" <anonymous@.discussions.microsoft.com> wrote
in message
>news:c16301c4383a$514791c0$a001280a@.phx.gbl...
>> Have a 2000 server running SQL 7.0.
>> This server is the DC of it's own domain and is the only
>> server on this domain.
>> I need to kill this domain and bring the server into a
>> different existing domain as a member server.
>> The server's name will also change.
>> SQL wise, what do I need to know/do to make this happen?
>
>.
>|||Hi
I can remember if it was the same, but the areas it points to are the most
likely sort of things where it may have problems.
John
"Rockitman" <anonymous@.discussions.microsoft.com> wrote in message
news:cb4401c4390f$b806e9d0$a501280a@.phx.gbl...
> Thanks for the info John but this document talks about SQL
> 2000. I am running SQL 7.0. Does the same procedure
> apply?
> >--Original Message--
> >Hi
> >
> >Check out:
> >http://msdn.microsoft.com/library/default.asp?
> url=/library/en-us/instsql/in_afterinstall_5r8f.asp
> >
> >John
> >
> >"Rocktiman" <anonymous@.discussions.microsoft.com> wrote
> in message
> >news:c16301c4383a$514791c0$a001280a@.phx.gbl...
> >> Have a 2000 server running SQL 7.0.
> >> This server is the DC of it's own domain and is the only
> >> server on this domain.
> >> I need to kill this domain and bring the server into a
> >> different existing domain as a member server.
> >> The server's name will also change.
> >> SQL wise, what do I need to know/do to make this happen?
> >
> >
> >.
> >

bringing down a BLOB

I have some voice files. They can be any where from .5Mb to a few Mb. I am thinking of keeping them in a BLOB in a table on the remote SQL server so I can download them to a few different servers when needed. I am worried about transfer times and CPU usage. I only plan to transfer these voice files a few times per day, but I have certain other traffic that is more important and must take precedence. Is there any way to set the "priority" of this data? I am using cheap linksys routers. Do I need to take care of this from the router side or is there a way to take care of this from the SQL server side?Originally posted by wooliewillie
RE: I have some voice files. They can be any where from .5Mb to a few Mb. I am thinking of keeping them in a BLOB in a table on the remote SQL server so I can download them to a few different servers when needed. I am worried about transfer times and CPU usage. I only plan to transfer these voice files a few times per day, but I have certain other traffic that is more important and must take precedence. Is there any way to set the "priority" of this data? I am using cheap linksys routers. Do I need to take care of this from the router side or is there a way to take care of this from the SQL server side?

Q1 Is there any way to set the "priority" of this data?
A1 Yes, but the answer is not as easy as one might hope. Generally, implementing QOS can be an effective way to control prioritization of network traffic. However, to work as intended for your situation QOS needs to implemented it into application(s) (and your network infrastructure) at various levels. MS supports QOS via QOS API calls; this route will involve some development effort, however. I cannot comment on your hardware support of QOS.
It might be easier to simply schedule your transfers for times when traffic is usually low, or you could monitor traffic via some software agent and interactivly have that agent fire off lower priority transfers (based on traffic criteria you design).|||>>MS supports QOS via QOS API calls

I should have mentioned that I only have control over the client. The SQL Server machine is at a hosted site and thus I have no control over its routers. I am thinking now to either 1) make zones, where at night I would transfer the voice files to all of the servers in the zone so no transfer need be done during the day. The only problem with this is that if someone logs off and then logs on within a single day (very likely) they may get a different server (randomly) and thus no voice file untiol the next day.
2) instead of saving the voice file in a blob on the sql server, offering to transfer it back to the user's PC when they log off the system, and next time they log on, ask if they want to upload it. This way I get arround this important issue. And also don't use a BLOB.
3) make sure they support routers that support quality of service, get the same routers at my sites, code to turn on the QOS bit during a transfer via some API. (this will take lots of investigation).

I am leaning towards #2 at this time. Does it sound reasonable?|||Originally posted by wooliewillie
RE: 2) instead of saving the voice file in a blob on the sql server, offering to transfer it back to the user's PC when they log off the system, and next time they log on, ask if they want to upload it. This way I get arround this important issue. And also don't use a BLOB.
3) make sure they support routers that support quality of service, get the same routers at my sites, code to turn on the QOS bit during a transfer via some API. (this will take lots of investigation).

I am leaning towards #2 at this time. Does it sound reasonable?

Q1 Does it sound reasonable?
A1 If it meets your needs, yes. 3) would likely take significant effort.|||There is actually one more possibility. How about if I get a external hard-drive system that attaches via ethernet so any of the servers can access the file. Of course, I will most likely need two NIC cards in each PC; one for the internet and one for the harddrive. Otherwise I will still be clogging the pipes with a really big file.|||Originally posted by wooliewillie
RE: There is actually one more possibility. How about if I get a external hard-drive system that attaches via ethernet so any of the servers can access the file. Of course, I will most likely need two NIC cards in each PC; one for the internet and one for the harddrive. Otherwise I will still be clogging the pipes with a really big file.

S1 Essentially that sounds like creating a private 'utility' network. It can work quite well for things like backup dump access to local NAS storage, large audio files, etc.; as long as you pay proper attention to possible issues (especially routing and looping). I have seen cases where ill considered implementations have created lots of network performance degradation (massive looping problems, excessive chatter, and what not).

Bringing data into a flat file

I am trying to bring in the result fo a query to a flat file. The source and destination connections are oK, the mapping is also correct. However I get the following error during execution:

[Flat File Destination [507]] Error: No column was specified to allow the component to advance through the file.

followed by this:

[DTS.Pipeline] Error: component "Flat File Destination" (507) failed the pre-execute phase and returned error code 0xC02020F0.

What is the fix?

Hmmm... never seen that error before. Can you share your package? I'd be interested in seeing it. Perhaps email me via http://blogs.conchango.com/jamiethomson/contact.aspx

I'm not promising that I'll be able to fix it

-Jamie

|||

Jayaram Krishnaswamy wrote:

I am trying to bring in the result fo a query to a flat file. The source and destination connections are oK, the mapping is also correct. However I get the following error during execution:

[Flat File Destination [507]] Error: No column was specified to allow the component to advance through the file.

followed by this:

[DTS.Pipeline] Error: component "Flat File Destination" (507) failed the pre-execute phase and returned error code 0xC02020F0.

What is the fix?

Jay,

Thanks for sending your package.

You don't have anything mapped to [Column 0] in the destination. I am guessing that this is the problem.

-Jamie

|||

Thanks. Perhaps I have to just test various possibilities.

|||

Jayaram Krishnaswamy wrote:

Thanks. Perhaps I have to just test various possibilities.

No. You simply have to put something into that first column.

Bringing a DB online

Hi all,
I have tried to search for answers to this, but couldn't find anything specific. I have taken a database Offline, I can't get it to come back online. I tried the ALTER DATABASE dbname SET ONLINE, but get the error message. User must be in the Master da
tabase. I am using osql with the -E command. Do I need to use something else?
Justin,
try using
osql -E -d master
ALTER DATABASE dbname SET ONLINE
go
Alternatively you can reset the default database for your windows login, and
then miss out the -d master argument.
HTH,
Paul Ibison
|||Hi;
Execute the below command from command prompt
OSQL -E -S server (enter)
1>use master
2>go
1>Alter database dbname set online
2>go
Thanks
Hari
MCDBA
"Justin Cook" <anonymous@.discussions.microsoft.com> wrote in message
news:6BEB437E-CDB1-4F8D-927A-EB1E2D140AC6@.microsoft.com...
> Hi all,
> I have tried to search for answers to this, but couldn't find anything
specific. I have taken a database Offline, I can't get it to come back
online. I tried the ALTER DATABASE dbname SET ONLINE, but get the error
message. User must be in the Master database. I am using osql with the -E
command. Do I need to use something else?
>
|||THANK YOU THANK YOU

Bringing a DB online

Hi all
I have tried to search for answers to this, but couldn't find anything specific. I have taken a database Offline, I can't get it to come back online. I tried the ALTER DATABASE dbname SET ONLINE, but get the error message. User must be in the Master database. I am using osql with the -E command. Do I need to use something elseJustin,
try using
osql -E -d master
ALTER DATABASE dbname SET ONLINE
go
Alternatively you can reset the default database for your windows login, and
then miss out the -d master argument.
HTH,
Paul Ibison|||Hi;
Execute the below command from command prompt
OSQL -E -S server (enter)
1>use master
2>go
1>Alter database dbname set online
2>go
Thanks
Hari
MCDBA
"Justin Cook" <anonymous@.discussions.microsoft.com> wrote in message
news:6BEB437E-CDB1-4F8D-927A-EB1E2D140AC6@.microsoft.com...
> Hi all,
> I have tried to search for answers to this, but couldn't find anything
specific. I have taken a database Offline, I can't get it to come back
online. I tried the ALTER DATABASE dbname SET ONLINE, but get the error
message. User must be in the Master database. I am using osql with the -E
command. Do I need to use something else?
>|||THANK YOU THANK YOU :)

Sunday, February 19, 2012

Bringing up SQL Server 2000

Bringing up SQL Server 2000

Thursday, February 16, 2012

Bringing up SQL Server 2000

Bringing text into a database

Bringing Standby server online when in "no recovery mode"

bringing server into a different domain

bringing server into a different domain

bringing server into a different domain

bringing down a BLOB

Bringing data into a flat file

Bringing a DB online

Bringing a DB online

Boot.ini file

Blog Archive

About Me