[dba-SQLServer]Very odd problem

Check QueryTimeout property of your connection object.

Robert Djabarov
Senior SQL Server DBA
USAA IT/DBMS
? (210) 913-3148 - phone
? (210) 753-3148 - pager

 -----Original Message-----
From: 	Arthur Fuller [mailto:artful at rogers.com] 
Sent:	Sunday, March 30, 2003 1:23 PM
To:	dba-sqlserver at databaseadvisors.com
Subject:	[dba-SQLServer]Very odd problem

I have written a tool that assumes you do not have Enterprise Manager
aboard. I run the following command from said tool:

RESTORE DATABASE ETS_SQL_27Sep02 
FROM DISK = 'E:\Program Files\Microsoft SQL
Server\MSSQL\BACKUP\ETS_SQL_27Sep02.bkp' 
WITH MOVE 'ETS_SQL_dat' TO 'f:\mssql7\data\ETS_SQL_27Sep02.mdf', 
MOVE  'ETS_SQL_log' TO 'f:\mssql7\data\ETS_SQL_27Sep02_log.ldf' 

Substitute into this your variables of choice.

If I run this from Query Analyzer it works. If I run this from my ADP it
fails on a timeout error. I don't get it. The bak file in question is > 300
MB. So what? Why would it work from QA and not from Access ADP?

This is a crippler. Advice, suggestions, spare Euros gratefully accepted :-)

Arthur

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com