I may be wrong but it seems like the backup strategy was set up for the convenience of the people running it and not for the needs of the business.

The...

There is a lot that is not said in your question. I will focus mainly on high-level items in this reply.

My first experience of using a DB on a virtual...

• This reply was modified 3 years, 1 month ago by EdVassie.

You should be able to do this via the SKU upgrade option. It may even be possible to do it by changing the license key for a Standard Edition key.

You...

There has been a fair bit of high level stuff about how to use X, but no low level stuff about why it is there and why it is needed.

The...

If you have things called 'Development and Production' environments and 'Change Control' then SSIS environments can be useful.

A place I used to work had dedicated staff doing the Production implementations....

You said you have done a Copy Only backup. This may not be what you actually need.

Unless you really know what you are doing and the restrictions related to a...

Your AG listener needs to have a unique IP address. It should not try to share the address with a node or any other object.

Your client applications connect to the...

Part of your job is to tell management what is possible and what is not.

You may have a technical solution that merges job history, but it requires you to manipulate...

Fredrico's question is important. Why are you making this change. If it is needed why are you doing it as part of the DB migration.

You are doing a data format...

To link your applications to the servers use DNS aliases. I have used a two-tier setup of Application aliases and Failover aliases. See my post from July 11 for more...

First thing, you need to be very clear about the business problem and what you are trying to solve. Eventually you will have to ask for money to get this...

It may be time to experiment with a non-production implementation of your application.  Make a copy of your test DB and point the application at that.  Then apply all the...

It is difficult to get into almost any job unless you have experience in what you want to do. The best way is to do research and find employers who...

The scenario you want to do is something most organisations have faced. Unfortunately it is not possible to do it in a single step.

Any database that is in Full Recovery...

Can I suggest you also look at your application upgrade process.  The standard I have been used to is to minimise risk.

There should be no DB changes made that could...