the system databases are always database ID (dbid) 1 -4, so use where clause

where database_id > 4

these will always be user databases.

If you have reporting services this will include...

use the backup details in msdb - this query will tell you when a database was last backed up (full backup)

select a.name, b.backup_finish_date, a.crdate

from master..sysdatabases a left join msdb..backupset b...

its a...

any replies to this last question in the thread to here

let the dbcc run through to completion, is it faster than on the old server?

look at the parallelism setting, does overall CPU come down if that is scaled back from...

error 112 is definitely a space issue.

no, sorry. Check your server level settings.

during the migration window I would just run dbcc updateusage() and sp_updatestats, thats enough to get the database performing under the new version..

I presume you run checkdbs on a regular...

in this situation its totally unnecessary, a restore will overwrite the database as you want it.

why start detaching production databases and then not using the log file when you don't...

to everyone out there, attach with rebuild log is a last resort, please don't replace restores with it.

kevaburg (3/20/2013)

---

Actually, it can be faster and more reliable than a backup and whats more it will always be consistent. The reason for that is in what happens when...

as far as i know this restore is done. ending up with the files you want is all doable via a restore of a bak file, starting to take risks...

another thing - have you run any reindexes whilst monitoring largest log size? Thats likely to be your biggest user of log space

this could be a chance to really tidy up the log and reduce the number of vlfs as well. I would try shrinking the log right down to 1mb, and...

sql 2008 enterprise has this feature. From Sql 2008R2 it was available in the standard edition.

If you are on 2008 standard there are a number of third party tools that...