Viewing 15 posts - 7,081 through 7,095 (of 39,833 total)
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
There's no good way to size the log and tempdb for a database. The amount required isn't based on the data size, but rather the workload. How much activity can...
March 6, 2017 at 8:08 am
Try connecting with the dedicated administration connection (DAC). This has reserved resources if the server is too busy to respond to normal user requests.
March 6, 2017 at 8:06 am
If that's all that's in the trigger, I wouldn't expect a failure, but I always worry about lots of AND/ORs and something slipping through I didn't expect.
Do you...
March 6, 2017 at 8:00 am
Viewing 15 posts - 7,081 through 7,095 (of 39,833 total)