Viewing 15 posts - 7,021 through 7,035 (of 39,776 total)
From Microsoft, Triple-DES is the algorithm. I hope they update BOL soon.
March 7, 2017 at 8:43 am
OK, if you're going up from 2000, do that first. Go to 2005 and get there.
Then what I'd do is clear up your VLFs first. You can do...
March 6, 2017 at 11:51 am
Ah, some sort of SMS or Ops Manager inventory, right?
The problem I've seen with these is that the data isn't always clean. What you should check is some...
March 6, 2017 at 11:31 am
March 6, 2017 at 11:23 am
Really it's an article that talks a bit about the history of containers and how they differ from VMs. Essentially a container reuses much of the host kernal and base...
March 6, 2017 at 11:22 am
March 6, 2017 at 11:18 am
Is this SQL 2000 or 2008?
When you restore, you get the settings from the database backed up, but you can change your growth settings.
March 6, 2017 at 11:15 am
Was v_r_user in the join before? Or you added the column and the table?
March 6, 2017 at 8:55 am
I don't see the documentation anywhere, but I've asked MS for clarification.
It does say symmetric key, which in this day and age I'd hope would be AES, preferably...
March 6, 2017 at 8:52 am
I would guess there's a Data Domain process that uses the VDI interface to take a backup. However, the backup isn't going to a file, it's going to some identifier...
March 6, 2017 at 8:50 am
Are you rebuilding online?
March 6, 2017 at 8:36 am
I'm with Grant. I'd prefer you actually don't move the data.
If you had to, why another db? You could use a trigger to check for new numbers being...
March 6, 2017 at 8:35 am
For reference: STUFF
March 6, 2017 at 8:28 am
As Gail mentioned, the log backups are for DR and recovering your system from issues that affect your AG. You can move the log backups location without affect the AG
March 6, 2017 at 8:12 am
Yes, you can get SSMS 2016 (free, should work with 2008 R2.
Then: https://voiceofthedba.com/2015/12/16/tracking-logins-with-extended-events/
March 6, 2017 at 8:10 am
Viewing 15 posts - 7,021 through 7,035 (of 39,776 total)