Cannot execute through ISQL

Hi,
I cannot execute ISQL query from dos prompt to one
specific MS SQL Server 2000 production machine, but works
fine with other server any reason
Please let me know ASAP
Thanks & Regards,
Mustaq
What 's the problem? Any error messages?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Mustaq" <mustaqhussain@.hotmail.com> wrote in message
news:2700c01c46271$e512d660$a301280a@.phx.gbl...
Hi,
I cannot execute ISQL query from dos prompt to one
specific MS SQL Server 2000 production machine, but works
fine with other server any reason
Please let me know ASAP
Thanks & Regards,
Mustaq
|||Hi Vyas,
It doesn't prompts me any error message. It just comes out.
Regards,
Mustaq

>--Original Message--
>What 's the problem? Any error messages?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>"Mustaq" <mustaqhussain@.hotmail.com> wrote in message
>news:2700c01c46271$e512d660$a301280a@.phx.gbl...
>Hi,
>I cannot execute ISQL query from dos prompt to one
>specific MS SQL Server 2000 production machine, but works
>fine with other server any reason
>Please let me know ASAP
>Thanks & Regards,
>Mustaq
>
>.
>
|||Can you show us the query and the way you are trying to run the query? Are
you running it interactively or running it from a batch, by specifying a
query or input file?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Mustaq" <mustaqhussain@.hotmail.com> wrote in message
news:2667101c4627f$d424b2c0$a401280a@.phx.gbl...
Hi Vyas,
It doesn't prompts me any error message. It just comes out.
Regards,
Mustaq

>--Original Message--
>What 's the problem? Any error messages?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>"Mustaq" <mustaqhussain@.hotmail.com> wrote in message
>news:2700c01c46271$e512d660$a301280a@.phx.gbl...
>Hi,
>I cannot execute ISQL query from dos prompt to one
>specific MS SQL Server 2000 production machine, but works
>fine with other server any reason
>Please let me know ASAP
>Thanks & Regards,
>Mustaq
>
>.
>
|||Vyas,
Here is the command and query..
C:\Documents and Settings\husmu02>isql -S AH_Stage -d
AH_Baseline -U sa -q "select @.@.version"
Just to let you know the back ground
Client machine is only installed with MS SQL 7.0 Client
network utility with Mdac 2.7 and configured, Server is
SQL Server 2000 SP3, which is in WAN.
I am able to do ODBC connection and run the query but not
through isql, understand isql doesnot make use of ODBC.
Initially I was thinking to be network problem, but may
not be true, I installed MS SQL Query Analyser from 7.0
release, I can execute the query from Query Analyser
Same command and query if I specify to another MS SQL
server 2000 it works fine.
Any reason on this issue.
And can let me know how does isql work, which ports, dlls
or drivers.
Regards,
Mustaq
Regards,
Mustaq

>--Original Message--
>Can you show us the query and the way you are trying to
run the query? Are
>you running it interactively or running it from a batch,
by specifying a
>query or input file?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>"Mustaq" <mustaqhussain@.hotmail.com> wrote in message
>news:2667101c4627f$d424b2c0$a401280a@.phx.gbl...
>Hi Vyas,
>It doesn't prompts me any error message. It just comes
out.
>Regards,
>Mustaq
>
>
>.
>
|||Without any error messages, it is difficult to predict what's going on, but
can you try OSQL instead, and let me know how it goes?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Mustaq" <mustaqhussain@.hotmail.com> wrote in message
news:26d5001c462fa$7c5d1e80$a501280a@.phx.gbl...
Vyas,
Here is the command and query..
C:\Documents and Settings\husmu02>isql -S AH_Stage -d
AH_Baseline -U sa -q "select @.@.version"
Just to let you know the back ground
Client machine is only installed with MS SQL 7.0 Client
network utility with Mdac 2.7 and configured, Server is
SQL Server 2000 SP3, which is in WAN.
I am able to do ODBC connection and run the query but not
through isql, understand isql doesnot make use of ODBC.
Initially I was thinking to be network problem, but may
not be true, I installed MS SQL Query Analyser from 7.0
release, I can execute the query from Query Analyser
Same command and query if I specify to another MS SQL
server 2000 it works fine.
Any reason on this issue.
And can let me know how does isql work, which ports, dlls
or drivers.
Regards,
Mustaq
Regards,
Mustaq

>--Original Message--
>Can you show us the query and the way you are trying to
run the query? Are
>you running it interactively or running it from a batch,
by specifying a
>query or input file?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>"Mustaq" <mustaqhussain@.hotmail.com> wrote in message
>news:2667101c4627f$d424b2c0$a401280a@.phx.gbl...
>Hi Vyas,
>It doesn't prompts me any error message. It just comes
out.
>Regards,
>Mustaq
>
>
>.
>
|||Vyas,
Thanks, got resolved by setting TCP/IP and configuring it.
Regards,
Mustaq

>--Original Message--
>Without any error messages, it is difficult to predict
what's going on, but[vbcol=seagreen]
>can you try OSQL instead, and let me know how it goes?
>--
>HTH,
>Vyas, MVP (SQL Server)
>http://vyaskn.tripod.com/
>Is .NET important for a database professional?
>http://vyaskn.tripod.com/poll.htm
>
>"Mustaq" <mustaqhussain@.hotmail.com> wrote in message
>news:26d5001c462fa$7c5d1e80$a501280a@.phx.gbl...
>Vyas,
>Here is the command and query..
>C:\Documents and Settings\husmu02>isql -S AH_Stage -d
>AH_Baseline -U sa -q "select @.@.version"
>Just to let you know the back ground
>Client machine is only installed with MS SQL 7.0 Client
>network utility with Mdac 2.7 and configured, Server is
>SQL Server 2000 SP3, which is in WAN.
>I am able to do ODBC connection and run the query but not
>through isql, understand isql doesnot make use of ODBC.
>Initially I was thinking to be network problem, but may
>not be true, I installed MS SQL Query Analyser from 7.0
>release, I can execute the query from Query Analyser
>Same command and query if I specify to another MS SQL
>server 2000 it works fine.
>Any reason on this issue.
>And can let me know how does isql work, which ports, dlls
>or drivers.
>Regards,
>Mustaq
>Regards,
>Mustaq
>run the query? Are
>by specifying a
>out.
works
>
>.
>

Cannot copy : Insufficient system resources

Production Server: Win2k Advanced Server, SQL 2k Advanced Server, Both fully
patched, 4 processors, 5 GB RAM, 320 GB partition, 68 GB DataBase, SAN, 2 2GB
Fiber NICS teamed
Development Server: Win2k Server, SQL 2k Server, two processors, 2 GB RAM,
Raid 5 SCSI controller, 4 100 mb NICS teamed
Both servers have lots of room on the partition.
We've been refreshing the development server with fresh production data
every three months. My method for doing this has been to do a local backup of
the production server, then copy the bak file to the development server. This
has been working for several years. The bak file is now 70 GB. The last time
it worked the bak file was around 65 GB. Last night the copy of the bak file
over the network failed about halfway through with a popup:
"Cannot copy prd. bak : Insufficient system resources exist to complete the
requested service" There are no entries in either server's application or
system event logs. I've read the MSFT KB Article 259837 but that doesn't seem
to apply because (a) the failure occured about one hour into the copy process
and (b) both servers are fully patched.
Developers are beating on me to get this done tonight. I suspect in the long
run, I will have to get something like SQL lite speed. But I would like a
quick fix for tonight. I would prefer not to shut down the production db and
copy the individual files.
Here are my thoughts:
1. Would I have better luck if I backed up with a UNC path to the
development server?
2. Can I compress the bak file with something?
Any suggestions?Personally, I prefer working with UNC paths for backups.
HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/default.aspx?scid=kb;en-us;555128
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"MangroveGeek" <carl@.tenthousandislands.net(DoNotSpam)> wrote in message
news:130BD949-316B-44F2-9117-B30B9477D24C@.microsoft.com...
> Production Server: Win2k Advanced Server, SQL 2k Advanced Server, Both
> fully
> patched, 4 processors, 5 GB RAM, 320 GB partition, 68 GB DataBase, SAN, 2
> 2GB
> Fiber NICS teamed
> Development Server: Win2k Server, SQL 2k Server, two processors, 2 GB RAM,
> Raid 5 SCSI controller, 4 100 mb NICS teamed
> Both servers have lots of room on the partition.
> We've been refreshing the development server with fresh production data
> every three months. My method for doing this has been to do a local backup
> of
> the production server, then copy the bak file to the development server.
> This
> has been working for several years. The bak file is now 70 GB. The last
> time
> it worked the bak file was around 65 GB. Last night the copy of the bak
> file
> over the network failed about halfway through with a popup:
> "Cannot copy prd. bak : Insufficient system resources exist to complete
> the
> requested service" There are no entries in either server's application or
> system event logs. I've read the MSFT KB Article 259837 but that doesn't
> seem
> to apply because (a) the failure occured about one hour into the copy
> process
> and (b) both servers are fully patched.
> Developers are beating on me to get this done tonight. I suspect in the
> long
> run, I will have to get something like SQL lite speed. But I would like a
> quick fix for tonight. I would prefer not to shut down the production db
> and
> copy the individual files.
> Here are my thoughts:
> 1. Would I have better luck if I backed up with a UNC path to the
> development server?
> 2. Can I compress the bak file with something?
> Any suggestions?

Cannot copy : Insufficient system resources

Production Server: Win2k Advanced Server, SQL 2k Advanced Server, Both fully
patched, 4 processors, 5 GB RAM, 320 GB partition, 68 GB DataBase, SAN, 2 2G
B
Fiber NICS teamed
Development Server: Win2k Server, SQL 2k Server, two processors, 2 GB RAM,
Raid 5 SCSI controller, 4 100 mb NICS teamed
Both servers have lots of room on the partition.
We've been refreshing the development server with fresh production data
every three months. My method for doing this has been to do a local backup o
f
the production server, then copy the bak file to the development server. Thi
s
has been working for several years. The bak file is now 70 GB. The last time
it worked the bak file was around 65 GB. Last night the copy of the bak file
over the network failed about halfway through with a popup:
"Cannot copy prd. bak : Insufficient system resources exist to complete the
requested service" There are no entries in either server's application or
system event logs. I've read the MSFT KB Article 259837 but that doesn't see
m
to apply because (a) the failure occured about one hour into the copy proces
s
and (b) both servers are fully patched.
Developers are beating on me to get this done tonight. I suspect in the long
run, I will have to get something like SQL lite speed. But I would like a
quick fix for tonight. I would prefer not to shut down the production db and
copy the individual files.
Here are my thoughts:
1. Would I have better luck if I backed up with a UNC path to the
development server?
2. Can I compress the bak file with something?
Any suggestions?Personally, I prefer working with UNC paths for backups.
HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/defaul...kb;en-us;555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"MangroveGeek" <carl@.tenthousandislands.net(DoNotSpam)> wrote in message
news:130BD949-316B-44F2-9117-B30B9477D24C@.microsoft.com...
> Production Server: Win2k Advanced Server, SQL 2k Advanced Server, Both
> fully
> patched, 4 processors, 5 GB RAM, 320 GB partition, 68 GB DataBase, SAN, 2
> 2GB
> Fiber NICS teamed
> Development Server: Win2k Server, SQL 2k Server, two processors, 2 GB RAM,
> Raid 5 SCSI controller, 4 100 mb NICS teamed
> Both servers have lots of room on the partition.
> We've been refreshing the development server with fresh production data
> every three months. My method for doing this has been to do a local backup
> of
> the production server, then copy the bak file to the development server.
> This
> has been working for several years. The bak file is now 70 GB. The last
> time
> it worked the bak file was around 65 GB. Last night the copy of the bak
> file
> over the network failed about halfway through with a popup:
> "Cannot copy prd. bak : Insufficient system resources exist to complete
> the
> requested service" There are no entries in either server's application or
> system event logs. I've read the MSFT KB Article 259837 but that doesn't
> seem
> to apply because (a) the failure occured about one hour into the copy
> process
> and (b) both servers are fully patched.
> Developers are beating on me to get this done tonight. I suspect in the
> long
> run, I will have to get something like SQL lite speed. But I would like a
> quick fix for tonight. I would prefer not to shut down the production db
> and
> copy the individual files.
> Here are my thoughts:
> 1. Would I have better luck if I backed up with a UNC path to the
> development server?
> 2. Can I compress the bak file with something?
> Any suggestions?

Cannot copy : Insufficient system resources

Production Server: Win2k Advanced Server, SQL 2k Advanced Server, Both fully
patched, 4 processors, 5 GB RAM, 320 GB partition, 68 GB DataBase, SAN, 2 2GB
Fiber NICS teamed
Development Server: Win2k Server, SQL 2k Server, two processors, 2 GB RAM,
Raid 5 SCSI controller, 4 100 mb NICS teamed
Both servers have lots of room on the partition.
We've been refreshing the development server with fresh production data
every three months. My method for doing this has been to do a local backup of
the production server, then copy the bak file to the development server. This
has been working for several years. The bak file is now 70 GB. The last time
it worked the bak file was around 65 GB. Last night the copy of the bak file
over the network failed about halfway through with a popup:
"Cannot copy prd. bak : Insufficient system resources exist to complete the
requested service" There are no entries in either server's application or
system event logs. I've read the MSFT KB Article 259837 but that doesn't seem
to apply because (a) the failure occured about one hour into the copy process
and (b) both servers are fully patched.
Developers are beating on me to get this done tonight. I suspect in the long
run, I will have to get something like SQL lite speed. But I would like a
quick fix for tonight. I would prefer not to shut down the production db and
copy the individual files.
Here are my thoughts:
1. Would I have better luck if I backed up with a UNC path to the
development server?
2. Can I compress the bak file with something?
Any suggestions?
Personally, I prefer working with UNC paths for backups.
HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/default...b;en-us;555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"MangroveGeek" <carl@.tenthousandislands.net(DoNotSpam)> wrote in message
news:130BD949-316B-44F2-9117-B30B9477D24C@.microsoft.com...
> Production Server: Win2k Advanced Server, SQL 2k Advanced Server, Both
> fully
> patched, 4 processors, 5 GB RAM, 320 GB partition, 68 GB DataBase, SAN, 2
> 2GB
> Fiber NICS teamed
> Development Server: Win2k Server, SQL 2k Server, two processors, 2 GB RAM,
> Raid 5 SCSI controller, 4 100 mb NICS teamed
> Both servers have lots of room on the partition.
> We've been refreshing the development server with fresh production data
> every three months. My method for doing this has been to do a local backup
> of
> the production server, then copy the bak file to the development server.
> This
> has been working for several years. The bak file is now 70 GB. The last
> time
> it worked the bak file was around 65 GB. Last night the copy of the bak
> file
> over the network failed about halfway through with a popup:
> "Cannot copy prd. bak : Insufficient system resources exist to complete
> the
> requested service" There are no entries in either server's application or
> system event logs. I've read the MSFT KB Article 259837 but that doesn't
> seem
> to apply because (a) the failure occured about one hour into the copy
> process
> and (b) both servers are fully patched.
> Developers are beating on me to get this done tonight. I suspect in the
> long
> run, I will have to get something like SQL lite speed. But I would like a
> quick fix for tonight. I would prefer not to shut down the production db
> and
> copy the individual files.
> Here are my thoughts:
> 1. Would I have better luck if I backed up with a UNC path to the
> development server?
> 2. Can I compress the bak file with something?
> Any suggestions?