Thanks guys that worked great! I was just in the middle of getting the data when I got the second email. Should have included in the first place. Thanks

Quinn

I took a look at that earlier today.

Here is the result.

select name, log_reuse_wait, log_reuse_wait_desc from sys.databases

master4ACTIVE_TRANSACTION

tempdb0NOTHING

model2LOG_BACKUP

msdb0NOTHING

AdventureWorks1CHECKPOINT

ReportServer2LOG_BACKUP

ReportServerTempDB2LOG_BACKUP

AdventureWorksDW0NOTHING

KoochData0NOTHING

TestingFromRestoreSSExpr0NOTHING

KoochVector0NOTHING

KoochRaster0NOTHING

ResTest2LOG_BACKUP

I am not sure if 0 on koochVector is a bad thing or if...

We do back ups every night.

How do you make a log file back up?

The size of the hard drive is 366GB.

That looks like a good article Gail. I will read...

The size of the DB is 879000Kb and the log file is 53000Kb.

If I do a

DBCC SQLPERF(LOGSPACE)

It is at 5.2% full right now. The recovery model is full. Here...

That worked. I seem to have restored all of my privelges and that DB looks like it is good shape. I already changed all of the users to master as...

Bru

I can't get in their either. Same message. Do you think sp_attach_db from the query window would work?

Quinn

I can't get into the user properties screen to change my default DB.

Quinn

You are right about detaching the default. I changed the db name on the connection screen to get in.

Here is the message:

TITLE: Microsoft SQL Server Management Studio

------------------------------

Failed to connect to...

I am still getting some errors like when I try to bring up the attach screen. I can't even get into the error log to be able to get the...

Thanks Steve

I was able to get in changing the DB to master. I can see all of my DB's as well. Is it safe to try to attach the DB...

It must be a good carma week. We haven't had any error yet this week.

I did a restore of last nights backup to a db with a different name. Just...

I was gone the end of last week sorry about the delay.

I installed SQL server with the administrator user account for the server. I would think that has permissions for...

I am not sure how to check that. Maybe in configuration manager.

Thanks

Quinn

I was able to find a thread that said try running the sqlrun_tools.msi from disk 2. When I tried that it got to a point where it asked for another...

Gail

No more error messages.

That is interesting about auto close being set to true in express. I will have to keep that in the back of my cranium.

Thanks

Quinn