Viewing 13 posts - 1 through 13 (of 13 total)
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...
September 18, 2009 at 6:51 pm
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...
July 25, 2009 at 3:53 pm
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...
July 25, 2009 at 3:44 pm
Yeah -- of course that's just my local express instance for testing... clearly tempdb is just *slightly* too small. hehe 😀
June 30, 2009 at 7:43 pm
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..." 😀
June 30, 2009 at 7:37 am
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.
June 29, 2009 at 3:30 pm
Feel free to download this HTML Application to get a good picture of used/available space in all SQL dbs on a server.
June 19, 2009 at 3:35 pm
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
June 18, 2009 at 10:39 pm
June 13, 2009 at 5:23 pm
June 12, 2009 at 1:39 pm
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. ...
June 12, 2009 at 1:30 pm
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...
June 12, 2009 at 9:12 am
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...
June 11, 2009 at 8:16 pm