It didn't on the other one, so probably not.

I'm going to see if I can get some expert opinions on this. I don't actually know how to fix this...

Possibly more accurate to say, "If Rows Sampled is much less than Rows and you are dealing with a large table and you have a non-uniform data distribution, then...

Then there's a second SQL instance on the box, and we may be messing with its files, instead of the broken instance's files. Don't touch anything in the mssql/data folder.

Does...

Don't know for sure. I'm just guessing here.

Is there another instance of SQL on that box? (check in the services screen)

Are the files marked as read-only (right-click, properties)

Performance of what? Log backups? Database backups? Normal operation?

Frequency of log backups isn't determined by performance. It's determined by how much data you are willing to lose if the server...

Dunno if it'll help, but worth a try before we resort to more drastic measures

Can you move the files

model$4IDR

modellog$4IDR

msdb$4IDR

msdblog$4IDR

somewhere else? Don't delete them, just...

Did you come right then?

The database 'model' is marked RESTORING and is in a state that does not allow recovery to be run.

The database 'model' could not be opened. She is in restoration.

The...

I'd be more concerned right now with the message in the log

What's...

First thing is to log in. Just try the sqlcmd without any -q and see if you can get a connection to the server. If not, is it saying that...

Two quick comments. Raid 10 if possible for logs and data. If not possible for both then is recommended for logs.

With multiple instances it is not a good idea...

Looks like this is the syntax. Can't test. Don't have any named instances around.

If you're using windows authentication

sqlcmd -S servername\instancename -E -A

If you're using SQL authentication

sqlcmd -S servername\instancename -U...

Off hand, I don't know. What does Books Online say? 😉

Connections via the DAC don't fire login triggers. From management studio, open a new query and specift admin: before the server name (admin:MyServerName) and use windows authentication. You must be...

Is the database set to autoclose?

Are there any databases on the server that are the target of a logshipping scenario (getting logs restored regularly)?

Is there a scheduled job that's freeing...