Hi,

you had to do a failover, to change the database owner. It is not possible to do this on the inactive node.

Kind regards

Andreas

Hi,

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

dbatools.io

There are a lot of usefull powershell command, one of them is backup & restore, and it is quite simple to...

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 5 years, 11 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