Tag Archives: MSDB

Which databases were backed up in which backup task?

It’s a confusing question / title / headline. Let’s see if I can clarify what I’m after. For each scheduled backup job, which databases were backed up? And (more to the point) which databases weren’t backed up? And how can … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , | 3 Comments

How long before that backup completes?

An early start this morning, as I need to back up a big reporting database before the guys at work start running some heavy optimisation process to rationalise and compress the data. ¬†However, I don’t necessarily know how long the … Continue reading

Posted in SQLServerPedia Syndication | Tagged , , , | 2 Comments

T-SQL Tuesday #16 – Aggregates and Average Weekly Backup Sizes

T-SQL Tuesday this month is hosted by Jes Borland. T-SQL Tuesday, which occurs on the second Tuesday of each month, provides an opportunity for many SQL Server bloggers to come together to discuss a single issue, selected by the host … Continue reading

Posted in SQLServerPedia Syndication, T-SQL Tuesday | Tagged , , , , | 2 Comments