[dba-SQLServer]Very odd problem

Do you have any other open connections to ETS_SQL_27Sep02?  you cannot 
restore a db while it is still in use

Billy






>From: "Arthur Fuller" <artful at rogers.com>
>Reply-To: artful at rogers.com, dba-sqlserver at databaseadvisors.com
>To: <dba-sqlserver at databaseadvisors.com>
>Subject: [dba-SQLServer]Very odd problem
>Date: Sun, 30 Mar 2003 14:22:32 -0500
>
>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
>


_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE*  
http://join.msn.com/?page=features/virus