Hey everyone, I am amazed that my article led to so many posts, even if many have nothing to do with it.

I was just checking on the latest posts...

In SQL 2000 you can still set a db to emergency. You must use the following script to do so.

EXEC sp_configure 'allow updates', 1

RECONFIGURE WITH OVERRIDE

GO

update sysdatabases set status =...

I originally got my MCDBA on 2000 along with my MCSE and MCSA on 2000 OS. I certainly was experienced with Windows and would not have considered myself a paper...

Thanks GilaMonster,

I already had it working in a similar way but was trying to eliminate any sql injection as you mentioned at the bottom of your reply post. I still...

This worked. Thanks for the fix. If you know of any documentation that explains when to use the sql:variable syntax please forward. I will look around as well. Thanks again.

Mark...

It does go to the new location in the UI. However if you script it does not. Try running "create database TEST1". If you have not restarted your service it...

I am not sure why number 2 did not happen on its own. I was not rebuilding the log on its own.

I will try this. Did not know about it. Probably would have saved some time and wouldn't have to have used the data loss option.

I did take some notes as I was performing the steps. I also fully documented it immediately after completing. The dbcc took about 1 hour on this small (~2gb) db.

I do not recall if I tried that or not. I will give it a shot when i have some time and try to recreate the problem and attempt to...

Yes this is exactly what happened

This was on 2005. I do not know about 2000

They stopped the sql service then deleted the log file.

Funny you mentioned the stripe backup and the long standing backup dialog. Just last week I asked one of our engineers to get me a backup. Wouldn't you know he...

A shot in the dark here, but maybe its because its the 9th one. Can you delete one of the ones that work and try this one. I am curious...