Do you have SQL Server backups of the databases (master, msdb, and user dbs)?  If so, reinstall MSDE, then you can restore all the dbs to the new installation.

If there...

Be sure to change the recovery model of your Master database back to Simple.  Otherwise the log will grow continually.

Steve

I don't think its a SQL Server (as in database engine) problem, but rather an Enterprise Manager problem.  I would try re-installing the client tools.

Steve

I fought this day after day, clicking on "This is not spam".  I finally realized that somebody is clicking on "This is spam" for every time I said its not. ...

Ooh, John, I was gonna say 1200 baud.

Steve

Farrell,

I don't think we're in disagreement at all, and that's what I was trying to point out.  In my initial post, it was all about who (me or the gov't)...

You're not trying to restore Master are you?  In many cases where a restore gives that error, its the user doing the restore that blocks it.  Be absolutely sure that...

Farrell,

"Those who value cutting expenses in order to increase the bottom line will pay in as little as possible and owe the greatest amount come April 15.  They gain the...

"Actually, I am receiving a very large check back from the federal government for 2004 taxes, but I am complaining because throughout the year I pay too much out of...

Ok, I've built up to this for a very long time, I'm nervous, scared, shaking,... I think I can do it. I think I can, here it goes..... ARGH! Almost. ...

Wow!  Frank, Congratulations!  It is soo cool to see someone as willing to help as you are to be recognized in such a way!  Well deserved!

Steve

(Oh, and I'll post in...

If its in rollback, you did successfully kill it.  SQL is basically "undoing" what it had done so far, and it will probably take roughly the same amount of time...

Jim,

The control table is not for tracking history, its for controlling the behavior of the backup procedure.  It tells the procedure which databases to backup (I can put an...

Frank,

That's true, but it's perfectly valid for what he's trying to do now, and for any "legacy" SQL 2000 instances after 2005 comes out!

Steve

Are you shrinking a data file or transaction log file?  If there are active transactions, it can't shrink beyond those.  Also, a transaction log is made up of multiple virtual...