(888) 685-3101 ext. 2

IBM UDB DB2 Database restore and SQL1035N

SQL1035N  The database is currently in use.  SQLSTATE=57019 IBM UDB DB2 V9.7/10.1/10.5 on Windows/UNIX/Linux I have been trying to create a script that will refresh the test database using QA data on a regular schedule. As part of the script I force all the...
How to shrink the SQL Server log file?

How to shrink the SQL Server log file?

Error: 9002, Severity: 17, State: 2 The transaction log for database ‘mydatabase’ is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases Very often clients come to us requesting assistance because...

SQL Server backup or restore progress

SQL Server 2005/2008: Find backup and restore status/progress Ever wondered how long it would take to complete a backup or restore that is running in the background. I, for one, do not want to keep looking at the job or TSQL that is taking the backup or doing the...