Thanks guys. This makes total sense for my scenario.

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...

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...

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...

Worked perfectly. Thanks!

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...

Perfect...Thank you!

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...

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...

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

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.

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...

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

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...

Bingo. Thanks!