Have a look at this, see if it helps you at all

http://blogs.technet.com/sbs/archive/2008/07/11/cannot-access-company-web-after-installing-948110.aspx

Something else for you to try. I hope you're comfortable with command line tools

Open two command prompts on...

Starting SQL with -f works too. Had to do that once with a failed login trigger on a cluster. The DAC was set local only.

riga1966 (8/1/2008)

---

Looks like if you're added to the Administrators Group

on Windows 2000 server where SQL Server 2005 runs it doesn't mean

you're automatically granted the same kind of permissions on SQL...

Try starting the server in minimal config. From the command prompt

sqlservr.exe -f

I think that may allow the service to start. I know there's one switch that allows SQL to start...

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...