Viewing 15 posts - 2,356 through 2,370 (of 2,756 total)
Working with CommVault backups here, names like that seem to be "virtual devices" created just for the backup to go to. It's not a "file" or "folder" as such,...
July 11, 2013 at 10:29 am
OK, quick tested this on a QA copy of the DB in question, and if the role membership is NULL, you can connect to SQL (expected) but you can't query...
July 9, 2013 at 12:42 pm
WHAT HAPPENED TO THE FORUMS?
I go away for a couple hours and everything gets moved around! I *LIKED* the furniture where it was, my chair was in just the...
July 9, 2013 at 12:02 pm
A bigger issue to making a SQL Server a DC is the permissions that get set. I once (accidently) started to promote a SQL Server to be a DC...
July 9, 2013 at 9:35 am
That's what I thought. I figured setting it to offline for the restore would prevent connections, having seen several postings here from people trying to do maintenance in single-user...
July 8, 2013 at 8:56 am
Koen Verbeeck (7/6/2013)
Last holiday we went with the kids to a cabin park. Close by was an amazing dolfinarium. It was closed the week we were there for maintenance...
You wouldn't...
July 8, 2013 at 8:08 am
If this day were going any slower, it'd still be 7:30am...
I could probably take databases offline then back online them in 5 minutes and nobody would notice...
July 5, 2013 at 11:18 am
opc.three (7/5/2013)
jasona.work (7/5/2013)
might work.
It might. Or it might randomly skip databases. sp_MsForEachDb is fatally flawed and although Microsoft seems happy enough to employ it within their own Maintenance Plan code,...
July 5, 2013 at 9:45 am
steve.spenceST (7/5/2013)
We hold these truths to be self-evident, that all men are created equal, that they are endowed by their Creator with certain...
July 5, 2013 at 9:31 am
JAZZ Master (7/5/2013)
crookj (7/5/2013)
WOTD - discombobulatedDisco Bob is late
Look into my eye sockets!
:w00t:
July 5, 2013 at 9:27 am
Steve Jones - SSC Editor (7/5/2013)
July 5, 2013 at 8:31 am
I think you might be able to get this work with SP_MSForEachDB still. I've got a script to get a list of all DBs and any orphaned users in...
July 5, 2013 at 8:27 am
Koen Verbeeck (7/5/2013)
jasona.work (7/5/2013)
I could've driven a golf ball across...
July 5, 2013 at 6:01 am
While it would be rather hard to prepare for, perhaps actually having some "improv" type seminars mixed in with the pre-planned topics might be a good idea. Possibly have...
July 5, 2013 at 5:30 am
You *KNOW* it's going to be a slow day when you get in at your normal time, and get front-row parking...
I could've driven a golf ball across the parking lot...
July 5, 2013 at 5:17 am
Viewing 15 posts - 2,356 through 2,370 (of 2,756 total)