Needed to refresh a test database from a current production database. Used the SQL redirection option to restore a production db over the top of an old test db, all seemed successful and the testing unit was/is able to work in the test environment to test an application upgrade. However, since the restore was done, the backup of the test database is failing (production db is completing with no errors) with the following messages:
in job log;
V-79-57344-33938 -
An error occurred on a query to database NGTest.
V-79-57344-33938 - 0x2000e208 (536928776)
The item SVNDATABASE01\NGTest in use - skipped.
in job history;
File is in use : \\SVNDATABASE01\D:\NextGen\DBBackup\NGTest_data_dump.BAK
None of the scenarios in the linked KB match my situation. Is there some cleanup I need to perform after the restore?
SQL server is a Win 2003 standard w sp2 running SQL 2000 in a VMWare ESXi host. 4gb RAM
The server running BE 11d is also a 2003 standard sp2 server. 2gb RAM.
The jobs are running to a B2D device on a FreeNAS v.69 box.
