Viewing 15 posts - 31 through 45 (of 63 total)
Ok, so now that I've gotten that out of the way, here's some of the details of the path I've started down:
I created a db user [BuiltinAdminUser] in multiple databases....
September 6, 2011 at 8:08 pm
Thanks for your replies and input, everyone. I realized after I made the post that it could quickly spiral out of control into a dba's vs developers free-for-all. ...
September 6, 2011 at 8:06 pm
BTW,
I found this related submission on MS Connect: Incorrect error number passed to catch block
Please go there and vote for it as an important issue. (You'll have to...
December 14, 2010 at 11:07 am
Derrick Smith (10/12/2010)
In the step of the job on the Advanced tab, specify an output file (.txt). It will log all errors to that.
Thanks, Derrick. That helps some.
Ideally, what...
October 12, 2010 at 3:07 pm
Dave Mason (10/8/2010)
Msg 3002, Level 16, State 1, Line 1Cannot BACKUP or RESTORE a database snapshot.
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
Does SQL Server record...
October 12, 2010 at 2:25 pm
I guess you could say I'm a little late to the party. 🙂 But thanks, Andy! And thanks to those who have commented.
You all helped...
May 26, 2010 at 2:54 pm
Followup...
I'm really reluctant to drop and recreate indexes. Let's say another dba or developer changes the index (add/remove columns to/from the index, change the FILLFACTOR, etc). My code...
May 26, 2010 at 2:46 pm
Jack Corbett (3/24/2010)
I always ask this , but hesitated since other email is getting through, but check your anti-virus settings. Sometimes it blocks email mass mailing worms.
The only other...
March 24, 2010 at 3:11 pm
MeltonDBA (3/23/2010)
Quick note...I would take that email reference out of your post. Don't think you want alot of people emailing your phone all of the sudden 😀
Thanks, Shawn. ...
March 24, 2010 at 3:04 pm
Jack Corbett (3/23/2010)
Can you send pages to the pager from your email client (Outlook)?
In a word, yes.
March 24, 2010 at 2:55 pm
Dave Mason (3/1/2010)
The last time the database was restored was nearly 3 months ago (2009-12-12 15:16:04.330)...
It looks like I was wrong. The database was restored yesterday from the snapshot....
March 1, 2010 at 12:45 pm
Dave Mason (2/9/2010)
February 12, 2010 at 3:34 pm
Thank you all for your input. It has been very helpful. I made my initial posting after I created some documentation for our backup/DR plan. As I...
February 9, 2010 at 11:56 am
I stumbled upon this stored proc (which should meet my needs quite nicely): msdb.dbo.sp_delete_backuphistory
Is this the sp you were referring to, Homebrew?
January 29, 2010 at 12:15 pm
Thanks, Steve.
I'm not using SSMS for backups or restores, so I don't think that will be an issue.
My personal preference is to use tsql to do the the...
January 29, 2010 at 11:03 am
Viewing 15 posts - 31 through 45 (of 63 total)