Something like this ?

SELECT sysdb.name, bkup.description, bkup.backup_finish_date,

case

when type='D' then '** FULL **'

when type='I' then 'DIFFERENTIAL'

when type='L' then 'LOG'

end as Backup_Type,

(STR(ABS(DATEDIFF(day, GetDate(),(backup_finish_date))))) as 'Days_Ago',

ceiling(bkup.backup_size /1048576)...

Is it a domain account ? Did the Network Admin change something ?

Dan Thomas (2/5/2009)

---

I'm looking for a tool which will make backing up sql server as frictionless as possible. Ideally offering incremental backups (so as to reduce file size for our...

What does the native SQL Backup not do for you (other than compression) ?

And if you have lots of them to change:

SELECT 'ALTER SCHEMA NewSchema TRANSFER ' + '['+TABLE_SCHEMA+']' + '.' + TABLE_NAME

FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'OldSchema'

order by TABLE_NAME

I've never encountered that. It shows disabled in the GUI ? Does the "Last Run" get updated afterwards ?

If you look at the "enabled" field in msdb..sysjobs,...

phrankbooth (2/5/2009)

---

Hello,

I can't seem to reconcile this and can't find a clear explanation on it.

I have a Job set up with a Recurring schedule.

When both Job and its Schedule are...

Did you click "refresh" ?

And next time use a BEGIN TRAN so you can roll back if needed.

FYI, when making changes to data like this, I usually take a few precautions.

1. Back up the...

I'm pretty much a production DBA. Responsible for backups, security, troubleshooting, performance, upgrades .... Also working with developers...

Create 1 job schedule that runs once every month on the 1st. Then create another job schedule that runs once a month on the 16th.

Does anyone know of a SQL 2000 compatible tool that will show the cost of queries ?? I'd like to know which queries run during the day are taking...

I started working my way through the article, removing registry settings, and got an error. The article said if I get that error to call microsoft support .... Good...

I found this, which seems to address my problem:

http://support.microsoft.com/kb/909967 (What a convoluted PIA !!)

Yes, there was an "Advanced" tab, with an option to change the path, but I must have done something wrong because it had no effect at the end.