Hm,

if you search via google, this was the first hit:

https://seangallardy.com/model_msdbdata-and-log-model_replicatedmaster-and-log-what-are-they/

I think you will not be able to change the autogrowth settings for such a system database.

good luck,

Andreas

sorry,

wrong answer.....

• This reply was modified 4 weeks ago by andreas.kreuzberg.

Hm,

did you create the SA login during the sql server installation. If yes, you should know the password.

In the gui, where you can connect to the sql server wihtin the...

Hi,

what kind of permission got your account you are working on the sql server?

SysAdmin Role?

Are you able to create a database in the ssms gui?

And are you able to connect...

Hi,

maybe there is a difference between collection the data, and displaying the data in the report.

What kind of report do you use, pie  shart, table or something like that?

Good luck,

Andreas

Hi,

When you look around, there are two approaches. Tools with an agent, and tools without an agent. All tools bring some load, but usually, this load is negligible.

As my predecessors...

Hi,

yes of course, the entries in the table are from 2003. I think, the database was migrated many time to the newest version.

We did not dropped all users, because the...

Hm,

but the only exists in the view in the database, so this should be users, and not logins, or? Logins should exists on the server level, not in the database.

If...

Hi,

the users only exists in this view. I am not able to select them from sys.server_principals, or something like that.

So, I think they are orphaned, and so I am not...

Hi,

if I look at sys.database_principals, I am not able to see those users.

And, if I am not able to see the user, I am not able to drop them.

I think,...

Hi

just take a look at this stairway:

https://www.sqlservercentral.com/stairways/stairway-to-transparent-data-encryption-tde

Good luck,

Andreas

Hm,

I would delete your account and servername from your log.

Did you try to use the *.bak file to restore the database from a current backup from the link listet in...

Hi,

did you change the query window to SQLCMD Mode?

* 2. Open the script inside SQL Server Management Studio and enable SQLCMD mode.

* This option is in the Query menu.

And can...

Hi,

is your database e-mail activated?

If yes, you only need 2 steps.

1. select your autogrowth events
2. mail the result of the query

   (I found this code in the internet, it's not build...

Hm,

I just tried to activate the query store, and everythings works fine.

But I got the CU27. Maybe you should install the latest CU and check this issue again.

Best regards,

Andreas