Can't you specify that in a startup parameter if you need to?

MD (5/7/2008)

---

ONe question, are you backing up to a network drive. If so, bad choice as any small blip on the network will cause your backup to fail. ...

I don't see how querying it would hurt anything as long as you don't try to change data in it.

By stopping mirroring, you ran:

ALTER DATABASE SET PARTNER OFF?

If that's the case, you have to manually recover it:

RESTORE DATABASE WITH RECOVERY.

You mean the port SQL Server listens on? (1433 by default) I don't know if you can do it in script...SQL Server Configuration Manager is how I've always...

Get the same message as before...tells me the database is in use.

No idea. Since it doesn't show up anywhere I don't know how to tell.

Perry Whittle (7/23/2008)

---

Jason Shadonix (7/23/2008)

---

Interesting. I get the following message when I run that:

Msg 3101,...

I already tried dropping, it just says it doesn't exist.

And all this database is used for is a test DB to run a DBCC against. I really don't even...

Interesting. I get the following message when I run that:

Msg 3101, Level 16, State 1, Line 2

Exclusive access could not be obtained because the database is in use.

Msg 3013,...

That statement won't even parse.

I was wrong. Using sp_who I could see a couple of spids with that user with suspended status and 'create database' for the command. I tried killing them,...

I can't get the job to stop, but at the same time I can't see that user doing anything.

No, I can't find it in any list (in SSMS, or by hitting sys.databases).

Noting in the errorlog about it recovering. It shows it trying to attach and failing, but...

Oh, I agree that it should work. I was just saying it's been my experiance it's easier to spend 5 min. writing a quick script and plopping it into...

I've never had much luck with maint. plans in SQL 2005, especially before the service packs came out.

I'd make sure you have SP2 on your server, but other than that...