Thanks so much Darwin for explaining how to do this. Using your methodology I scripted this in two flavors. Even on very large databases (>1TB) it will complete...

You didn't mention how you're trying to change the account that it runs under. I've noticed that if I go into the Windows Services console (services.msc) and change the...

jay (7/23/2009)

---

Thanks for you replies.

I apply the full backup with "norecovery" and apply Differential backup with "recovery". There is no requirement to apply transaction log backups.

Executed as user: TDS\clusadminspain. Cannot...

Yeah -- of course that's just my local express instance for testing... clearly tempdb is just *slightly* too small. hehe 😀

http://dougzuck.com

That makes total sense. After I posted my reply I re-read your original post and thought to myself "maybe he's already doing this..." 😀

Rather than querying to determine what databases have maintenance plans, you might want to consider querying the MSDB..backupset table to see which databases have been backed up.

In this...

Feel free to download this HTML Application to get a good picture of used/available space in all SQL dbs on a server.

http://dougzuck.com/hta

My favorite way to view available space in SQL is with a simple HTML Application I wrote. You can download it here: http://www.dougzuck.com/hta

RBarryYoung (6/12/2009)

---

Thanks Doug, I got it fixed. That link that you provided did not have my answer, but did provide the clue that I needed to figure it out....

RBarryYoung (6/12/2009)

---

dougznospam-mailbox (6/12/2009)

---

Hmmm, that sounds odd. I've been using this for years in multiple domain environments with no trouble. Additionally, it's just a straight ADO connection using integrated...

That's a great point that hadn't occurred to me since we never name databases with slash characters. Interestingly our SharePoint databases are named automatically with underscores, not slashes. ...

Hmmm, that sounds odd. I've been using this for years in multiple domain environments with no trouble. Additionally, it's just a straight ADO connection using integrated security, so...

My favorite way to view the breakdown of the used / total space in all the files of a database is with this HTML Application. It connects to a...