<div>
Thanks, Z. That seems like a good solution and I'll give it a try.
</div>


Thanks, Z. That seems like a good solution and I'll give it a try.

<div>
<div class="content wysiwyg-content">
I have a DTS package that puts a database into single-user mode, copies it to another server, then puts it back into multi-user mode. I created it using the Copy Database Wizard. Both SQL servers are SQL Server 2008 R2. The job runs in the middle of the night and most nights it works just fine.<br />
<br />
The job is run on the server the database is being copied to. <br />
<br />
Now and then, however, the job starts, puts the database into single-user mode, deletes the database on the server being copied to, then stops. The database doesn't get copied nor does it get put back into multi-user mode. All I see in the logs is that the database was put into single-user mode, nothing else. When it works correctly, the log also shows the database starting up about 3 minutes later, which is when the job has finished.<br />
<br />
Without buying monitoring software, is there some way to figure out what's going on?
</div>
</div>


I have a DTS package that puts a database into single-user mode, copies it to another server, then puts it back into multi-user mode. I created it using the Copy Database Wizard. Both SQL servers are SQL Server 2008 R2. The job runs in the middle of the night and most nights it works just fine.

The job is run on the server the database is being copied to. 

Now and then, however, the job starts, puts the database into single-user mode, deletes the database on the server being copied to, then stops. The database doesn't get copied nor does it get put back into multi-user mode. All I see in the logs is that the database was put into single-user mode, nothing else. When it works correctly, the log also shows the database starting up about 3 minutes later, which is when the job has finished.

Without buying monitoring software, is there some way to figure out what's going on?

SQL Server 2008 DTS Package Leaves Database in Single-User Mode

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.