Hi,

just take a look to dbatools.io.

With a few commands you are able to copy database, jobs and logins from server a to server b.

It is realy simple.

Kind regards,

Andreas

Hi,

if you like powershell, take a look at this link:

https://docs.dbatools.io/

With this powershell you are able to migrate from the old to the new server with just a view powershell command.

You...

Hi,

no, you need not to create the ag new from scrath, you only have to add the 3rd node to the aoag. You can do this via gui or script:

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/add-a-secondary-replica-to-an-availability-group-sql-server?view=sql-server-2017

Kind...

• This reply was modified 6 years, 8 months ago by andreas.kreuzberg.

Hi,

your database won't be smaler, only be deleting rows.

You have to shrink your database, if you need space on your drive. But if you shrink your datase, you may get...

Hi,

we've got a lot of sql server. Every server has a downtime, in this downtime windows updates, sql cu are installed. First in the test / eval enviromnment, and the...

Hi,

check your SPN in the windows directory. We had the same issue a view days before.

There were some SPN missing, and some were wrong.

Goodl luck,

Kind regards,

Andreas

Hi,

I think, there are missing permission in the msdb database:

Just take a look:

https://community.spiceworks.com/how_to/131734-configure-a-user-to-create-and-manage-sql-server-agent-jobs

Kind regards,

Andreas

Hello,

thanks for your input, I try to understand everything arround the CEIP.

We only use enterprise edition, so we are able to turn the local audit off, just change some values...

Hi,

it depends, some sql patches / updates you can install on the inactive node, but some updates / patches had to be installed on the active node.

With a cluster, you...

Hi,

I think, if you choose device, you can't choose source database. If you decide to restore from a backup file, why you would choose a source database?

Kind regards,

Andreas

Hi,

you can change this settings without outage / restart.

Kind regards,

Andreas

Hi,

could you tell us, how you fixed your problem?

Kind regards,

Andreas

Hi,

take a look at dbatools.io

You can copy your databases with one script from Server A to Server B, with or without user etc.

Kind regards,

Andreas

Hi,

it depends, always on synchronized the complete database, and with a transactional replication, you are able to replicate the objects that you need to create your report.

If you use always...

Hi,

is there something in the ERRORLOG?

What about the HA endpoints, are they running, have all accounts the connect to endpoint permission?

Are there local firewalls, are you able to test the...