#15325 [Com]: mssql_query returns early

ID: 15325 Comment by: sargon at tut dot by Reported By: mike at dct-mail dot com Status: Bogus Bug Type: MSSQL related Operating System: Windows 2000 Server PHP Version: 4.1.1 New Comment: I've change PHP 4.3.1 -> 4.3.2 and all works fine with same settings. So I think the bug is in 4.3.1 Previous Comments: ------------------------------------------------------------------------ [2003-12-19 23:44:16] fmk@php.net Both php4 and php5 works fine with backups. You need to create the decice fiest with a command like this: sp_addumpdevice 'disk', 'DC_Northwind', 'c:\backup' This code create the backup $con = mssql_connect("pear_mdb", "sa", ""); if ($con) { mssql_select_db("master", $con); $rs = mssql_query("BACKUP DATABASE Northwind TO DC_Northwind with format", $con); mssql_close($con); } Notice the with format, this forces the device to be overwritten on each backup. ------------------------------------------------------------------------ [2003-12-18 13:07:21] sargon at tut dot by Me too! The same error. Php ver. 4.3.1; WinXP Pro; MSSQL 2000 SP3. ------------------------------------------------------------------------ [2002-10-28 10:53:55] sterling@php.net not a php extension issue... ------------------------------------------------------------------------ [2002-02-08 02:54:07] mike at dct-mail dot com The return from mssql_query() appears to be immediate. When the call to sleep() is present, the backup continues and completes during the sleep() and the execution timer isn't exceeded. (I verified by using a sleep(300) and did get the timer exceeded error.) ------------------------------------------------------------------------ [2002-02-07 23:47:50] ollie at cronky dot net Is the backup taking longer than your max script execution time (in php.ini) by any chance? ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/15325 -- Edit this bug report at http://bugs.php.net/?id=15325&edit=1