Viewing 15 posts - 16,066 through 16,080 (of 39,970 total)
Ultimately you do have to make some decisions on what to keep. Can your systems go back 2 weeks and still work? Or course, but if you go back that...
May 30, 2011 at 12:56 pm
Is this what you mean? Note that it doesn't cascade the values forward.
CREATE TABLE Foobar
( a1 datetime
, a2 datetime
, a3 datetime
, a4 datetime
, a5 datetime
)
GO
INSERT foobar (a1) SELECT '1/1/2011'
INSERT...
May 29, 2011 at 3:29 pm
I recommend keeping 2 fulls and the logs since around. After that, I've never seen the need to recover a database in the past to a point in time, so...
May 29, 2011 at 1:58 pm
Jeff Moden (5/28/2011)
Steve Jones - SSC Editor (5/27/2011)
Now we got the $27k Prius in '07, but got a $1500 tax credit and saved a ton of gas.
What did it do...
May 29, 2011 at 11:04 am
Stefan Krzywicki (5/27/2011)
I've been meaning to ask, how are your horses doing? I hear there's a quarantine in Colorado right now.
We're fine. Horses have been on property for weeks, so...
May 27, 2011 at 8:06 pm
bitbucket-25253 (5/27/2011)
May 27, 2011 at 5:27 pm
Jack Corbett (5/27/2011)
GilaMonster (5/27/2011)
Precon and spotlight! Could this PASS Summit get any better?
Sure, I could go, and attend the precon and the spotlight!
Side note for those not on Twitter, I...
May 27, 2011 at 2:49 pm
bitbucket-25253 (5/27/2011)
May 27, 2011 at 2:47 pm
Stefan Krzywicki (5/27/2011)
GSquared (5/27/2011)
May 27, 2011 at 2:45 pm
The passwords in native SQL Server backups are weak.
I was thinking more of managing the encryption keys/passwords for third party tools that encrypt the backups. Tools like SQL Backup...
May 27, 2011 at 9:19 am
mgraham 67977 (5/27/2011)
May 27, 2011 at 9:13 am
Arrgggghhhhh.
My apologies. The second sentence was intended to be an example, not part of the questions and I inadvertently phrased it backwards.
I've awarded back points to everyone so far and...
May 27, 2011 at 9:11 am
you don't add the service name. You add the account under which the service runs. Those are separate things.
The service name is just meta data, like the full name for...
May 26, 2011 at 2:10 pm
Viewing 15 posts - 16,066 through 16,080 (of 39,970 total)