Viewing 15 posts - 1 through 15 (of 40 total)
Thanks guys. This makes total sense for my scenario.
January 9, 2017 at 1:49 pm
For SQL Server, yes. For Windows, the team responsible told me that each VM needed its own license. I am going off of what they are telling me...
December 12, 2016 at 12:27 pm
Thanks guys! I think the dedicated instance per VM makes more sense from a DBA perspective. It's worth the cost of the extra Windows licensing for our purposes...
December 12, 2016 at 11:08 am
Thanks for the reply and the article. Good stuff.
I agree with your points. Additionally, I am going through the list on this page to figure out what I...
November 16, 2016 at 11:27 am
That sounds like it could work! My previous team abandoned this pursuit a long time ago, and I've since switched jobs. However, this may come in handy at...
October 18, 2016 at 3:18 pm
Alright. So this works great from the command line, but I can't get it to run from SQL Server Agent. My syntax is this:
cd "C:\Windows\System32\WindowsPowerShell\v1.0"
powershell.exe "cd 'Z:\MaintenanceScripts\Powershell'; .\ReplicationTopologyBackup.ps1 -sqlserver...
October 13, 2016 at 3:42 pm
Wow...super fast response!. I learned a ton about replication from this website a few years ago. I will give this a whirl. If it works out, I'll...
October 6, 2016 at 4:41 pm
Thanks for the replies!
There are no non-clustered indexes on that table, and I can't do an online rebuild because I am actually creating the index, not rebuilding it.
Thanks,
Clint
September 16, 2016 at 1:37 pm
Paul, I missed the comma-separated list functionality. That also accomplishes what I needed. Thanks for clarifying that.
I'll let you know once I get the key/cert script done.
September 14, 2016 at 1:55 pm
Wow. I wish I had found this about 3 weeks ago. I wrote my own procedure to create DB restore scripts based on our DR needs. However, yours...
September 13, 2016 at 3:25 pm
apparently I wasn't looking in the right places :w00t:
i was able to alter the script on the following page to do what I need:
http://stackoverflow.com/questions/3361163/automatically-create-scripts-for-all-sql-server-jobs
August 31, 2016 at 1:34 pm
Thank you. I have done quite a bit of googling, but haven't found what I'm looking for yet.
As for msdb, our current DR strategy is to actually restore the...
August 31, 2016 at 12:50 pm
Viewing 15 posts - 1 through 15 (of 40 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy