Scripting

I've got SS 2000 on Win 2000 and need to do some o/s scripting to interact
with HP Openview for monitoring purposes. What I want to do is 1) pull the
location of the temp mdf using sp_helpfile and then 2) feed that into
Openview or just get the size directly using sp_spaceused and feed that into
Openview. [I have other scripts I want to run that would use osql.]
So the bottom line is that I need a crash course in vbscript (or any other
scripting language that you'd recommend that can run from the command line
and interact with Openview). How I can get this crash course? Any
books/sites that you'd recommend?Nevermind. I found an old thread of mine.
"CLM" wrote:

> I've got SS 2000 on Win 2000 and need to do some o/s scripting to interact
> with HP Openview for monitoring purposes. What I want to do is 1) pull th
e
> location of the temp mdf using sp_helpfile and then 2) feed that into
> Openview or just get the size directly using sp_spaceused and feed that in
to
> Openview. [I have other scripts I want to run that would use osql.]
> So the bottom line is that I need a crash course in vbscript (or any other
> scripting language that you'd recommend that can run from the command line
> and interact with Openview). How I can get this crash course? Any
> books/sites that you'd recommend?|||Nevermind. I found an old thread of mine.
"CLM" wrote:

> I've got SS 2000 on Win 2000 and need to do some o/s scripting to interact
> with HP Openview for monitoring purposes. What I want to do is 1) pull th
e
> location of the temp mdf using sp_helpfile and then 2) feed that into
> Openview or just get the size directly using sp_spaceused and feed that in
to
> Openview. [I have other scripts I want to run that would use osql.]
> So the bottom line is that I need a crash course in vbscript (or any other
> scripting language that you'd recommend that can run from the command line
> and interact with Openview). How I can get this crash course? Any
> books/sites that you'd recommend?sql

Scripting

I've got SS 2000 on Win 2000 and need to do some o/s scripting to interact
with HP Openview for monitoring purposes. What I want to do is 1) pull the
location of the temp mdf using sp_helpfile and then 2) feed that into
Openview or just get the size directly using sp_spaceused and feed that into
Openview. [I have other scripts I want to run that would use osql.]
So the bottom line is that I need a crash course in vbscript (or any other
scripting language that you'd recommend that can run from the command line
and interact with Openview). How I can get this crash course? Any
books/sites that you'd recommend?Nevermind. I found an old thread of mine.
"CLM" wrote:
> I've got SS 2000 on Win 2000 and need to do some o/s scripting to interact
> with HP Openview for monitoring purposes. What I want to do is 1) pull the
> location of the temp mdf using sp_helpfile and then 2) feed that into
> Openview or just get the size directly using sp_spaceused and feed that into
> Openview. [I have other scripts I want to run that would use osql.]
> So the bottom line is that I need a crash course in vbscript (or any other
> scripting language that you'd recommend that can run from the command line
> and interact with Openview). How I can get this crash course? Any
> books/sites that you'd recommend?

Scrash OS, Win 2000 server while restoring SQL server database

Hi All,
I have a problem with restoring SQL server database:
OS: Window 2000 server
Database: SQL server 2000, SP3a
Hardware Configuration:
1 CPU P4 3GHz
HDD: 120GB (C:60GB, D:140GB)
Backup file size: 30GB
I want to restore it on D driver.
Restoring process went over 60% then an popup dialog show up that "Operating
system is shutting down" and count down time in 60 seconds.
After reboot, an error : "NTLDR is missing. Press any key to continue"
Windows can't boot.
Please tell me what problem I had and how to solve it.
Thanks in advanced
TN
Remove the floppy disk from the floppy drive.
Remove any CD from a CD/DVD drive.
Try and reboot. If that doesn't work, use your recovery disk.
Geoff N. Hiten
Microsoft SQL Server MVP
"TN" <TN@.discussions.microsoft.com> wrote in message
news:416A7A3D-F9A6-4E29-991B-DC035D085C65@.microsoft.com...
> Hi All,
> I have a problem with restoring SQL server database:
> OS: Window 2000 server
> Database: SQL server 2000, SP3a
> Hardware Configuration:
> 1 CPU P4 3GHz
> HDD: 120GB (C:60GB, D:140GB)
> Backup file size: 30GB
> I want to restore it on D driver.
> Restoring process went over 60% then an popup dialog show up that
> "Operating
> system is shutting down" and count down time in 60 seconds.
> After reboot, an error : "NTLDR is missing. Press any key to continue"
> Windows can't boot.
> Please tell me what problem I had and how to solve it.
> Thanks in advanced
> TN

Scrash OS, Win 2000 server while restoring SQL server database

Hi All,
I have a problem with restoring SQL server database:
OS: Window 2000 server
Database: SQL server 2000, SP3a
Hardware Configuration:
1 CPU P4 3GHz
HDD: 120GB (C:60GB, D:140GB)
Backup file size: 30GB
I want to restore it on D driver.
Restoring process went over 60% then an popup dialog show up that "Operating
system is shutting down" and count down time in 60 seconds.
After reboot, an error : "NTLDR is missing. Press any key to continue"
Windows can't boot.
Please tell me what problem I had and how to solve it.
Thanks in advanced
TNRemove the floppy disk from the floppy drive.
Remove any CD from a CD/DVD drive.
Try and reboot. If that doesn't work, use your recovery disk.
Geoff N. Hiten
Microsoft SQL Server MVP
"TN" <TN@.discussions.microsoft.com> wrote in message
news:416A7A3D-F9A6-4E29-991B-DC035D085C65@.microsoft.com...
> Hi All,
> I have a problem with restoring SQL server database:
> OS: Window 2000 server
> Database: SQL server 2000, SP3a
> hardware Configuration:
> 1 CPU P4 3GHz
> HDD: 120GB (C:60GB, D:140GB)
> Backup file size: 30GB
> I want to restore it on D driver.
> Restoring process went over 60% then an popup dialog show up that
> "Operating
> system is shutting down" and count down time in 60 seconds.
> After reboot, an error : "NTLDR is missing. Press any key to continue"
> Windows can't boot.
> Please tell me what problem I had and how to solve it.
> Thanks in advanced
> TN

Scrash OS, Win 2000 server while restoring SQL server database

Hi All,
I have a problem with restoring SQL server database:
OS: Window 2000 server
Database: SQL server 2000, SP3a
Hardware Configuration:
1 CPU P4 3GHz
HDD: 120GB (C:60GB, D:140GB)
Backup file size: 30GB
I want to restore it on D driver.
Restoring process went over 60% then an popup dialog show up that "Operating
system is shutting down" and count down time in 60 seconds.
After reboot, an error : "NTLDR is missing. Press any key to continue"
Windows can't boot.
Please tell me what problem I had and how to solve it.
Thanks in advanced
TNRemove the floppy disk from the floppy drive.
Remove any CD from a CD/DVD drive.
Try and reboot. If that doesn't work, use your recovery disk.
Geoff N. Hiten
Microsoft SQL Server MVP
"TN" <TN@.discussions.microsoft.com> wrote in message
news:416A7A3D-F9A6-4E29-991B-DC035D085C65@.microsoft.com...
> Hi All,
> I have a problem with restoring SQL server database:
> OS: Window 2000 server
> Database: SQL server 2000, SP3a
> Hardware Configuration:
> 1 CPU P4 3GHz
> HDD: 120GB (C:60GB, D:140GB)
> Backup file size: 30GB
> I want to restore it on D driver.
> Restoring process went over 60% then an popup dialog show up that
> "Operating
> system is shutting down" and count down time in 60 seconds.
> After reboot, an error : "NTLDR is missing. Press any key to continue"
> Windows can't boot.
> Please tell me what problem I had and how to solve it.
> Thanks in advanced
> TN