Anyone recently installed SQL Server 2000 Eval version

Hello,

I am having trouble installing Evaluation copy of SQL Server on my
notebook, which has XP, P4 processor,1G Ram, and 14 G harddisk space.

After I run the Setup.exe, I get the files files extracted in the
SQLEVAL directory.

As per the instruction, I need to run Autorun.exe file. For some
reason, when I try to run this file, a new windows pops up, which is
blank black screen with cursor flying around in the window. The title
of the window is
C:\windows\system32\wowexec.exe

This is how far I have reached while trying to install the database. I
would really appreciate if someone could provide some suggestions.

VS"TinTin" <lalalulu24@.yahoo.com> wrote in message
news:2d5425d1.0404021102.1ac7269f@.posting.google.c om...
> Hello,
> I am having trouble installing Evaluation copy of SQL Server on my
> notebook, which has XP, P4 processor,1G Ram, and 14 G harddisk space.
> After I run the Setup.exe, I get the files files extracted in the
> SQLEVAL directory.
> As per the instruction, I need to run Autorun.exe file. For some
> reason, when I try to run this file, a new windows pops up, which is
> blank black screen with cursor flying around in the window. The title
> of the window is
> C:\windows\system32\wowexec.exe
> This is how far I have reached while trying to install the database. I
> would really appreciate if someone could provide some suggestions.
> VS

I have no idea what the problem is, but perhaps you could try running the
setup program directly - I think it's called setupsql.exe, in the \setup
folder (from memory).

Simon|||> I
> would really appreciate if someone could provide some suggestions.

http://otn.oracle.com/software/prod...e10g/index.html :-)

anyone knows the anatomy to the transaction logs

how can i retrieve information from that very consuming tlogs.
Its consuming a lot of space maybe we can make relevant info from it
thanks,
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787Lumigent Log Explorer can help you on that.
HTH, Jens Suessmeyer.|||thanks but thats not what i need.
do you dig deep into to the logs
thanks,
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"Jens" wrote:

> Lumigent Log Explorer can help you on that.
> HTH, Jens Suessmeyer.
>|||What do you want to do ? Look at the feature list of lumigent, perhaps
it=B4ll fit your needs.
http://www.lumigent.com/products/le_sql.html
HTH, Jens Suessmeyer.|||i want to generate reports from it without using
the log explorer
--
thanks,
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"Jens" wrote:

> What do you want to do ? Look at the feature list of lumigent, perhaps
> it′ll fit your needs.
> http://www.lumigent.com/products/le_sql.html
> HTH, Jens Suessmeyer.
>|||SQL Server doesn't provide any features for reporting from the logs.
You'd have to use third party tools for that. Logs are generally
unsuitable for business reporting requirements because any useful data
they contain is lost each time you do a log backup (which you should be
doing regularly if you are in Full Recovery mode). If you need to log
historical data then the transaction logs are not the way to do it.
David Portas
SQL Server MVP
--|||Hi Jose,
The details of the log are not released by Microsoft. The companies that
have products which read the log have done so by cracking the logs structure
themselves. Therefore you would be very (VERY) lucky if any of them are
willing to let you know what it is, as this is big money for them.
David right though even if you could read it reporting from it would not be
a good idea
kind regards
Greg O
Need to document your databases. Use the first and still the best AGS SQL
Scribe
http://www.ag-software.com
"Jose G. de Jesus Jr MCP, MCDBA" <Email me> wrote in message
news:B42E3821-F9FC-4A1B-B87C-AD2698EBAB4D@.microsoft.com...
> how can i retrieve information from that very consuming tlogs.
> Its consuming a lot of space maybe we can make relevant info from it
>
> --
> thanks,
> --
> Jose de Jesus Jr. Mcp,Mcdba
> Data Architect
> Sykes Asia (Manila philippines)
> MCP #2324787|||thanks for the input guys
--
thanks,
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"Jose G. de Jesus Jr MCP, MCDBA" wrote:

> how can i retrieve information from that very consuming tlogs.
> Its consuming a lot of space maybe we can make relevant info from it
>
> --
> thanks,
> --
> Jose de Jesus Jr. Mcp,Mcdba
> Data Architect
> Sykes Asia (Manila philippines)
> MCP #2324787|||You can manage (but not entirely limit) the amount of space consumed by the
transaction logs by configuring the database recovery model and scheduling
transaction log backups / truncates.
"Jose G. de Jesus Jr MCP, MCDBA" <Email me> wrote in message
news:B42E3821-F9FC-4A1B-B87C-AD2698EBAB4D@.microsoft.com...
> how can i retrieve information from that very consuming tlogs.
> Its consuming a lot of space maybe we can make relevant info from it
>
> --
> thanks,
> --
> Jose de Jesus Jr. Mcp,Mcdba
> Data Architect
> Sykes Asia (Manila philippines)
> MCP #2324787

Any stored procedures to check a database's free space and its allocated space ?

Can anybody tell me are there are stored procedures or system tables show me
:
(1)The hard disk space allocated to a database.
(2)The hard disk space used on a database
(3)The hard disk space allocated to a database's transaction log
(4)The hard disk space used on a database's transaction log
Thanks.cpchan
(1)The hard disk space allocated to a database.
(2)The hard disk space used on a database
(3)The hard disk space allocated to a database's transaction log
(4)The hard disk space used on a database's transaction log
1)CREATE table DriveTable (Drive varchar(10),[MB Free] int)
INSERT into Drivetable Exec xp_fixeddrives
SELECT * FROM DriveTable
2) sp_helpdb 'pubs'
3,4) sp_helpfile pubs_log,dbcc sqlperf(logspace)
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c1scnn$pq12@.imsp212.netvigator.com...
> Can anybody tell me are there are stored procedures or system tables show
me
> :
> (1)The hard disk space allocated to a database.
> (2)The hard disk space used on a database
> (3)The hard disk space allocated to a database's transaction log
> (4)The hard disk space used on a database's transaction log
> Thanks.
>
>|||Hi,
For database execute the below procedure with out parameter,
sp_spaceused
For transaction log ,
DBCC SQLPERF(LOGSPACE)
Thanks
Hari
MCDBA
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c1scnn$pq12@.imsp212.netvigator.com...
> Can anybody tell me are there are stored procedures or system tables show
me
> :
> (1)The hard disk space allocated to a database.
> (2)The hard disk space used on a database
> (3)The hard disk space allocated to a database's transaction log
> (4)The hard disk space used on a database's transaction log
> Thanks.
>
>|||Thanks
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:#XViSBr$DHA.3184@.TK2MSFTNGP09.phx.gbl...
> cpchan
> (1)The hard disk space allocated to a database.
> (2)The hard disk space used on a database
> (3)The hard disk space allocated to a database's transaction log
> (4)The hard disk space used on a database's transaction log
> 1)CREATE table DriveTable (Drive varchar(10),[MB Free] int)
> INSERT into Drivetable Exec xp_fixeddrives
> SELECT * FROM DriveTable
> 2) sp_helpdb 'pubs'
> 3,4) sp_helpfile pubs_log,dbcc sqlperf(logspace)
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c1scnn$pq12@.imsp212.netvigator.com...
show
> me
>|||Thanks
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:#Rs09Fr$DHA.2448@.TK2MSFTNGP12.phx.gbl...
> Hi,
> For database execute the below procedure with out parameter,
> sp_spaceused
> For transaction log ,
> DBCC SQLPERF(LOGSPACE)
> Thanks
> Hari
> MCDBA
>
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c1scnn$pq12@.imsp212.netvigator.com...
show
> me
>

Any stored procedures to check a database's free space and its allocated space ?

Can anybody tell me are there are stored procedures or system tables show me
:
(1)The hard disk space allocated to a database.
(2)The hard disk space used on a database
(3)The hard disk space allocated to a database's transaction log
(4)The hard disk space used on a database's transaction log
Thanks.cpchan
(1)The hard disk space allocated to a database.
(2)The hard disk space used on a database
(3)The hard disk space allocated to a database's transaction log
(4)The hard disk space used on a database's transaction log
1)CREATE table DriveTable (Drive varchar(10),[MB Free] int)
INSERT into Drivetable Exec xp_fixeddrives
SELECT * FROM DriveTable
2) sp_helpdb 'pubs'
3,4) sp_helpfile pubs_log,dbcc sqlperf(logspace)
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c1scnn$pq12@.imsp212.netvigator.com...
> Can anybody tell me are there are stored procedures or system tables show
me
> :
> (1)The hard disk space allocated to a database.
> (2)The hard disk space used on a database
> (3)The hard disk space allocated to a database's transaction log
> (4)The hard disk space used on a database's transaction log
> Thanks.
>
>|||Hi,
For database execute the below procedure with out parameter,
sp_spaceused
For transaction log ,
DBCC SQLPERF(LOGSPACE)
Thanks
Hari
MCDBA
"cpchan" <cpchaney@.netvigator.com> wrote in message
news:c1scnn$pq12@.imsp212.netvigator.com...
> Can anybody tell me are there are stored procedures or system tables show
me
> :
> (1)The hard disk space allocated to a database.
> (2)The hard disk space used on a database
> (3)The hard disk space allocated to a database's transaction log
> (4)The hard disk space used on a database's transaction log
> Thanks.
>
>|||Thanks
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:#XViSBr$DHA.3184@.TK2MSFTNGP09.phx.gbl...
> cpchan
> (1)The hard disk space allocated to a database.
> (2)The hard disk space used on a database
> (3)The hard disk space allocated to a database's transaction log
> (4)The hard disk space used on a database's transaction log
> 1)CREATE table DriveTable (Drive varchar(10),[MB Free] int)
> INSERT into Drivetable Exec xp_fixeddrives
> SELECT * FROM DriveTable
> 2) sp_helpdb 'pubs'
> 3,4) sp_helpfile pubs_log,dbcc sqlperf(logspace)
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c1scnn$pq12@.imsp212.netvigator.com...
> > Can anybody tell me are there are stored procedures or system tables
show
> me
> > :
> >
> > (1)The hard disk space allocated to a database.
> > (2)The hard disk space used on a database
> > (3)The hard disk space allocated to a database's transaction log
> > (4)The hard disk space used on a database's transaction log
> >
> > Thanks.
> >
> >
> >
>|||Thanks
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:#Rs09Fr$DHA.2448@.TK2MSFTNGP12.phx.gbl...
> Hi,
> For database execute the below procedure with out parameter,
> sp_spaceused
> For transaction log ,
> DBCC SQLPERF(LOGSPACE)
> Thanks
> Hari
> MCDBA
>
> "cpchan" <cpchaney@.netvigator.com> wrote in message
> news:c1scnn$pq12@.imsp212.netvigator.com...
> > Can anybody tell me are there are stored procedures or system tables
show
> me
> > :
> >
> > (1)The hard disk space allocated to a database.
> > (2)The hard disk space used on a database
> > (3)The hard disk space allocated to a database's transaction log
> > (4)The hard disk space used on a database's transaction log
> >
> > Thanks.
> >
> >
> >
>

Any possibility?

Any possibility?
Right now I have a 600 MB space free and on my system I have a 6 GB backup
file and I want to restore it on my own system...
I don't have any network where I have place this file and restore it from
there and no DVD which support this 6 GB... any
possibility like when I restore this file the backup file also remove
simultaneously so that space would be there... I am
sure it's not possible but might be some idea from you guys...
thanks
Joh wrote:
> Any possibility?
> Right now I have a 600 MB space free and on my system I have a 6 GB
> backup file and I want to restore it on my own system...
> I don't have any network where I have place this file and restore it
> from there and no DVD which support this 6 GB... any
> possibility like when I restore this file the backup file also remove
> simultaneously so that space would be there... I am
> sure it's not possible but might be some idea from you guys...
> thanks
Why not purchase a small USB hard drive. You can get one for about $129
that will give you the needed space for these type of operations. Or a
second internal hard drive which might be cheaper. Or a friend's
networked PC or laptop.
David G.

any link to capacity management for SQL Servers ?

This is not just tied to disk space, but also CPU load, IO, n/w
throughput,etc.. Thank you.Hi Hassan
"Hassan" wrote:
> This is not just tied to disk space, but also CPU load, IO, n/w
> throughput,etc.. Thank you.
>
Something like MOM http://www.microsoft.com/mom/default.mspx
and
http://searchwincomputing.techtarget.com/productsOfTheYearWinner/0,296407,sid68_gci1157325_tax302584_ayr2005,00.html?
Others would be IBM Tivoli, HP Openview, CA Unicenter etc...
John|||Thank you John,
But I was looking for some white paper doc that would tell me what to look
for when one is doing capacity management planning
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:71637728-BAC0-4D39-A819-9FB338983617@.microsoft.com...
> Hi Hassan
> "Hassan" wrote:
>> This is not just tied to disk space, but also CPU load, IO, n/w
>> throughput,etc.. Thank you.
> Something like MOM http://www.microsoft.com/mom/default.mspx
> and
> http://searchwincomputing.techtarget.com/productsOfTheYearWinner/0,296407,sid68_gci1157325_tax302584_ayr2005,00.html?
> Others would be IBM Tivoli, HP Openview, CA Unicenter etc...
> John

any link to capacity management for SQL Servers ?

This is not just tied to disk space, but also CPU load, IO, n/w
throughput,etc.. Thank you.
Hi Hassan
"Hassan" wrote:

> This is not just tied to disk space, but also CPU load, IO, n/w
> throughput,etc.. Thank you.
>
Something like MOM http://www.microsoft.com/mom/default.mspx
and
[url]http://searchwincomputing.techtarget.com/productsOfTheYearWinner/0,296407,sid68_gci1157325_tax302584_ayr2005,00.htm l?[/url]
Others would be IBM Tivoli, HP Openview, CA Unicenter etc...
John
|||Thank you John,
But I was looking for some white paper doc that would tell me what to look
for when one is doing capacity management planning
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:71637728-BAC0-4D39-A819-9FB338983617@.microsoft.com...
> Hi Hassan
> "Hassan" wrote:
> Something like MOM http://www.microsoft.com/mom/default.mspx
> and
> [url]http://searchwincomputing.techtarget.com/productsOfTheYearWinner/0,296407,sid68_gci1157325_tax302584_ayr2005,00.htm l?[/url]
> Others would be IBM Tivoli, HP Openview, CA Unicenter etc...
> John

any link to capacity management for SQL Servers ?

This is not just tied to disk space, but also CPU load, IO, n/w
throughput,etc.. Thank you.Hi Hassan
"Hassan" wrote:

> This is not just tied to disk space, but also CPU load, IO, n/w
> throughput,etc.. Thank you.
>
Something like MOM http://www.microsoft.com/mom/default.mspx
and
http://searchwincomputing.techtarge...yr2005,00.html?
Others would be IBM Tivoli, HP Openview, CA Unicenter etc...
John|||Thank you John,
But I was looking for some white paper doc that would tell me what to look
for when one is doing capacity management planning
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:71637728-BAC0-4D39-A819-9FB338983617@.microsoft.com...
> Hi Hassan
> "Hassan" wrote:
>
> Something like MOM http://www.microsoft.com/mom/default.mspx
> and
> http://searchwincomputing.techtarge...yr2005,00.html?
> Others would be IBM Tivoli, HP Openview, CA Unicenter etc...
> John