Viewing 15 posts - 13,771 through 13,785 (of 39,899 total)
The name of the group has no relation to the server name. You can change it if you like, for clarity, but it doesn't matter.
May 23, 2012 at 11:24 am
Lynn has a good guess. Overall, I wouldn't worry about this too much. A backup size difference should clue you in to something happening, but the size in and of...
May 23, 2012 at 11:22 am
Overall the plan looks OK. You are burning some time in a key lookup. Have you considered including those columns in another index?
May 23, 2012 at 11:20 am
Shrink database doesn't matter for the backup sizes. Whether you have 1% free space or 80% free space, the full backup is just the data.
If the data and objects in...
May 23, 2012 at 11:18 am
This has nothing to do with your permissions. It has to do with the permissions of the service account running SQL Server. That account needs to be able to see...
May 23, 2012 at 11:08 am
Lynn Pettis (5/23/2012)
Anyone else noticing a sudden concern over the size of database backup files?
I've seen a few people question it. My guess is it's a cycle, where we have...
May 23, 2012 at 10:56 am
I think finish_date is null while it's running as well.
What I was implying is that you need a script that only sends failures to you.
May 23, 2012 at 10:55 am
The log works with a series of mini-segments inside. You can't shrink past an active segment, so if it's at the end of the file, you can't shrink.
There's a...
May 23, 2012 at 9:38 am
Note that when you write this, store the data, but don't report "success" to yourself on a regular basis. It's easy to start ignoring the failures if they occur rarely,...
May 23, 2012 at 9:36 am
niall.baird (5/22/2012)
May 23, 2012 at 9:32 am
GilaMonster (5/23/2012)
dwain.c (5/22/2012)Perhaps the next time someone asks a really silly SQL question, someone will suggest this to solve their problem:
EXEC xp_cmdshell 'format c:\'
No, because chances are someone (the OP...
May 23, 2012 at 9:28 am
richj-826679 (5/23/2012)
May 23, 2012 at 9:25 am
Your Name Here (5/23/2012)
Just about everything I know about PowerShell I've learned from writing scripts to automate a task.
That's a great tool, and a great feeling, I'm sure.
May 23, 2012 at 9:22 am
Frank Bazan (5/23/2012)
One thing that these tools will often lead to though, is a dulling of your core skills and situational awareness.
Very true. You should know how to do things,...
May 23, 2012 at 9:21 am
Wouldn't that be?
Mr or Mrs or Miss or Ms 500
Too long, and to be honest, didn't think about it. Plus, could you get to 500 home runs if you weren't...
May 23, 2012 at 9:11 am
Viewing 15 posts - 13,771 through 13,785 (of 39,899 total)