Viewing 15 posts - 151 through 165 (of 280 total)
I like your thinking but would argue that unlike restoring a VM snapshot, replacing large chunks of the binaries, the physical data files, the registry poses more of a risk...
May 31, 2012 at 5:11 pm
I would go further, if this was a VM (some of mine are) then I would take a snapshot of the VM beforehand so I could restore the snapshot if...
May 31, 2012 at 11:32 am
When running DBCC SHOWCONTIG where are you getting the max disk I/O figure from? According to BOL this isn't output from this function. Are you measuring this another...
May 31, 2012 at 11:26 am
I'm trying to write a formula so it basically brings back all the primary diagnosis fields (hospital data) except the following shown below - The problem I'm having is combining...
May 31, 2012 at 5:20 am
It's an interesting point of view and I would further argue that removal of the secretary, and the empowerment of the individual to take responsibility for their own correspondence, together...
May 30, 2012 at 10:24 am
Interesting. A slightly unfair question I think since I know that tempdb cannot be backed up.
Tested on 2008 R2 RTM install and what do you know...
Msg 3147, Level 16,...
May 29, 2012 at 3:36 am
Very true - I've not even thought to check where tempdb is located(!) I'll include the system DBs - thanks.
May 29, 2012 at 3:29 am
I've scripted out a solution for this before.
Here's a more generic version. I've written a VBScript ten-liner to append the date and time to the .bak file...
May 25, 2012 at 8:39 am
That is excellent, thanks.
Sadly my new desk doesn't have much room, I'm elbow-to-elbow with my colleagues. But it'll make a useful desktop shortcut!
May 25, 2012 at 8:27 am
I'm a fan of replication but my initial thoughts are that replication could cause some problems here.
Reasons:
a) You'd need to set up a distributor, and a network share for all...
May 25, 2012 at 6:22 am
Thanks for this, I wasn't aware that CURSORs could be specified in context.
If you had posed this as a problem I would have said to deallocate and close the cursor...
May 25, 2012 at 2:44 am
What about combining it with weekly snapshot replication too? I think this will also cover off the DDL angle and while it's true that eg a table definition change won't...
May 24, 2012 at 11:50 am
What about using transactional replication to do this? To minimise load on the production, set up the distributor on a separate server (even the subscriber) and have one-way transactional...
May 24, 2012 at 9:07 am
Hi, OP here. Been following the thread over the last day and you guys have provided plenty of examples I intend to test and read up on (rCTEs for...
May 24, 2012 at 6:58 am
Viewing 15 posts - 151 through 165 (of 280 total)