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] [EMAIL PROTECTED]
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] [EMAIL PROTECTED]
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
