使用CodeCeption（PHP）还原数据库会使数据库处于“恢复”状态_course

<div class="post-text" itemprop="text"> <p>I'm trying to restore a <strong>MSSQL database</strong> at the start of a run of acceptance tests written using <strong>CodeCeption</strong> (PHP). For those who know CodeCeption, I'm using the dump file to run the restore.</p> <p>The restore command I'm using works perfectly when run in SQL Management Studio but when run from the test suite, it stays in the "Restoring" state and is therefore not useable. Running </p> <pre><code>RESTORE DATABASE [dbname] WITH RECOVERY </code></pre> <p>at this point will fail with the message </p> <blockquote> <p>"The database cannot be recovered because the log was not restored" however running the full restore command (RESTORE DATABASE [dbname] FROM DISK....)</p> </blockquote> <p>in Management Studio at this point will work. I'm using <strong>WITH REPLACE</strong>, <strong>RECOVERY</strong> on the restore command.</p> <p>I've also looked at the following blog post (<a href="https://blogs.msdn.microsoft.com/brian_swan/2010/07/01/restoring-a-sql-server-database-from-php/" rel="nofollow">https://blogs.msdn.microsoft.com/brian_swan/2010/07/01/restoring-a-sql-server-database-from-php/</a>) but the solution posted there doesn't appear to work either. I have also tried to run the restore using combinations of xp_cmdshell and sqlcmd but still without success.</p> <p>I have theorised that the way that CodeCeption runs the dump file, it will already have a connection to the database open so I have added a </p> <pre><code>USE [master] </code></pre> <p>immediately before the restore and checked the processes in activity monitor to ensure that there are no connections to the database being restored.</p> <p>I'm convinced this is a problem somewhere in the PHP CodeCeption code which can be seen here - <a href="https://github.com/Codeception/Codeception/blob/2.1/src/Codeception/Module/Db.php" rel="nofollow">https://github.com/Codeception/Codeception/blob/2.1/src/Codeception/Module/Db.php</a></p> <p>Any suggestions?</p> </div>

php 数据库备份类下载_course

前阵子用到的php备份数据库，网上找了下，然后整合修改修改....希望对大伙方便有帮助 相关下载链接：//download.csdn.net/download/justbat/2576501?utm_