Viewing 15 posts - 13,681 through 13,695 (of 39,818 total)
Stefan Krzywicki (5/23/2012)
Surely we can all just agree to hate Dallas?
No
May 24, 2012 at 9:39 am
Evil Kraig F (5/23/2012)
This isn't a psychological experiment unless you're trying to determine the psychosis of a Bronco's fan in light of the fact that their team simply sucks.
Ahem, unlike...
May 23, 2012 at 3:42 pm
SQLRNNR (5/23/2012)
Steve Jones - SSC Editor (5/23/2012)
Stefan Krzywicki (5/23/2012)
Tom Brady? He'll be retiring soon.We can only hope.
Nah - I want to see him beat down the Broncos and Peyton every...
May 23, 2012 at 2:26 pm
Stefan Krzywicki (5/23/2012)
Tom Brady? He'll be retiring soon.
We can only hope.
May 23, 2012 at 1:35 pm
I believe that the way you have the maint plan set, it will create a new file by default. If you pick a specific file, you can access the drop...
May 23, 2012 at 12:23 pm
Look in the Configuration Manager. This is an application running on the server. That's what I referenced in the last post.
If you don't understand that, please use Books Online to...
May 23, 2012 at 12:18 pm
Not login, service account.
SQL Server runs as a service (control panel | services, or Configuration Manager). The account that runs SQL Server is what accesses the backup file.
May 23, 2012 at 12:14 pm
Append adds the new backup data to the same file. Essentially you get one file like this:
-----------------------------------------
backup 1 | backup 2 | backup 3 |
-----------------------------------------
all stored in one file in...
May 23, 2012 at 11:35 am
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
Viewing 15 posts - 13,681 through 13,695 (of 39,818 total)