Viewing 15 posts - 1 through 15 (of 127 total)
When you manually add databases to the AG (via backup / restore), you do it one database at a time. I'm planning on restoring one database and stopping there temporarily.
December 29, 2018 at 10:12 am
Just to follow up on this. I found out how this could happen. The BOL entry for UPDATE STATISTICS says:
We recommend against specifying 0 PERCENT or 0...
November 12, 2018 at 9:50 am
This will change the endpoint owner, but you may also run into the situation where the owner of the actual AG was no longer with the company. This query shows...
October 26, 2018 at 10:16 am
Bummer. Thanks to all three of you for thinking about this! If you all are stumped, I don't feel bad about not having a clue. Well, I kinda do, but...
September 5, 2018 at 7:08 am
Thanks for the research. There is definitely data in the table - over 9 million rows and they've been there for months, if not years. After posting this, I found...
September 5, 2018 at 6:39 am
I manage 120 SQL servers across our prod, dev, and QA environments. We are 100% virtualized.
May 11, 2015 at 10:26 am
Tushar Kanti (2/27/2014)
I tried it out myself this morning to check if the restore entry goes in backupset table but could not succeed in that. I have been using...
February 28, 2014 at 7:00 am
If the backup history tables have not yet been cleared, there is an easier way to find out if the restored backup came from a different server that doesn't involve...
February 27, 2014 at 11:05 am
It does not handle mount points. I do not have any servers utilizing those in my environment, so I have nothing to test against. Sorry.
Have not tried it with C:...
August 30, 2013 at 9:16 am
thadeushuck - Define "better off."
1. That's your call. It depends on your environment. This is a monitoring routine that I run overnight during a period of little system activity....
August 30, 2013 at 9:08 am
Pradeept - That sounds like a Windows security setting issue. It sounds like Windows is configured to not allow execution of PowerShell scripts. Check with your network guys and see...
August 30, 2013 at 8:58 am
You know, it's been so long I don't remember. Maybe delete them from your profile and if the problem persists, delete, move or rename them from others?
Shaun
January 13, 2013 at 1:21 pm
That statement runs without errors.
December 21, 2012 at 1:29 pm
Sorry - SQL 2008 R2 SP2.
Jason - yes - tried exporting from SSMS on my workstation, on the server itself. Tried accessing it using BIDS from both locations. Nothing works.
opc.three...
December 21, 2012 at 12:41 pm
Viewing 15 posts - 1 through 15 (of 127 total)